250
Hello Everyone, my name is Taniguchi and i building an power bi with the audit records filtering only the segurity role entity because i want to exib in power bi who modified the security role and what was changed and when i enter in a audit register it shows a table or a associated record and i wish to show this in power bi. How can I access this table or the associated record.
How can i get this table ?
How can i get this associated record ?
Hi Tani Santos,
do the below Web API functions help you achieve your goal?
docs.microsoft.com/.../retrieveauditdetails
docs.microsoft.com/.../retrieverecordchangehistory
Some example queries of mine:
Assuming a security role record I want to query on = 5b57f61f-ff3b-e911-a820-000d3ab46296:
/api/data/v9.1/RetrieveRecordChangeHistory(Target=@Target)?@Target={%22roleid%22:%225b57f61f-ff3b-e911-a820-000d3ab46296%22,%22@odata.type%22:%22Microsoft.Dynamics.CRM.role%22}
/api/data/v9.1/audits?$filter=_objectid_value eq 5b57f61f-ff3b-e911-a820-000d3ab46296 (here you can get the auditid for use on below query)
/api/data/v9.1/audits(958858db-afe3-eb11-a7ad-281878af6700)/Microsoft.Dynamics.CRM.RetrieveAuditDetails()
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (