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.