How to get list of deleted vendors or jobs through Rest API

(0) Share

Report

Posted on by Dhanuddhara

I am following Business Central API for integration purpose. By using this document I was able create, update, delete and fetch objects like vendors and project. Now I need a list of vendors/ projects that has been deleted. I couldn't find any filtering option in documentation.

I tried to filter deleted vendors using last modified date time property, it won't give deleted objects but created and updated ones.

https://api.businesscentral.dynamics.com/v2.0/TENANT_ID/Production/api/v2.0/companies(COMPANY_ID)/vendors?$filter=lastModifiedDateTime gt 2021-08-11T00:45:58.00Z

All responses (1)

Answers (0)

Suggested answer

JAngle 159 on at

Like (0)

Report
Copy link

Link copied!

this isn't data that is maintained. You can enable a feature called "Change Log" which would track such things. You could then publish a web service for the page or create an API page to retrieve the information based on filtering.

Alternative would be to use Power Automate. Have it track the vendor table for deleted entries and pass the detail somewhere. I wrote a blog which handles a different overall topic but it shows how to cater for deleted records like the one's you're focussing on. Might be helpful: joshanglesea.wordpress.com/.../