topic Re: Make a JSON file in Talend Studio

Make a JSON file

aviralagl — Sat, 16 Nov 2024 05:30:10 GMT

Hi,

My database has the following format of data:

100 en abc@xyz.com aaa lmn pqr

100 de abc@xyz.de aaa lmn pqr

100 nl abc@xyz.nl aaa lmn pqr

100 fr abc@xyz.fr aaa lmn pqr

100 it abc@xyz.it aaa lmn pqr

I would like to create a JSON file like the following:

[ {

"id" : "100"

"attr1" : aaa

"attr2" : lmn

"attr3" : pqr
"attrRoot" : [ {

"locale" : "en"

"link" : "abc@xyz.com"

{

"locale" : "de"

"link" : "abc@xyz.de"

{

"locale" : "nl"

"link" : "abc@xyz.nl"

{

"locale" : "fr"

"link" : "abc@xyz.fr"

{

"locale" : "it"

"link" : "abc@xyz.it"

}]

}]

I am able to achieve the format and the data correctly, but since I am iterating the rows, I get the same data (as shown above) 5 times, for every row corresponding to the "id".

Re: Make a JSON file

Anonymous — Mon, 24 Jun 2019 14:59:27 GMT

Hi,

I am getting an invalid JSON when I am trying to validate it. Could you please share the JSON which pass the JSON validation process?

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: Make a JSON file

aviralagl — Mon, 24 Jun 2019 15:05:56 GMT

Sure, here it is:
Also attached an image

[
{
"id":"100",
"attr1":"aaa",
"attr2":"lmn",
"attr3":"pqr",
"attrRoot":[
{
"locale":"en",
"link":"abc@xyz.com"
},
{
"locale":"de",
"link":"abc@xyz.de"
},
{
"locale":"nl",
"link":"abc@xyz.nl"
},
{
"locale":"fr",
"link":"abc@xyz.fr"
},
{
"locale":"it",
"link":"abc@xyz.it"
}
]
}
]

Re: Make a JSON file

aviralagl — Mon, 24 Jun 2019 15:10:08 GMT

I also forgot to mention - I am trying to achieve the result using tJSONDoc custom components

Re: Make a JSON file

Anonymous — Mon, 24 Jun 2019 16:01:29 GMT

Hi,

Since you are using a custom component, I would recommend to contact the corresponding Talend community member who has developed this component.

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: Make a JSON file

aviralagl — Mon, 24 Jun 2019 16:06:00 GMT

@llicould you assist?

Re: Make a JSON file

Anonymous — Mon, 24 Jun 2019 16:09:25 GMT

Yes I can. Send me your desired json and which sources you have (e.g. some csv example files) and I will provide an example job.

jan.lolling@gmail.com

Re: Make a JSON file

aviralagl — Mon, 24 Jun 2019 16:44:06 GMT

Thanks for the quick response, I just send them to you as a message. Please check.