The next is to parse this JSON array for which I am using the Parse JSON action. When I run the flow, below is the output of the above step.Īs you can see, Product has been converted to array in JSON and the attribute Name has been identified as well.

And then use the json function to covert it into JSON string. json(xml(outputs('Compose')))Īs you can see the expression above, I first convert the XML string into XML object using the xml function. In the next step I use the Compose action again to convert the XML string to JSON string. And then use the Compose action to hold the XML string. Let’s see how we can do it.įor this I use a simple Power Automate flow with manual trigger. For example, Name is an attribute of Product tag and each product has additional properties like Colors and Weight. And then you have properties and attributes as well. Īlthough quite basic, the XML has virtually everything. For demo, I am using a pretty simple XML here. There is an OOB function available in Power Automate which does exactly the same. If you are thinking I am going to show you something really hard here, you are in for a surprise. How do you convert XML string in JSON object? String xml = xmlMapper.So here I am back with another blog on Power Automate and again one simple but widely used functionality. ObjectNode objectNode = jsonMapper.readValue(json, ObjectNode.class) JsonMapper jsonMapper = new JsonMapper()

void testXmlToJson() throws IOException ' Once we have the POJO, we can write it to JSON format as any regular class. After we have the XML string, we can use XmlMapper to parse into POJO. We can read the XML from various sources, even from an API call.

Parse xml to json