JSON - Need help getting more than 1 row of data out

Nine Stars

JSON - Need help getting more than 1 row of data out

My job looks like:

tFileInputJSON > tFileOutputDelimited

 

I can get all the data for all the fields from the first JSON object fine, but I can't seem to make it loop through all the objects in the JSON file to get more than a single row of output.

 

I am trying to get all the data out for the device. In the fFileInputJSON, the Loop Json query is "$.device"

 

Here is a sample from the file:

{"xxxx":"000xxx00-0x0x-0x0x-xxx0-0x000x000000","xxxxxxxxxxxxxx":0,"xxx":{"xxxxxxx":"0.0.00.00000"},"xxxx":[],"device":{"xxxxxxxxxx":00,"xxxxxxxxxxx":"xxx\/x00x\/xxxxxx:0.0.0\/xxx00x\/00000000.000000:xxxx\/xxxxxxx-xxxx","xxxxx":"xxx","xxxxxx":"xxxxxx","xxxxxxxx":"xxxx","xxxxxxx":"xxx00x","xxxxxxxxxxxx":"xxx","xxxxx":"x00x","xxxxxxx":"x00x","xxxxxxxx":xxxxx,"xxxxx":"-0000_xxx_xxxx-0.00000.0.00000.0"},"xxxxxx":{"xxxxxxxxxx":"xxxxxxxxx","xxxxxxxxxx":"00.00.000.000"},"xxxxx":{"xxxxx":{"xxxxxxxxxxxxx":xxxxx,"xxxxxxxxxxxx":{"xxxxx":"xxxxxxx.xx.xxxxxxxxxxxx","xxxxxxxxxxxxxx":xxxxx,"xxxxxxxxxxx":xxxxx,"xxxxxxxxxxxxx":xxxxx},"xxxxxxx":{"xxxxxx":0,"xxxxxxx":0,"xxxxx":00,"xxxxxxxx":000,"xxxxxxx":xxxx,"xxxxxxxxxx":"xx-xxx","xxxxxxxxxxx":000,"xxxxxxx":0000}},"xxxxxxxx":{"xxxxxxxxxxxxxxxxxx":[{"xxxxx":"xxxxxxx.xxxxxxxx.xxxxxxxx","xxxxxxxx":"xxxxxxx","xxx":0000000,"xxxxxxxx":00.0000000,"xxxxxxxxx":-00.0000000,"xxxxxxxx":0,"xxxxx":0,"xxxxxxx":0,"xxxxxxxx":00.000}],"xxxxxxxx":00.0000000,"xxxxxxxxx":-00.0000000,"xxxxxxxx":00.00,"xxxxxxxx":0,"xxxxxxxx":0,"xxxxxxxxxx":"xxxxxxx\/xxx_xxxx","xxxxxxxxxxxxxx":-00000,"xxxxxxx":{"xxxxxxxxx":"xxxxx xxxxxxxx","xxxxxxxxxxx":"xx","xxxxxxxxxxx":"xxxxxx xxxxxx","xxxxxxxxxxx":00,"xxxxxxxx":00.000000000000000,"xxxxxx":"xx_xx","xxxxxxxx":"xxxxxxxxx","xxxxxxxxx":-00.000000,"xxxxxxxxxx":00000,"xxxxxxxxxxxx":"xxxxx xxxxxx","xxxxxxxxxxxxxxx":00,"xxxxxxxxxxxx":"xxxxxxxx xxxxx"}},"xxxxxxx":{"xxxxx":{"xx":0,"xxxxxxxx":0},"xxxxxxxxxxx":{"xxxxxxx":0.0000000,"xxxxx":0.00000000,"xxxx":-0.00000000}},"xxxxxxxxx":"0000-00-00x00:00:00.000-0000","xxxxxxx":{"xxxxxxxx":-0,"xxxxxxxxxx":xxxx,"xxxxxxxxxxxxxx":xxxxx},"xxxxxxxx":{"xxxxxxxxx":{"xxxxxxxxxxxxxxxxx":[{"xxxxx":"xxxxxxx.xxxxxxxxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxxx":0,"xxxxxxxxxxxx":0,"xxxxxxxxxxx":"xxxx 0","xxxxxxxxxxx":"xx xxxxxxx.","xxxxxxxxxxx":0,"xxx":000,"xxx":000,"xxxxxxxxxx":"xx","xxxxxxxxxxxxxx":xxxxx}],"xxxxxxxxx":xxxx},"xxxxxxxxxxxx":{"xxxxxxxxxxxxxxxxx":{"xxxxx":"xxxxxxx.xxx.xxxxxxxxxxx","xxxxxxxxxxxxx":"xxxxxxxxx","xxxxxxxxx":"\"xxxx00\"","xxxxx":"xxxxxxxxx","xxxxxxxxx":xxxx,"xxxxxxxxx":xxxx,"xxxxxxxxxxxxxxxxxxxxx":xxxx,"xxxxxxxx":xxxxx,"xxxxxxx":xxxxx},"xxxxxxxx":[{"xxxxxxxxxxx":{"xxxxx":"xxxxxxx.xxx.xxxxxxxxxxx","xxxxxxxxxxxxx":"xxxxxxxxx","xxxxxxxxx":"\"xxxx00\"","xxxxx":"xxxxxxxxx","xxxxxxx":0,"xxxx":0,"xxxxxxxxx":xxxx,"xxxxxxxxx":xxxx,"xxxxxxxxxxxxxxxxxxxxx":xxxx,"xxxxxxxx":xxxxx,"xxxxxxx":xxxxx},"xxxxxxxxxxxxxx":{"xxxxx":"xxxxxxx.xxx.xxxxxxxxxxxxxx","xxxxxxxxxx":[{"xxxxx":"xxxx.xxx.xxxx0xxxxxxx"}],"xxxxxxxxxxxxx":"xxxx0","xxxxxxxxxxxxx":[{"xxxxx":"xxxxxxx.xxx.xxxxxxxxxxx","xxxxxxx":{"xxxxx":"xxxx.xxx.xxxx0xxxxxxx"}},{"xxxxx":"xxxxxxx.xxx.xxxxxxxxxxx","xxxxxxx":{"xxxxx":"xxxx.xxx.xxxx0xxxxxxx"}}]},"xxxxxxxxxxxxxxxxxxx":{"xxxxx":"xxxxxxx.xxx.xxxxxxxxxxxxxxxxxxx","xxxxxxxxxxxx":[00,00,00,00,00],"xxxxxxxxxxxxxx":[0]}}]},"xxxx":{"xxxxx":"xxxxxxx.xxx.xxxx.xxxxxxxxxxx","xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx":xxxx,"xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx":xxxxx,"xxxxxxxxxxxxx":xxxx,"xxxxxxxxxxx":xxxx,"xxxxxxxxx":0,"xxxxxxxx":{"xxxxx":"xxxxxxx.xxx.xxxxxxxx"},"xxxxxxxx":{"xxxxx":"xxxxxxx.xxx.xxxx.xxxxxxxx","xxxxx":"00:00:0x:x0:x0:00","xxxxxxxxx":0000,"xxxxxxxxx":000,"xxxxxxxxx":0,"xxxx":-00,"xxxxxxxxxxxxxxx":"xxxxxxxxx","xxxxxxxxxx":xxxxx,"xxxx":"\"xxxx00\""}},"xxxxxxxxxxxxxxxxx":[{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxxx_xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxxx_xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxxx_xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxxx_xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxxx_xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxxx_xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxxx_xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxxx_xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"x_xxxxx_xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"x_xxxxx_xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"x_xxxxx_xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"x_xxxxx_xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"x_xxxxx_xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"x_xxxxx_xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"x_xxxxx_xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"x_xxxxx_xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"x_xxxxx_xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[{"xxxxx":"xxxx.xxx.xxxx0xxxxxxx"}],"xxxx":"xxxxx0","xxxxxxxxxxxxx":[],"xx":xxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[{"xxxxx":"xxxx.xxx.xxxx0xxxxxxx"},{"xxxxx":"xxxx.xxx.xxxx0xxxxxxx"}],"xxxx":"xxxx0","xxxxxxxxxxxxx":[],"xx":xxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[{"xxxxx":"xxxx.xxx.xxxx0xxxxxxx"},{"xxxxx":"xxxx.xxx.xxxx0xxxxxxx"}],"xxxx":"xx","xxxxxxxxxxxxx":[],"xx":xxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"x0x0","xxxxxxxxxxxxx":[],"xx":xxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxxx_xxx0","xxxxxxxxxxxxx":[],"xx":xxxx}]},"_xxxxxxxxx":0000000000000},"xxxx":{"xxxxxxx_xxxxxxx_xxxxxx_xx":000000000}}
{"xxxx":"0000x0x0-0000-000x-xx0x-00xx00000000","xxxxxxxxxxxxxx":0,"xxx":{"xxxxxxx":"0.0.00.00000"},"xxxx":[],"device":{"xxxxxxxxxx":00,"xxxxxxxxxxx":"xxxxxxx\/xxxxxx\/xxxxxxx:0.0.0\/xxx00x\/x000xxxx0xxx0:xxxx\/xxxxxxx-xxxx","xxxxx":"xxxxxxx","xxxxxx":"xxxxxxx","xxxxxxxx":"xxxx","xxxxxxx":"xxx00x","xxxxxxxxxxxx":"xxxxxxx","xxxxx":"xxxxxxx-xx-x000x","xxxxxxx":"xxxxxx","xxxxxxxx":xxxxx,"xxxxx":"x000xxxx0xxx0"},"xxxxxx":{"xxxxxxxxxx":"xxxxxxxxx","xxxxxxxxxx":"000.00.000.000"},"xxxxx":{"xxxxx":{"xxxxxxxxxxxxx":xxxxx,"xxxxxxxxxxxx":{"xxxxx":"xxxxxxx.xx.xxxxxxxxxxxx","xxxxxxxxxxxxxx":xxxxx,"xxxxxxxxxxx":xxxxx,"xxxxxxxxxxxxx":xxxxx},"xxxxxxx":{"xxxxxx":0,"xxxxxxx":0,"xxxxx":000,"xxxxxxxx":000,"xxxxxxx":xxxx,"xxxxxxxxxx":"xx-xxx","xxxxxxxxxxx":000,"xxxxxxx":0000}},"xxxxxxxx":{"xxxxxxxxxxxxxxxxxx":[{"xxxxx":"xxxxxxx.xxxxxxxx.xxxxxxxx","xxxxxxxx":"xxx","xxx":0000000,"xxxxxxxx":00.00000000,"xxxxxxxxx":-00.00000000,"xxxxxxxx":00,"xxxxx":0,"xxxxxxxx":00},{"xxxxx":"xxxxxxx.xxxxxxxx.xxxxxxxx","xxxxxxxx":"xxxxxxx","xxx":00000,"xxxxxxxx":00.000000,"xxxxxxxxx":-00.000000,"xxxxxxxx":00}],"xxxxxxxx":00.00000000,"xxxxxxxxx":-00.00000000,"xxxxxxxx":00,"xxxxxxxx":0,"xxxxxxxx":00,"xxxxxxxxxx":"xxxxxxx\/xxxxxxx","xxxxxxxxxxxxxx":-00000,"xxxxxxx":{"xxxxxxxxx":"xxxxxxxxxxx","xxxxxxxxxxx":"xx","xxxxxxxxxxx":"xxxxxx xxxxxx","xxxxxxxxxxx":"0000-0000","xxxxxxxx":00.0000000,"xxxxxx":"xx_xx","xxxxxxxx":"xxxxxx","xxxxxxxxx":-00.0000000,"xxxxxxxxxx":00000,"xxxxxxxxxxxx":"xxxx xxxxxx","xxxxxxxxxxxxxxx":"0000-0000","xxxxxxxxxxxx":"xxxxx xxxxx xxxxxx"}},"xxxxxxx":{"xxxxx":{"xx":000,"xxxxxxxx":0},"xxxxxxxxxxx":{"xxxxxxx":-0.0000000,"xxxxx":0.000000000,"xxxx":0.000000},"xxxxxxxx":{"xxx":0000.0000,"xxxxxxxx":0}},"xxxxxxxxx":"0000-00-00x00:00:00.000-0000","xxxxxxx":{"xxxxxxxx":-0,"xxxxxxxxxxx":00000000,"xxxxxxxxxx":xxxx,"xxxxxxxxx":00000000,"xxxxxx":00000,"xxxxxxxxxxxxxxxxxxx":"xx&x","xxxxxxxxxxxxxxx":000000,"xxxxxxxxxxxxxxxxxxxxxx":"xx","xxxxxxxxxxxxxx":xxxxx},"xxxxxxxx":{"xxxxxxxxx":{"xxxxxxxxx":[{"xxxxx":"xxxxxxx.xxxxxxxxx.xxxxxxxxxxx","xxxxxxxxxxxx":xxxx,"xxxxxxxxxxxx":{"xxxxx":"xxxxxxx.xxxxxxxxx.xxxxxxxxxxxxxxx","xx":00000000,"xxx":000,"xxx":000,"xxx":00,"xxx":00000},"xxxxxxxxxxxxxx":{"xxxxx":"xxxxxxx.xxxxxxxxx.xxxxxxxxxxxxxxxxxxxxx","xxxxxxxx":00,"xxx":0000,"xxxxx":0,"xxxxxxxx":"xxxxxxxxxxxxxxxxxxxxx: xx=00 xxxx=0000 xxxx=000 xxxxx=0000000000 xxx=0000000000 xx=0000000000","xxxx":0000,"xxxx":000,"xxxxx":0000000000,"xxx":0000000000}},{"xxxxx":"xxxxxxx.xxxxxxxxx.xxxxxxxxxxx","xxxxxxxxxxxx":xxxxx,"xxxxxxxxxxxx":{"xxxxx":"xxxxxxx.xxxxxxxxx.xxxxxxxxxxxxxxx","xx":0000000000,"xxx":0000000000,"xxx":0000000000,"xxx":000,"xxx":0000000000},"xxxxxxxxxxxxxx":{"xxxxx":"xxxxxxx.xxxxxxxxx.xxxxxxxxxxxxxxxxxxxxx","xxxxxxxx":00,"xxx":000,"xxxxx":0,"xxxxxxxx":"xxxxxxxxxxxxxxxxxxxxx: xx=00 xxxx=000 xxxx=00 xxxxx=0000000000 xxx=0000000000 xx=0000000000","xxxx":000,"xxxx":00,"xxxxx":0000000000,"xxx":0000000000}}],"xxxxxxxxxxxx":{"xxxxx":"xxxxxxx.xxxxxxxxx.xxx.xxxxxxxxxxxxxxx","xxx":00000000,"xxx":00000,"xxx":0},"xxxxxxxxxxxxxxxxxxxx":[{"xxxxx":"xxxxxxx.xxxxxxxxx.xxxxxxxxxxxxxxxxxxx","xxx":-0,"xxx":-0,"xxxxxxxxxxx":0,"xxx":-0,"xxxx":00},{"xxxxx":"xxxxxxx.xxxxxxxxx.xxxxxxxxxxxxxxxxxxx","xxx":-0,"xxx":-0,"xxxxxxxxxxx":0,"xxx":-0,"xxxx":00}],"xxxxxxxxxxxxxxxxx":[{"xxxxx":"xxxxxxx.xxxxxxxxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxxx":0,"xxxxxxxxxxxx":0,"xxxxxxxxxxx":"xxxx 0","xxxxxxxxxxx":"xx&x","xxxxxxxxxxx":0,"xxx":000,"xxx":000,"xxxxxxxxxx":"xx","xxxxxxxxxxxxxx":xxxxx}]},"xxxxxxxxxxxx":{"xxxxxxxxxxxxxxxxx":{"xxxxx":"xxxxxxx.xxx.xxxxxxxxxxx","xxxxxxxxxxxxx":"xxxxxxxxx","xxxxxxxxx":"\"xxxx\"","xxxxx":"xxxxxxxxx","xxxxxxxxx":xxxx,"xxxxxxxxx":xxxx,"xxxxxxxxxxxxxxxxxxxxx":xxxx,"xxxxxxxx":xxxxx,"xxxxxxx":xxxxx},"xxxxxxxx":[{"xxxxxxxxxxx":{"xxxxx":"xxxxxxx.xxx.xxxxxxxxxxx","xxxxxxxxxxxxx":"xxxxxxxxxxxx","xxxxx":"xxxxxxxxxxxx","xxxxxxx":0,"xxxx":00,"xxxxxxxxx":xxxx,"xxxxxxxxx":xxxxx,"xxxxxxxxxxxxxxxxxxxxx":xxxxx,"xxxxxxxx":xxxxx,"xxxxxxx":xxxxx},"xxxxxxxxxxxxxx":{"xxxxx":"xxxxxxx.xxx.xxxxxxxxxxxxxx","xxxxxxxxxx":xxxx,"xxxxxxxxxxxxx":xxxx},"xxxxxxxxxxxxxxxxxxx":{"xxxxx":"xxxxxxx.xxx.xxxxxxxxxxxxxxxxxxx","xxxxxxxxxxxx":[0,00,00,00],"xxxxxxxxxxxxxx":[0]}},{"xxxxxxxxxxx":{"xxxxx":"xxxxxxx.xxx.xxxxxxxxxxx","xxxxxxxxxxxxx":"xxxxxxxxx","xxxxxxxxx":"xxx","xxxxx":"xxxxxxxxx","xxxxxxx":00,"xxxx":00,"xxxxxxxxx":xxxx,"xxxxxxxxx":xxxx,"xxxxxxxxxxxxxxxxxxxxx":xxxx,"xxxxxxxx":xxxxx,"xxxxxxx":xxxxx},"xxxxxxxxxxxxxx":{"xxxxx":"xxxxxxx.xxx.xxxxxxxxxxxxxx","xxxxxxxxxxxxx":"xxxxx0","xxxxxxxxxxxxx":[{"xxxxx":"xxxxxxx.xxx.xxxxxxxxxxx","xxxxxxx":{"xxxxx":"xxxx.xxx.xxxx0xxxxxxx"}}],"xxxxxxxxxx":xxxx},"xxxxxxxxxxxxxxxxxxx":{"xxxxx":"xxxxxxx.xxx.xxxxxxxxxxxxxxxxxxx","xxxxxxxxxxxx":[0,00,00,00],"xxxxxxxxxxxxxx":[0]}},{"xxxxxxxxxxx":{"xxxxx":"xxxxxxx.xxx.xxxxxxxxxxx","xxxxxxxxxxxxx":"xxxxxxxxx","xxxxxxxxx":"\"xxxx\"","xxxxx":"xxxxxxxxx","xxxxxxx":0,"xxxx":0,"xxxxxxxxx":xxxx,"xxxxxxxxx":xxxx,"xxxxxxxxxxxxxxxxxxxxx":xxxx,"xxxxxxxx":xxxxx,"xxxxxxx":xxxxx},"xxxxxxxxxxxxxx":{"xxxxx":"xxxxxxx.xxx.xxxxxxxxxxxxxx","xxxxxxxxxx":[{"xxxxx":"xxxx.xxx.xxxx0xxxxxxx"}],"xxxxxxx":"","xxxxxxxxxxxxx":"xxxx0","xxxxxxxxxxxxx":[{"xxxxx":"xxxxxxx.xxx.xxxxxxxxxxx","xxxxxxx":{"xxxxx":"xxxx.xxx.xxxx0xxxxxxx"}}]},"xxxxxxxxxxxxxxxxxxx":{"xxxxx":"xxxxxxx.xxx.xxxxxxxxxxxxxxxxxxx","xxxxxxxxxxxx":[00,00,00,00,00],"xxxxxxxxxxxxxx":[0]}}]},"xxxx":{"xxxxx":"xxxxxxx.xxx.xxxx.xxxxxxxxxxx","xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx":xxxxx,"xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx":xxxxx,"xxxxxxxxxxxxx":xxxxx,"xxxxxxxxxxx":xxxx,"xxxxxxxxx":0,"xxxxxxxx":{"xxxxx":"xxxxxxx.xxx.xxxxxxxx"},"xxxxxxxx":{"xxxxx":"xxxxxxx.xxx.xxxx.xxxxxxxx","xxxxx":"00:x0:00:00:00:00","xxxxxxxxx":0000,"xxxxxxxxx":000,"xxxxxxxxx":0,"xxxx":-00,"xxxxxxxxxxxxxxx":"xxxxxxxxx","xxxxxxxxxx":xxxxx,"xxxx":"\"xxxx\""}},"xxxxxxxxxxxxxxxxx":[{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[{"xxxxx":"xxxx.xxx.xxxx0xxxxxxx"},{"xxxxx":"xxxx.xxx.xxxx0xxxxxxx"}],"xxxx":"xxxxx0","xxxxxxxxxxxxx":[],"xx":xxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxx_xxxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxx_xxxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxx_xxxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxx_xxxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxx_xxxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxx_xxxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxx_xxxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxx_xxxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxx_xxxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[{"xxxxx":"xxxx.xxx.xxxx0xxxxxxx"}],"xxxx":"xxxxx0","xxxxxxxxxxxxx":[],"xx":xxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[{"xxxxx":"xxxx.xxx.xxxx0xxxxxxx"}],"xxxx":"xxxx0","xxxxxxxxxxxxx":[],"xx":xxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[{"xxxxx":"xxxx.xxx.xxxx0xxxxxxx"}],"xxxx":"x0x0","xxxxxxxxxxxxx":[],"xx":xxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxx0","xxxxxxxxxxxxx":[],"xx":xxxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[{"xxxxx":"xxxx.xxx.xxxx0xxxxxxx"},{"xxxxx":"xxxx.xxx.xxxx0xxxxxxx"}],"xxxx":"xx","xxxxxxxxxxxxx":[],"xx":xxxx},{"xxxxx":"xxxx.xxx.xxxxxxxxxxxxxxxx","xxxxxxxxxxxxx":[],"xxxx":"xxxxx_xxx0","xxxxxxxxxxxxx":[],"xx":xxxxx}]},"_xxxxxxxxx":0000000000000},"xxxx":{"xxxxxxx_xxxxxxx_xxxxxx_xx":000000000}}


Accepted Solutions
Nine Stars

Re: JSON - Need help getting more than 1 row of data out

Please find the screen shot below for jsonextract component.

 

jSonDevice1.PNG

Regards,

 

Veeru Boppudi

All Replies
Community Manager

Re: JSON - Need help getting more than 1 row of data out

Hi
The sample file is unreadable, it looks like two json strings in the file, are you able to create a metadata for this file?

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Nine Stars

Re: JSON - Need help getting more than 1 row of data out

Yes, I was only able to paste in 2 JSON strings because of the 20K character limit on the the Talend forum.

 

 

I think this is a good reduced version which can be used for troubleshooting:

 

{"guid":"stuff1","schemaRevision":1,"app":{"version":"123"},"user":[],"device":{"androidApi":1,"fingerprint":"abc","brand":"MOTO","device":"phone1"}}
{"guid":"stuff2","schemaRevision":2,"app":{"version":"456"},"user":[],"device":{"androidApi":2,"fingerprint":"def","brand":"HTC","device":"phone2"}}
{"guid":"stuff3","schemaRevision":3,"app":{"version":"789"},"user":[],"device":{"androidApi":3,"fingerprint":"ghi","brand":"LG","device":"phone3"}}
{"guid":"stuff4","schemaRevision":4,"app":{"version":"1011"},"user":[],"device":{"androidApi":4,"fingerprint":"jkl","brand":"SAM","device":"phone4"}}

Nine Stars

Re: JSON - Need help getting more than 1 row of data out

Can you please provide expected output?

Regards,

Veeru Boppudi
Nine Stars

Re: JSON - Need help getting more than 1 row of data out

1,abc,MOTO,phone1
2,def,HTC,phone2
3,ghi,LG,phone3
4,jkl,SAM,phone4

Nine Stars

Re: JSON - Need help getting more than 1 row of data out

Hi,

Please find the job below to read json file and derive device details.

jSonDevice.PNG

 

Regards, 

Veeru Boppudi
Nine Stars

Re: JSON - Need help getting more than 1 row of data out

Please post a screenshot of the tExtractJSONFields component's component tab.
Nine Stars

Re: JSON - Need help getting more than 1 row of data out

Please find the screen shot below for jsonextract component.

 

jSonDevice1.PNG

Regards,

 

Veeru Boppudi
Nine Stars

Re: JSON - Need help getting more than 1 row of data out

Thanks! I hadn't messed with JSON much before yesterday.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.