Iterate on JSON array

[spassiatore]

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:

|=--+---=|
|codiceCatastale|cap|
|=--------------+----=|
|A001           |35031|
|A271           |60121|
|A271           |60122|
|A271           |60123|
'---------------+-----'

I try with tExtractJSONFields with success...

Any suggestions?
Thanks a lot
Stefano

[Anonymous]

Hi  
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. 

Regards
Shong