I'm sure there's an easier way to how I've done it, but it works.
See full flow below. I'll go into each of the actions.
Data is a Compose that contains your data.
XML is a Compose that converts your JSON data to XML so we can use XPath. Note that it also adds a root element to ensure it's valid XML. The expression used is:
xml(json(concat('{"root": { value:', outputs('Data'), '}}')))
This will give us the following XML output.
<root>
<value>
<crd6a_set_w_flow_low_bypass_time>300</crd6a_set_w_flow_low_bypass_time>
</value>
<value>
<crd6a_ismodified>true</crd6a_ismodified>
</value>
<value>
<crd6a_set_med_bank_press_max>80.3</crd6a_set_med_bank_press_max>
</value>
<value>
<crd6a_set_low_bank_press_max>256</crd6a_set_low_bank_press_max>
</value>
</root>
Initialize variable data creates a new variable called data of type Object set initially with an empty object. This will eventually contain your single object with all the properties.
Apply to each iterates through each of the properties within your objects using the following XPath expression.
xpath(outputs('XML'), '//value/*')
Add Property is a Compose that adds each of the properties and values to the data object. It uses the following expression to get the name and value and add them.
addProperty(variables('data'), xpath(items('Apply_to_each'), 'name(//*)'), xpath(items('Apply_to_each'), 'string(//*/text())'))
Set variable data then sets the new output to our data variable.
Finally, Compose displays the contents of our data object.
After running the flow, we get the following output.
----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.
