Converting XML Format data to JSON Format and performing data Operations using Azure Logic app
TASK : Convert the XML format data into JSON Format and retrieve only the required data from it using Azure Logic apps. Sample XML data: This is the sample data, we need to convert this data into JSON first after that we need to perform Transformations. Expected output: Solution: Here I have taken a total of 4 activities HTTP trigger, Get blob content, and Compose. To trigger the logic app I have taken an HTTP trigger. Here I am retrieving an XML file from the blob by using the Get blob content Activity. After getting file content from the blog we need to convert the data format XML to JSON. So I have taken Compose activity and I have written Expression to convert XML to JSON. Expression : After this activity, the entire data will be converted into a JSON format as mentioned below But we need to get the data from ENO to Position Title for that I have taken one more Compose activity and there I have written one expression to get the required data. ...