topic Re: Nested XML to JSON in Talend Studio

Nested XML to JSON

Nreimondo1645519314 — Fri, 15 Nov 2024 23:11:13 GMT

Hi,

I'm new to Talend and I have this issue. I have a XML like this:

<Users>

</Users>

</product>

And i have to convert this to a JSON. Does anyone know how to achieve this?

expected JSON-array:

[{"productCode":"Code1","productName":"Name1","Users":["User1","User2"]}]

Re: Nested XML to JSON

Anonymous — Tue, 22 Feb 2022 10:26:12 GMT

This method may work for you.....I haven't tested it since 2018 though. So it would be interesting to see how it works for you 😉

https://community.talend.com/s/question/0D53p00007vCjPdCAK/a-simple-way-to-convert-an-xml-string-to-json

Re: Nested XML to JSON

Nreimondo1645519314 — Tue, 01 Mar 2022 15:46:27 GMT

Unfortunately your link to the jar doesn't work anymore...

Re: Nested XML to JSON

Anonymous — Tue, 01 Mar 2022 16:23:23 GMT

I believe this one may work. It might need a slight refactoring of the code, but I suspect it probably won't.

https://jar-download.com/artifacts/org.json

FYI if you are looking for a Jar, look at the imports and Google an import package with "jar" at the end (in this case I Googled "org.json.jsonobject jar").

Re: Nested XML to JSON

Nreimondo1645519314 — Fri, 04 Mar 2022 12:27:19 GMT

Thanks it worked.

But now I need to extract the values of the productUsers.

I tried it with a tExtractXmlField with a loop on Users, but the result is only the first value (user1).

Is it unpossible because the tagnames are exactly the same and the number of users are different each product? any ideas?

Re: Nested XML to JSON

Anonymous — Fri, 04 Mar 2022 12:45:57 GMT

Are you using the tExtractXMLField with the JSON you have just created? If so, that won't work. You need to show more detail here. Maybe a screenshot of how you have set up your tExtractXMLField.

Re: Nested XML to JSON

Nreimondo1645519314 — Fri, 04 Mar 2022 13:24:48 GMT

No with the same XML as posted in my original question

Re: Nested XML to JSON

Anonymous — Fri, 04 Mar 2022 13:32:41 GMT

Do you have any screenshots of your configuration of the tExtractXMLField?

Re: Nested XML to JSON

Nreimondo1645519314 — Fri, 04 Mar 2022 13:39:04 GMT

I tried this, but this gives me one User instead of the expected two.

Re: Nested XML to JSON

Anonymous — Fri, 04 Mar 2022 14:25:28 GMT

Your loop needs to be.....

"/product/Users/productUser"

You will then need to tweak your other values as they will be at the level above.