Hi,
Can anyone help me how to convert XML data to JSON? or how to refer to parameters in XML?
I am getting xml data like this and needs to convert XML to JSON using Power Automate.
<?xml version='1.0' encoding='UTF-8'?>
<wd:Report_Data xmlns:wd="urn:com.workday.report/CR_Pay_Groups_Period">
<wd:Report_Entry>
<wd:Pay_Group wd:Descriptor="Hourly">
<wd:ID wd:type="WID">67fabc</wd:ID>
<wd:ID wd:type="Organization_Reference_ID">ABC</wd:ID>
</wd:Pay_Group>
<wd:Reference_ID>ABC</wd:Reference_ID>
<wd:PayG wd:Descriptor="Regular">
<wd:ID wd:type="WID">12345</wd:ID>
<wd:ID wd:type="Pay">Details123</wd:ID>
</wd:PayG>
<wd:Pay_Group_Detail_group>
<wd:Period_Schedule_for_Pay_Group_Detail wd:Descriptor="Weekly">
<wd:ID wd:type="WID">9c78087f1df41006d1c329f5097a0000</wd:ID>
<wd:ID wd:type="Period_Schedule_ID">Bloom_Biweekly_M</wd:ID>
</wd:Period_Schedule_for_Pay_Group_Detail>
</wd:Pay_Group_Detail_group>
</wd:Report_Entry>
</wd:Report_Data>
