topic Re: tWriteJSONField: why "Set As Loop Element"? in Talend Studio

tWriteJSONField: why "Set As Loop Element"?

Lorenzo5 — Fri, 04 Aug 2017 16:11:31 GMT

Looking at this scenario:

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/oNb3uOB_7iXYY0w_dH3W2A

I read, at a certain point:

9. Right-click firstname and select Set As Loop Element from the context menu.

Well, the result is a "plain" json, without any loop element:

{"field1":"111","field2":"222","field3":"333"}

{"field1":"444","field2":"555","field3":"666"}

Why on earth field1 should be a "Loop Element"?

Thanks for your clarification,

Lorenzo

Re: tWriteJSONField: why "Set As Loop Element"?

Anonymous — Tue, 08 Aug 2017 10:19:25 GMT

Hello
To write a XML or Json field, you have to set a loop element. If you want to generate only one string, you need to define the group element also, the output string looks like:
{"rootTag":{"users":[{"id":"1","name":"shong"},{"id":"2","name":"elise"},{"id":"3","name":"ross"}]}}

Regards
Shong

Re: tWriteJSONField: why "Set As Loop Element"?

Lorenzo5 — Tue, 05 Sep 2017 13:32:34 GMT

Hi @shong

have you followed link I provided?

As you can see in the page linked, "firstname" is set as loop-element, and when you scroll down the page and take a look to the json result, firstname is definitely not a loop element (it is a string element, instead).

So, it is still not clear the purpose of defining firstname as loop-element when it is not.

Re: tWriteJSONField: why "Set As Loop Element"?

root — Tue, 05 Sep 2017 14:08:37 GMT

Hi, is there any documentation on how to set an element as "group"? I am seeing that option grayed out all the time.

Re: tWriteJSONField: why "Set As Loop Element"?

fab_74 — Wed, 06 Sep 2017 07:19:49 GMT

hi,

the loop element must be the finest level
If your json has a flat structure you do not have the group function.
to activate this last one it is necessary to create a node in which you can make a loop.
You can thus have the function group element

json1.PNG
twritejson.PNG

Re: tWriteJSONField: why "Set As Loop Element"?

Anonymous — Wed, 10 Oct 2018 18:59:27 GMT