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

View solution in original post


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

View solution in original post

Nine Stars

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

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog