How to send empty string through tWriteJSONField and not a NULL

[himanshup]

Hi,

Hi I am new to Talend.

My data elements could have a NULL value. I need to be able to send an empty string ("") in place of that NULL.

Currently the JSON out of the tWriteJSONField is:

{
"LastName": "Young",
"FirstName": "Nolan",
"MiddleInitial": [],
"Title": "Tester",
"Administrator": "1",
"Username": "Noyoung"
}

I need to have "" instead of the array []

"MiddleInitial": "",

Thank you.

About our Talend Install:

Talend Studio 8

Build id: 20240524_0800-patch

[Dave_Simo]

Hello,

You can use this in a tJavarow to replace the [] with ""

Best Regards,

[himanshup · Accepted solution]

Thank you.

In the Advanced setting for tWriteJSONField, I checked the box - Pass null values and empty strings explicitly, and that resolved the issue.