Saturday, January 7, 2023

How to convert a xml into xml through azure logic apps

Create XSLT from the Link [Note: Go through the XSLT code once as it may be wrong in case of loops]

Now create an XSD of the output XML from the Link

Now go to the Azure portal and create an Integration account

In the "Maps" section of the integration account, upload the XSLT that was developed in the above steps


Now go to "Schemas" section of the integration account and upload your XSD that was developed in the above steps


To test the transformation of XML, create a logic app and in the "workflow settings" of the logic app, update the Integration account that we created in the earlier steps

In the logic apps add a trigger "When a blob is added or modified" for testing the file, it should look like below


Now add "Get blob content", in this set the path of the XML file, it should look like below
Now add transform XML and set the content from the previous action and set the name of the map that we created in the above steps


Now create a compose action and send the body from the above action to see the output or you may save it in a new storage account.


Now create an "XML Validation" action in the logic app to validate the output XML