Use tFileoutputJson to create complex json output

[Anonymous]

Hi,
I have used tFileoutputJson to create simple json file described in the tutorial.
Example
{"Subscribers":}
How to create complex json file like below using tFileoutputJson?
{"Subscribers":}]}

[Anonymous]

hi,
honestly for complex JSON, I use JSON API in routines to format it.
Talend json component are ok for simple format but rather inefficient when you need to manipulate some StringSet.
regards
laurent

[Anonymous]

Thanks so much for reply.
Gowri

[Anonymous]

Hi Laurent,
Can you please paste a sample example how to create workflow to create json files using json API? I want to take output from database query and create json formatted file as output which can be passed as a payload to POST call.
Thanks,
Gowri

[jordan_bobo]

thanks