How to convert XML TO JSON

Like (0) Share

Report

Posted on 12 Jun 2024 09:07:56 by URU123

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>

Categories:

All responses (2)

Answers (0)