topic Re: How can i build a JSON output with (multiple) loops? in Talend Studio

How can i build a JSON output with (multiple) loops?

bluexblue — Mon, 19 Aug 2019 17:06:27 GMT

I'm trying to build a JSON output with more than 1 loop. i was able to build an XML using the 'append' feature of tFileOutputMSXML but couldn't find something similar for JSON.

As the snapshot shows, i can only loop on address but not on communications at the same time.

Re: How can i build a JSON output with (multiple) loops?

root — Mon, 19 Aug 2019 20:03:31 GMT

The tWriteJsonField component seems a little lacking on features while working with complex json objects. I have tried using a custom Talend Component "tJSONDoc" ( https://github.com/jlolling/talendcomp_tJSONDoc)

The documentation can be a little confusing in the beginning. If you want to post more info on the intended output structure and what you were able to come up with, please share here.
HTH

PS: I am still learning this component, and so far, I have had multiple success overall using this component in creating complex objects.

Re: How can i build a JSON output with (multiple) loops?

bluexblue — Tue, 20 Aug 2019 16:50:22 GMT

Thank you for the custom component. I've seen it before but i thought maybe Talend can do it without having to go into installing something external.

Will try to post the end flow when im done..