Solved

How to receive deleted customers from Acumatica via API

  • 7 December 2021
  • 7 replies
  • 87 views

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

Userlevel 6
Badge +3

Hi @Andrew1986 

Please try like below,

 

Method: Delete

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

Request: No Request

 

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!

Userlevel 6
Badge +3

Hi @Andrew1986 

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

Badge

Okay, thank you!

Userlevel 6
Badge +3

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"

    }

}

 

Userlevel 7
Badge +12

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.

Badge

Team,

Thank you a lot!

Reply


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 — 2020  Acumatica, Inc. All rights reserved