topic Re: Talend Open Studio for Big Data: How to input JSON records and output same number of records in XML in Talend Studio

Talend Open Studio for Big Data: How to input JSON records and output same number of records in XML

Anonymous — Sat, 16 Nov 2024 06:21:17 GMT

Hello, Newbie here. I'm trying to get the same number of records I ingested on the JSON file on my XML output. I'm doing something wrong! what is it? Pretty sure it's something really simple, but this being my first time, I fail to see it. Note that I did a lot of research, to no avail. I'm hoping you can help me here!! TIA very much!!

JSON:

{"patientCollection":[{"patient_id" : "370fd70",
"name" : {"family" : "Sommers", "given" : "Jane"},
"phone" : "1-223-223-87476 x 320",
"address" :{"streetAddressLine1" : "35108 Palms Junction", "streetAddressLine2" : "Apt. 436","city" : "Miami","state" : "FL", "postalCode" : "00002","country" : "US" }
},
{"patient_id" : "370fd90",
"name" : {"family" : "Jones","given" : "Sarah" },
"phone" : "1-703-246-3200",
"address" :{"streetAddressLine1" : "3491 Saffron Circle","streetAddressLine2" : "Apt. 130","city" : "Arlington","state" : "VA", "postalCode" : "00007", "country" : "US" }

} ]}

Resulting XML: the 2 records in one tag. I need to separate and put each patient data in separate tags)

These are the screenshots of my work:

Re: Talend Open Studio for Big Data: How to input JSON records and output same number of records in XML

Anonymous — Wed, 13 Mar 2019 19:56:10 GMT

Hi,

Could you please first print and check whether the output of JSON file read is giving correct output?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Talend Open Studio for Big Data: How to input JSON records and output same number of records in XML

Anonymous — Wed, 13 Mar 2019 20:57:18 GMT

Oh! I don't know how to do this....All I can see is the fields in the map and those are correct, and the previewer as in this picture. I hope this helps to answer my question....?:

Re: Talend Open Studio for Big Data: How to input JSON records and output same number of records in XML

Anonymous — Fri, 15 Mar 2019 10:31:36 GMT

Hi,

Please refer the details below.

The component details are as below.

Output component is as below.

Output is as shown above. Hope I have answered your query.

Please remember to mark the topic as resolved as it will help others in Talend community.

Kudos will be a bonus from your end 🙂

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Talend Open Studio for Big Data: How to input JSON records and output same number of records in XML

Anonymous — Mon, 18 Mar 2019 18:25:04 GMT

Thank you so much! I was able to run it with your advice.