tWriteJSONField and element with empty string

[Anonymous]

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?

[Anonymous]

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

[Pooja_kataria]

Hi,

Did you got the solution for this question?

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

[Pooja_kataria]

Hi,

Did you got the solution for this question?

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

[root]

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("\\[\\]", "");

[root]

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("\\[\\]", "");