topic Re: Help on JSON file extra , doesn't fetch all rows in Talend Studio

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

Karuetl — Sat, 16 Nov 2024 05:57:32 GMT

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

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

vboppudi — Tue, 30 Apr 2019 20:36:27 GMT

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,

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

Karuetl — Tue, 30 Apr 2019 20:55:44 GMT

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

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

vboppudi — Tue, 30 Apr 2019 21:36:11 GMT

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,

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

Anonymous — Tue, 30 Apr 2019 22:23:12 GMT

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

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

nfz11 — Sat, 04 May 2019 05:50:03 GMT

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