Help on JSON file extra , doesn't fetch all rows

Eight Stars

Help on JSON file extra , doesn't fetch all rows

I have json file as below, Need help to read below data and load into CSV file,it doesn't fetch all the columns but only the first row 

 

tfileinputJson component i used

 

screenshot.png'

 

Nine Stars

Re: Help on JSON file extra

Hi,

 

Do you have any specific logic for extra columns in target table? If yes you can implement that logic in tmap and connec new attributes to target.

 

Regards,

Veeru Boppudi
Eight Stars

Re: Help on JSON file extra

issue is when read json file its not fetching all rows , except first one 

 

Nine Stars

Re: Help on JSON file extra

That means you are using incorrect json structure or while importing json defined it as wrongly.

If possible can you please share complete json structure you are using as source?

 

Regards,

 

Veeru Boppudi
Four Stars

Re: Help on JSON file extra , doesn't fetch all rows

Hi,

Json mentioned in image is not in right format. It should be something like [{“id”:34,”name”:”abc”,”location”:00743},{“id”:3,”name”:”EFG”,”location”:08865}] to iterate, extract both and load into CSV.

Please let me know if you need any other information.

Thanks
Vinesh
Nine Stars

Re: Help on JSON file extra , doesn't fetch all rows

Please show us the details of your Loop Json query and Json mappings from your tfileinputjson in a screenshot or text.

--
Please give Kudos and mark topics as solved where appropriate.

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