[resolved] Unable to read JSON file rows, only 1st row

Anonymous — Fri, 14 Oct 2016 04:45:21 GMT

Hi,
I am new with Talend and currently trying Talend Studio for Cloud and considering to subscribing it very soon.
I am trying to create a new job to read our source Json file. I am using tFileInputJSON - main - tExtractJSONFields - main - tLogRow
the content of the file is:

{"name": "Magas", "countryCode": "643", "country": "Russia", "longitude": 45.01776123046875, "location": "Nazran", "airportIcaoCode": "%u04", "latitude": 43.323814392089844, "timezone": "Asia/Baku", "altitudeFeet": 1060, "_id": "%u0", "landmarkId": 100002446640}
{"name": "Truckee-Tahoe Airport", "countryCode": "840", "country": "United States", "longitude": -120.13956451416016, "location": "Truckee", "airportIcaoCode": "KTRK", "latitude": 39.32004165649414, "timezone": "America/Denver", "altitudeFeet": 5900, "_id": "...", "landmarkId": 100003026478}
{"name": "Moton Field Municipal Airport", "countryCode": "840", "country": "United States", "longitude": -85.6800308227539, "location": "Tuskegee", "airportIcaoCode": "N", "latitude": 32.4605712890625, "timezone": "America/Fort_Wayne", "altitudeFeet": 264, "_id": "06A", "landmarkId": 100003159617}

I could only read the first record instead of all 3? What should I do to make the ETL table to read the whole file?
I have a feeling it is due to no proper naming of the node? But other tools that we are using are able to read the file as it is.
Please advise,

Thanks,
Endy

Re: [resolved] Unable to read JSON file rows, only 1st row

vapukov — Fri, 14 Oct 2016 05:32:09 GMT

tFileInputJSON read all file as single JSON, You can use
tFileInputFullRow -> tExtractJOSNFileds ->

Re: [resolved] Unable to read JSON file rows, only 1st row

Anonymous — Fri, 14 Oct 2016 06:13:26 GMT

Thanks Vapukov, it's working perfectly.
Setting it to resolved.

topic Re: [resolved] Unable to read JSON file rows, only 1st row in Talend Studio

[resolved] Unable to read JSON file rows, only 1st row

Re: [resolved] Unable to read JSON file rows, only 1st row

Re: [resolved] Unable to read JSON file rows, only 1st row