Delete sales person returns sql error

[adrianm]

Trying to delete a sales person from a customer

PUT: https://integration.visma.net/API/controller/api/v1/salesperson/00029
Headers: {
    Accept: application/json
    Authorization: <hidden>
    ipp-application-type: Visma.net Financials
    ipp-company-id: 1074184
    Content-Type: application/json; charset=utf-8
    Content-Length: 68
}
{"customers":[{"operation":"delete","customerID":{"value":"5333"}}]}
Response: 500 Internal Server Error
Headers: {
    Strict-Transport-Security: max-age=31536000; includeSubDomains    Strict-Transport-Security: max-age=31536000; includeSubDomains
    ipp-request-id: f93e0f81-9b1a-46cd-bff0-44e8a1cc0d53
    X-Content-Type-Options: application/json
    Pragma: no-cache
    X-Handled-By: Visma-PX.Export/AuthenticationManagerModule
    Referrer-Policy: origin-when-cross-origin
    VnfInstanceId: ERP_SE_REAL_0026
    X-XSS-Protection: 1;mode=block
    Connection: close
    Transfer-Encoding: chunked
    Cache-Control: no-cache
    Date: Fri, 24 Feb 2023 11:03:30 GMT
    Set-Cookie: <crumbs>;  path=/;  secure;  expires=Thu, 23-Feb-2023 11:03:30 GMT;  HttpOnly
    Server: Apache/2.4.52    Server: (Debian)    Server: OpenSSL/1.1.1n
    Content-Type: application/json; charset=utf-8
    Expires: -1
}
{"message":"VismaId: f93e0f81-9b1a-46cd-bff0-44e8a1cc0d53. Error updating salesperson. The multi-part identifier \"Customer.GroupMask\" could not be bound.\r\nThe multi-part identifier \"Customer.GroupMask\" could not be bound."}

[adrianm · Accepted solution]

Never mind.

It was a one-time thing to help a customer with some register cleaning.

They did the changes manually instead

[Yıldırım]

Alright, thanks for the confirmation then ! 

[Yıldırım]

Hello, are you constantly receiving the same error with the same request ? Are you able to delete the line manually ? 

[adrianm]

Thank you for the response.

Yes on both questions.

[Yıldırım]

Could you please send the ipp-company-id via developersupport@visma.com ?