Announcements
Hello,
Is it possible to create API call that will return an audit trail (version control) for a specific table in Dataverse for all records in that table from environment's Audit log table. I need to export this data either through an API call or any other means.
I would like to note here that all API calls in MS documentation seem to run against a record (not table)
Thank you.
Is it a one-off activity so that you can export it manually? If so, there are a few tools and here are the useful link about those.
Or do you want to expose an API so that it can be consumed by another service to download periodically? If so, you will have to create a Dataverse custom API and include a logic implemented with a plug-in to retrieve the audit data using RetrieveRecordChangeHistoryRequest and RetrieveAuditDetailsRequest. There are a few sample codes from the community blog posts and you can also refer to the documentation at Microsoft Learn.
The business is leaning toward the second option (periodic download).
Please confirm for me that there is no easier way to do this then custom plug-in.
In other words, I have to create a plug in that will use the above two classes in order to retrieve CSV file that is storing changes on a particular Dataverse table.
There is a KingswaySoft SSIS Integration Toolkit for Microsoft Dynamics 365 (which works for any Dataverse environment) which comes with a license cost. I guess that would be easier than writing a custom API. Check out these links.
If the client prefers to spend the one-off development cost instead of an on-going licence for the ISV solution, you can build your own solution.
On second thought, Custom API was a bad idea since it is a long-running process and the plug-in will definitely timeout. It would be better to create a console application which has a date range (start date and end date input parameters). That console app will retrieve the audit data stored in the Log storage of the Dataverse environment. The console app will
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 505
WarrenBelz 502 Most Valuable Professional
Haque 324
