topic Re: JSON parsing multiple nested arrays in Talend Studio

JSON parsing multiple nested arrays

Anonymous — Mon, 08 Apr 2019 23:33:17 GMT

Hi, I am trying to parse below json, which has multple nested lists (input & output), how do I parse it ?

{
"status":"current",
"entry":[{
"item":{
"name":"Task1",
"identifier":"T00001",
"input":[{
"type":{
"text":"InputTask1-1"
},
"valueString":"Weekly"
},
{
"type":{
"text":"InputTask1-2"
},
"valueString":"Daily"
}
],
"output":[{
"type":{
"text":"OutputTask1-1"
},
"valueString":"Daily"
},
{
"type":{
"text":"OutputTask1-2"
},
"valueString":"Weekly"
}
]
}
},
{
"item":{
"name":"Task2",
"identifier":"T00002",
"input":[{
"type":{
"text":"InputTask2-1"
},
"valueString":"Weekly"
},
{
"type":{
"text":"InputTask2-2"
},
"valueString":"Daily"
}
],
"output":[{
"type":{
"text":"OutputTask2-1"
},
"valueString":"Daily"
},
{
"type":{
"text":"OutputTask2-2"
},
"valueString":"Weekly"
}
]
}
}
]
}

Looking for delimited output file like this:

Re: JSON parsing multiple nested arrays

Anonymous — Mon, 08 Apr 2019 23:42:46 GMT

Re: JSON parsing multiple nested arrays

Anonymous — Tue, 09 Apr 2019 06:51:44 GMT

HI,

I have used your input JSON file as reference and I got the following output using the job in below format. You may have to make minor changes based on your specific use case but it will give you a break through.

Coming to the component details, please refer the screen shot below for each component and schema details.

Hope you got the path to resolve your use case. Please mark the topic as resolved if you are happy with the details. Kudos are also welcome 🙂

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: JSON parsing multiple nested arrays

zalibra — Tue, 08 Oct 2019 20:07:01 GMT

Hi Nikhil,

So I was able to parse a multi-nested JSON but have 2 questions:

1. When parsing the data points in the second JSON, I'm getting double quotes and square brackets in the results (screenshot: Result.png). How do I parse these out in tExtractJSONFields? (I can use tReplace as a workaround but was wondering if this could be done in tExtractJSONFields)

2. If you check out the JSON.png, you'll see there are two instances of minQty and maxQty, one under filterType: "LOT_SIZE" and another under filterType: "MARKET_LOT_SIZE". Is there a way I can specify in tExtractJSONFields which one to select? For example, if I want to say pick the first one but ignore the second, how do I do that? Or if I want to say parse "LOT_SIZE" and ignore "MARKET_LOT_SIZE", how do I do that?

Job.png
JSON.png
Result.png

Re: JSON parsing multiple nested arrays

Anonymous — Sun, 13 Oct 2019 18:15:30 GMT

@zalibra

Since your query is for a different use case, I would recommend to create a new post so that we will not dilute the original post context. While creating the post, please also add 5 sample input records, expected JSON output and current output you are getting.

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