topic Re: tFileOutputJSON output formating in Talend Studio

tFileOutputJSON output formating

Anonymous — Thu, 17 Dec 2015 14:50:17 GMT

Hi everyone
I use 5.6 version and In a transformation I need to generate a large JSON file so I use tFileOutputJSON component. the problem is that the generated output is a single line JSON file which has more data than java can handle in a single line. any idea on how can I avoid this behavior and create a well formed JSON file?
Best,

Re: tFileOutputJSON output formating

Anonymous — Fri, 18 Dec 2015 06:34:15 GMT

Hi,
Could you please explain your request with some example data? What's your expected json output?
Here is a component TalendHelpCenter:tWriteJSONField which is used to transform the incoming data into JSON fields.

Best regards
Sabrina

Re: tFileOutputJSON output formating

Anonymous — Tue, 29 Dec 2015 10:29:41 GMT

Hi Sabrina
Thanks for the hint. Breaking the file down to records and writing them individually using tWriteJSONField solved the problem of formating the json file.
Best,
Yashar

Re: tFileOutputJSON output formating

Anonymous — Wed, 30 Dec 2015 02:26:59 GMT

Hi Yashar,
Thanks for your feedback. Could you please mark this topic as resolved if this problem is solved?
Best regards
Sabrina