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!
Answer
How to receive deleted customers from Acumatica via API
Best answer by jinin
Hi
Please find the below approach. It may help you.
- Create a GI with Customer table and add the date Filter condition and the DeletedDatabaseRecord as true.
- Check the Show Deleted records checkbox
- Create a endpoint with the GI
- 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"
}
}
+11Hi
Please try like below,
Method: Delete
URL: Url/entity/Default/18.200.001/Customer/CUST01(provide customer Name)
Request: No Request
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!
+11Hi
The above request to delete customer. Not receive the deleted customer records from Acumatica. I will check and update you.
+11Hi
Please find the below approach. It may help you.
- Create a GI with Customer table and add the date Filter condition and the DeletedDatabaseRecord as true.
- Check the Show Deleted records checkbox
- Create a endpoint with the GI
- 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
+19Hi
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 - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.