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!

Being a curious person and all, I have to ask, why do want to achieve this, how will it help you? — erikvimz
– erikvimz, Commented Jun 1, 2016 at 9:13

54l3d · Accepted Answer · 2016-06-06 10:10:38Z

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.

edited Jun 6, 2016 at 10:10

answered Jun 1, 2016 at 16:45

54l3d

3,9734 gold badges35 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Daniel Lee Over a year ago

Hi, How do I re-read the file as raw file using tJavaRow component?

54l3d Over a year ago

@DanielLee Updated answer !

Sujith T · Accepted Answer · 2017-01-23 04:47:02Z

0

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.

answered Jan 23, 2017 at 4:47

Sujith T

5863 silver badges8 bronze badges

1 Comment

Sushil Sharma Over a year ago

It seems more like a comment. Provide some explanation to your answer.

Collectives™ on Stack Overflow

Talend - How to output JSON records in multiple rows

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related