Hi , I am new to Alteryx and facing issues with converting XML to JSON .Please help XML XX 30 YY 25 To convert to JSON in the below format { "root": { "person": [ { "name": "XX", "age": "30" }, { "name": "YY", "age": "25" } ] } }

XML to JSON Conversion

Hi , I am new to Alteryx and facing issues with converting XML to JSON .Please help

XML

<?xml version="1.0" encoding="UTF-8"?>
<root>
<person>
<name>XX</name>
<age>30</age>
</person>
<person>
<name>YY</name>
<age>25</age>
</person>
</root>

To convert to JSON in the below format

{
"root": {
"person": [
{
"name": "XX",
"age": "30"
},
{
"name": "YY",
"age": "25"
}
]
}
}

Academy

Accepted answers

Luke_C

Hi @nadiyanazeer

That's interesting. I can't say I've ever output to a json file, usually the JSON I create feeds into another API or downstream process within the workflow. That said, take a look at the solution to this post for an alternative approach: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Issue-with-output-to-json-adding-backslashes/td-p/821928

All comments

Luke_C

Hi @nadiyanazeer

Here's an example of how.

Parse the XML
Transpose the data
Build out the json fields
Use the json build tool

New Workflow2.yxmd

caltang

Thanks for sharing @Luke_C ! I'm bookmarking this for future reference.

@nadiyanazeer kindly mark Luke's suggestion as the accepted solution if it fits your needs. Thanks!

nadiyanazeer

Thankyou @Luke_C for your response with workflow and detailed steps! Its much appreciated. One quick query .When i tried it as a JSON file , I am getting it in the below format .

[

{

"JSON": "{\"root\":{\"person\":[{\"name\":\"XX\",\"age\":\"30\"},{\"name\":\"YY\",\"age\":\"25\"}]}}"

}

]

Luke_C

Hi @nadiyanazeer

nadiyanazeer

Thankyou @Luke_C for the above solution! This will definitely help me ! Cheers !

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335