Solved

How to receive deleted customers from Acumatica via API

  • 7 December 2021
  • 7 replies
  • 258 views
A
Rank
Userlevel 1
Badge

Hello Team,

Could you clarify, is it possible to receive deleted customers from Acumatica via API?
If yes, which endpoint (screen) it is necessary to use?

I opened Web Services Endpoints and didn’t find here the necessary endpoint.


Thank you!

icon

Best answer by jinin 7 December 2021, 09:34

View original

7 replies

J
Rank
Userlevel 7
Badge +11

Hi @Andrew1986 

Please try like below,

 

Method: Delete

URL: Url/entity/Default/18.200.001/Customer/CUST01(provide customer Name)

Request: No Request

 

Jini N
A
Rank
Userlevel 1
Badge

This example to remove the Customer or to receive removed customer from Acumatica?

Also I see you send the Customer ID in the request.
Is it possible to specify a period in the request and receive deleted customers by the period?

Thank you!

J
Rank
Userlevel 7
Badge +11

Hi @Andrew1986 

The above request to delete customer. Not receive the deleted customer records from Acumatica. I will check and update you.

Jini N
A
Rank
Userlevel 1
Badge

Okay, thank you!

J
Rank
Userlevel 7
Badge +11

Hi @Andrew1986

Please find the below approach. It may help you.

  1. Create a GI with Customer table and add the date Filter condition and the DeletedDatabaseRecord as true.
  2. Check the Show Deleted records checkbox 
  3. Create a endpoint with the GI 
  4. Make a API call.

Url: Url/entity/EndpointName/20.200.001/DeletedCustomer?$expand=DeletedCustomerDetails

Method: PUT

Request:

{

    "FromDate": {

        "value": "2021-12-01"

    },

    "ToDate": {

        "value": "2021-12-10"

    }

}

 

Jini N
Naveen Boga
Rank
Userlevel 7
Badge +17

Hi @Andrew1986  There is NO default REST API is available to fetch the deleted customers.

As mentioned above by Jini, to get the deleted customers we need to come up alternate option to create a simple GI for deleted customers and make an API call to GI to fetch the results.

Naveen B
A
Rank
Userlevel 1
Badge

Team,

Thank you a lot!

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved