Dynamics Audit Transform changedata column

  • 21Views
  • Last Post 20 April 2023
0
votes
brendan dunleavy posted this 14 April 2023

Hi,

I am building a data flow package to extract Audit data from MS Dynamics.

I would like to extract the data from the 'changedata' column to transform all values into separate columns in my Query.

such as logicalName, oldValue, newValue

Is there a way this can be done please?

Thanks

Attached Files

0
votes
Serhii Muzyka posted this 20 April 2023

 Hi,

 

Thank you for contacting Skyvia Support.

 

We are sorry for the delayed response.

 

Unfortunately, we weren't able to find a solution for this scenario. Kindly describe us your full scenario in more details so possible we can advise something else. 

 

Thank you in advance and looking forward to hearing from you.

 

Best regards,

Serhii

Close