tWriteJsonField auto remove '[' if the group has only one item

Anonymous — Sat, 16 Nov 2024 03:11:06 GMT

Hi,

I use tWriteJsonField to generate json from my database, its content is like this

When I run the job, if the group contains more than 1 element, the '[' and the ']' appear to group the items, but if there is only one item in the group, they display as normal item without '[' and ']'.

Because the next usage require this is a collection, so that the [ and ] is important to me. How can I keep them even if there is only one item in the group?

Thanks

Re: tWriteJsonField auto remove '[' if the group has only one item

Anonymous — Tue, 25 Feb 2020 08:44:27 GMT

Hi all,

To work arround, I use a tMap to replace the string as follow:

row2.request.replace("\"items\":{", "\"items\":[{").replace("}}}", "}}]}")

It work fine for me, but I believe this may be a bug (correct me if it is not)

topic Re: tWriteJsonField auto remove '[' if the group has only one item in Talend Studio

tWriteJsonField auto remove '[' if the group has only one item

Re: tWriteJsonField auto remove '[' if the group has only one item