topic How to send empty string through tWriteJSONField and not a NULL in Talend Studio

How to send empty string through tWriteJSONField and not a NULL

himanshup — Thu, 03 Oct 2024 16:05:33 GMT

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

Re: How to send empty string through tWriteJSONField and not a NULL

Dave_Simo — Fri, 04 Oct 2024 14:25:25 GMT

Hello,

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

Best Regards,

Re: How to send empty string through tWriteJSONField and not a NULL

himanshup — Mon, 07 Oct 2024 18:06:45 GMT

Thank you.

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