Converting complex JSON to XML

unTalended — Sat, 16 Nov 2024 01:50:55 GMT

Hello everyone,

actually I am struggeling to figure out how to convert following JSON-structure (in an file) to an equivalent XML-structure to save it also in a file.

My structure in the JSON-file:

{

"stations":[

{

"id":"5475",

"name":"Stationname_1",

"poles":[

{

"location":

{

"lat":36.4767361,

"long":12.4574503

"id":"54751"

}

]

{

"id":"1952",

"name":"Stationname_2",

"poles":[

{

"location":{

"lat":36.3712358,

"long":12.7045717

"id":"19521"

{

"location":{

"lat":36.3720289,

"long":12.7013738

"id":"19522"

}

]

}

]

}

How you can see the "stations"-attribute is an array including various amount of stations-objects. Every station-object is containing a "poles"-attribute which is also an array containing various amount of objects.

I created structures for the input and the output and also a mapping. The "stations" and "poles" attributes I configured as "sequence" group type.

Created mapping:

Configuration structure (dump):

My problem is that I am using tHMap the first time and have no idea how to configure it (

in "Talend Data Services Platform 7.3.1"), especially to handle the arrays, to get an solution. Also I doesn't know the configuration of tFileInputJSON is alright.

Configuration tFileInputJSON:

Can you also explain me why "id" wasn't connected? It is very confusing.

Connection map:

Sorry for my many questions! I would be very grateful for your help!

Friendly greetings

unTalended

Re: Converting complex JSON to XML

manodwhb — Wed, 05 Aug 2020 02:09:19 GMT

@not specified not specified , you need to read your json file using tFileInput and pass to the tHmap,if you have loop on the particular field it will pass a array when you have multiple values.

topic Re: Converting complex JSON to XML in Talend Studio

Converting complex JSON to XML

Re: Converting complex JSON to XML