Talend - How to output JSON records in multiple rows

Question

I have generated a JSON output using Talend. However, my problem is that all my records are outputed in 1 row in the JSON file. Below is the sample output:

[{"field1":"value1_1","field2":"value2_1","field3":"value3_1"},{"field1":"value1_2","field2":"value2_2","field3":"value3_2"},{"field1":"value1_3","field2":"value2_3","field3":"value3_3"}]

My desired output is to have all JSON record separated by newline in the output file:

[{"field1":"value1_1","field2":"value2_1","field3":"value3_1"},
{"field1":"value1_2","field2":"value2_2","field3":"value3_2"},
{"field1":"value1_3","field2":"value2_3","field3":"value3_3"}]

Thanks in advance for the help!

Answer 1

There is no direct way to do it, but if it's necessary you can re-read the file as raw file using a tFileInputRaw component then replace all },{ by },\n{ in a tJavaRow component.

Answer 2

Use the tFileOutputJSON component, which will help collect the rows as a list into JSON file. You may then use a tFileInput Component to read it and send it as Response.