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

[Karuetl]

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

'

[vboppudi]

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,

[Karuetl]

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

[vboppudi]

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,

[Anonymous]

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

[nfz11]

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