topic tWriteJSONField and element with empty string in Talend Studio

tWriteJSONField and element with empty string

Anonymous — Fri, 23 Dec 2016 13:55:42 GMT

I would like to create json object using tWriteJSONField:

{
"title":""
}

but instead I got

{
"title":[]
}

Tried to use empty string from tMap component as input, spent some time trying to enter a hardcoded empty string but no success :-|.

Is it a good practice to use this component for json output? Maybe there is a better way to create a json file with mapping using other components?

Re: tWriteJSONField and element with empty string

Anonymous — Mon, 26 Dec 2016 06:49:59 GMT

Hi,
Could you please elaborate your case with an example with input and expected output values? In this way, we can design a demo job for you.
Best regards
Sabrina

Re: tWriteJSONField and element with empty string

Pooja_kataria — Tue, 30 Jun 2020 12:36:58 GMT

Hi,

Did you got the solution for this question?

I amfacing same issue .Can you please help me with it?

Re: tWriteJSONField and element with empty string

Pooja_kataria — Tue, 30 Jun 2020 12:36:58 GMT

Hi,

Did you got the solution for this question?

I amfacing same issue .Can you please help me with it?

Re: tWriteJSONField and element with empty string

root — Tue, 30 Jun 2020 14:32:19 GMT

https://help.talend.com/reader/LNO9Tqm8svZQklRyXL8OYw/HDXOdWVienee_BuL7LstpQ

Pls check the note:

Note: For any field with the null value, this component writes a pair of square brackets ([]). If needed, you can remove or replace them using a regular expression in a tJavaRow component next to the tWriteJSONField component. For exmaple:
output_row.rootNode = input_row.rootNode.replaceAll("\\[\\]", "");

Re: tWriteJSONField and element with empty string

root — Tue, 30 Jun 2020 14:32:19 GMT