Unanswered

get version history of entities through api?

(0) Share

Report

Posted on by Ballzer0

Is it possible to lookup the histories of entities or spesific records through the api?
it would be amazing if i could send a request like this. And it would return a snapshot of what the data looked like.

GET: https://myORG.api.crm4.dynamics.com/api/data/v9.1/cr0ad_someEntity?$history='10/7/2019'

And it would return what the data looked like at that time. Or is there maybe a feature that lets me lookup the change history of a specific record?

Thanks for your time. Its greatly appreciated

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (1)

v-siky-msft on at

Like (0)

Report

@Ballzer0

Although I don't have experience with APIs, if you want to get the history records, the only way I have found to do this is by turning on the Audit setting for the entity.
Then maybe you can try to retrieve the Audit Details by RetrieveAuditDetails Function using Web API. Reference: https://docs.microsoft.com/en-us/dynamics365/customer-engagement/web-api/retrieveauditdetails?view=dynamics-ce-odata-9
Hope this helps.
Sik

Was this reply helpful? Yes No
Kestenholz 38 on at

Like (0)

Report

.

Was this reply helpful? Yes No
Verified answer

Kestenholz 38 on at

Like (1)

Report

The Audit log is possible to retrieve from CDS e.g. in Power BI. However it will end up in the hundreds of MBs so really not an option. If you are looking for a way to capture historic data to track changes over time, I would suggest to setup a simple "scheduled flow" that copies values from your entity to a shadow entity. Make sure you also drop the UID value of the entity you copy from. This way, you can both see the historic values in a subgrid on the original entity form, or pull it into Power BI for Desktop in a snap.

Was this reply helpful? Yes No
Ballzer0 53 on at

Like (0)

Report

when you say drop the UID? i assume you mean i should copy the uid into another field called originalid or something like that, that way i can trace back what shadow entities trace back to the original one?

Was this reply helpful? Yes No
Kestenholz 38 on at

Like (1)

Report

Yes exactly! This way you can easily join the data later on in Power BI.

Was this reply helpful? Yes No
Ballzer0 53 on at

Like (0)

Report

thanks for the suggestion. im a bit afraid of how fast my dataset is gonna grow, but i think this is the best solution.

Was this reply helpful? Yes No
aKnowledgeWorke 11 on at

Like (0)

Report

How do you retrieve audit from CDS? I'm unable to see it, and I understood that it was not exposed to PBI or the Data Export Service (Dynamics)? I had to use an Azure Data Factory pipeline to see it and export it. Am I missing something?
cheers,
Steve.

Was this reply helpful? Yes No