Iterate on JSON array

One Star

Iterate on JSON array

Hi to all, I've a JSON file like this one:


I need to get an unique record with "codiceCatastale" and "cap". So, like this:
|A001           |35031|
|A271           |60121|
|A271           |60122|
|A271           |60123|

I try with tExtractJSONFields with success...

Any suggestions?
Thanks a lot
Community Manager

Re: Iterate on JSON array

Using a tFileInputJson component to read this json file, set the Loop Json query to "/cap", then you should be able to extract codiceCatastale and cap value. 

Talend | Data Agility for Modern Business