Exporting version control auditing records for a specific table in Dataverse

(0) Share

Report

Posted on by nemanjasovic011

240

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.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Linn Zaw Win 2,996 on at

Like (1)

Report
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.

https://nishantrana.me/2021/05/17/how-to-export-the-audit-history-values-from-dynamics-365/

https://mscrmonline.wordpress.com/2021/04/11/how-to-export-the-audit-history-values-from-dynamics-365/

https://www.linkedin.com/pulse/saving-space-extracting-audit-logs-microsoft-dynamics-slava-kostiuk/

https://linnzawwin.blogspot.com/p/audit-history-extractor.html

https://linnzawwin.blogspot.com/p/attribute-audit-explorer.html

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.

https://nishantrana.me/2018/10/31/using-retrieverecordchangehistoryrequest-to-get-audit-detail-in-dynamics-365-ce/

https://www.linkedin.com/pulse/retrieving-updating-audit-history-dynamics-365-using-c-mothiba-/

https://csharp.hotexamples.com/examples/-/RetrieveRecordChangeHistoryRequest/-/php-retrieverecordchangehistoryrequest-class-examples.html

Was this reply helpful? Yes No
nemanjasovic011 240 on at

Like (0)

Report

Thank you.

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.

Thank you.

Was this reply helpful? Yes No
Verified answer

Linn Zaw Win 2,996 on at

Like (0)

Report
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.

https://www.kingswaysoft.com/blog/2019/10/16/Extracting-Audit-Logs-for-Multiple-CRM-Entities

https://www.kingswaysoft.com/blog/2022/08/26/Archiving-and-Deleting-Dynamics-CRMCE-Audit-Logs-for-Efficient-Space-Management

https://nishantrana.me/2018/10/08/using-kingswaysofts-cds-crm-source-component-to-get-audit-information-in-dynamics-365-ce-ssis/

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

retrieve the data RetrieveMultiple where the "modifiedon" of the records that fall between the date range

for each record from the above result set, use the above two classes in order to retrieve the audit data related to that record

At the end of the extraction, the console app can save the data as .csv or any preferred format.

Was this reply helpful? Yes No