Parsing XML data to Json

[ODridi]

Hello,

I need to parse XML data to Json data

Do you have any idea how to do it ?

This is my input :

<root>

<patient>

<name>

Andréa

</name>

</patient>

</root>

I tried to use the tFileInputJson and pass the URL of the xml file but it didn't work

but I got the following error :

fail to parse the json files

Thank you

[Anonymous]

Hi

tFileInputJson is used to read a Json file, it can't read a XML file. You should use tFileInputXML to read the XML file, then, create a Json file using tFileOutputJson or use tWriteJsonField to generate a Json string.

Regards

Shong