topic Re: Unable to iterate through multiple level fields in JSON file in Talend Studio

Unable to iterate through multiple level fields in JSON file

Anonymous — Wed, 07 Oct 2015 07:58:20 GMT

Hello,
Below is my sample JSON file,

{
"merchant":[ {
"_id":"ObjectId(55e3d639d118e6c24ee116f6)",
"name":"???? ??????",
"description":"???",
"website":"",
"taxonomy":"??,??,???",
"merchantLocation": [ {
"location":"china"
},
{ "location":"australia"}
]
}]

}

This is the output i get,

|_id |name |description|website|taxonomy |location|
|=---------------------------------+-----------+-----------+-------+---------+-------

|ObjectId(55e3d639d118e6c24ee116f6)|???? ??????|??? | |??,??,???|china |

But I expect another row as output for location=australia.

Attached the talend mapping for your reference. Please help.

Thanks,
Satheesh

Re: Unable to iterate through multiple level fields in JSON file

Anonymous — Wed, 07 Oct 2015 09:45:29 GMT

I believe your "Loop" should be set to "/merchantLocation" in order to achieve this. Take a look at this example provided by Talend....
https://help.talend.com/search/all?query=tExtractJSONFields

Re: Unable to iterate through multiple level fields in JSON file

Anonymous — Fri, 09 Oct 2015 10:31:43 GMT

You should review JsonPath: http://goessner.net/articles/JsonPath/

Re: Unable to iterate through multiple level fields in JSON file

Anonymous — Tue, 13 Oct 2015 09:19:48 GMT

Thanks for the comments.. It worked!