Creating array and objectis using tWriteJSONfile

[cara_ay]

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!

[Anonymous · Accepted solution]

@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

[cara_ay]

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