dynamicsnavax: Data Management Export - XML to JSON Transformation
In my last post, I wrote about event based integration using Business Events. I used JSON as my export file type. JSON is a lot easier to work with in Microsoft Flow or Azure LogicApp.
Below is how I achieved it.
Data Management framework doesn’t do JSON by default. However, it does do XML file format.
A bit of googling and trial and error. I found this XSLT code that transformed XML to JSON.
Here is the authors blog post to give credit.
Under the Data management workspace, open the Source data format form. Create new record called JSON and set the default extension to json.
Create a new Export and select your entity. In the Source data format, select JSON record that was created in the previous step.
Now click on the View map icon.
In the mapping form, click on the Transformations tab. Then upload the xslt file you downloaded from the github.
That's it for the set up. Now to run it.
Normally when you export and XML file. It looks like this:
Once the transformation is applied, you get a JSON file like this.
This is great because I like to use Microsoft Flow or LogicApps to read the files to process. With XML you have to use XPATH or figure out otherwise to read it.
This works very nicely and no development or extra transformation at the target.
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
|dennis365foroperations: Yes, it’s here! The Copy configurations feature (and a look at other improvements related to Data Management)||Blog bot||DAX Blogs||0||12.10.2017 16:11|
|patrickmouwen: 1yr with AX7 Data Management – My top 12 learnings||Blog bot||DAX Blogs||2||12.10.2016 15:14|
|emeadaxsupport: SEPA affected objects||Blog bot||DAX Blogs||0||29.11.2013 13:11|
|NAV Team: How to: Enable Import/Export of Bank or Payroll Files Using the Data Exchange Framework||Blog bot||Dynamics CRM: Blogs||0||18.10.2013 02:33|
|wiki.dynamicsbook: Changes Made in Navision Attain 3.60||Blog bot||Dynamics CRM: Blogs||0||02.09.2008 13:23|
|Опции темы||Поиск в этой теме|