Posts

Showing posts from September, 2021

Transform XML in a Logic App

Image
Transform XML in a Logic App If you are integrating two systems through XML where none of the systems conform to the other we have to make the receiving system able to read the data. In this example we will transform XML from one schema to another. Get XSD files of your XML files If you have XSD files for your from and to XML structures, you can skip this step. Below are two sets of XML structures, they actually matches but they have different language. This for the simplicity of the example.  Generate XSD for each of the XML structures, this can be done here:  https://www.freeformatter.com/xsd-generator.html#ad-output Fom XML: <?xml version="1.0" encoding="utf-8"?> <products> <product> <itemId>ABC123</itemId> <itemName>ABC 123</itemName> <price>1</price> <unit>pcs</unit> </product> </products> To XML:  <?xml version="1.0" encoding="utf-8"?> <