topic Creating array and objectis using tWriteJSONfile in Talend Studio

Creating array and objectis using tWriteJSONfile

cara_ay — Fri, 15 Nov 2024 23:45:06 GMT

Hi,

I'm having trouble to creating the below structure using tWriteJSONField but can't seem to get the component working. Would anyone know how to structure this using the tWriteJSONField component?

Here is the desired output.

But this is what I'm getting from the Talend output.

{"content":[{"type":"cms_image","body":{"altText":"Screenshot","title":"

Screenshot

","source":{"ref":"assets/uploaded-files/2021-08/

Screenshot

.jpg"}}}]}

{"content":[{"type":"cms_image","body":{"altText":"

Screenshot2

","title":"

Screenshot2

","source":{"ref":"assets/uploaded-files/2021-08/

Screenshot2

.jpg"}}}]}

Here is my XML tree structure.

Anyone who has any ideas on how I might be able to fix this? Thanks!

Re: Creating array and objectis using tWriteJSONfile

Anonymous — Sat, 11 Sep 2021 01:18:10 GMT

@Cara Au Yeung , add a group element to merge input rows to one output row. see

Output:

{"content":[{"type":"type1","body":{"alttext":"screesnot1","title":"title1","source":"ref1"}},{"type":"type2","body":{"alttext":"screesnot2","title":"title2","source":"ref2"}}]}

Please try again.

Regards

Shong

Re: Creating array and objectis using tWriteJSONfile

cara_ay — Sat, 11 Sep 2021 10:11:57 GMT

Hi @Shicong Hong , thank you so much - that worked perfectly 🙂