topic Re: Empty string value is output as empty array in Talend Studio

Empty string value is output as empty array

Anonymous — Sat, 16 Nov 2024 08:22:10 GMT

Hi,

I am using tWriteJSONField to output JSON. Problem I am facing is whenever a string comes with null value, it is stored as [] ie "emtpy array" , although it should be "" i.e. "empty string", ARE there any fixes Talend has provided for this issue? I can do a simple find and replace, but wondering if there is any configuration or available fix for this. I am using Talend Studio 6.3.

Re: Empty string value is output as empty array

Anonymous — Fri, 27 Apr 2018 11:18:37 GMT

Hello,

Here is a related jira issue:https://jira.talendforge.org/browse/TDI-31237.

Could you please check it to see if it is what you are looking for?

Best regards

Sabrina

Re: Empty string value is output as empty array

heshkaru — Tue, 29 Mar 2022 02:30:48 GMT

Hi @Xiaodi Shi ,

Came across this issue.

When I log it "site_id" shows empty.

When I use twritejsonfield and out to a json file it changes to empty [].

Any solution for this?

Thank you

Re: Empty string value is output as empty array

gjeremy1617088143 — Tue, 29 Mar 2022 08:26:29 GMT

HI @Heshan Karunaratneyou could try to play with advanced option of the component like pass empty string or null value explicitly else you could try to add a tJavaRow after the tWriteJsonfield then in the tjavaRow :

output_row.string = input_row.string.replaceAll("\\[\\]","\"\"");

it will replace [] by ""

here i assume your json schema field name is string

Send me love and kudos

Re: Empty string value is output as empty array

heshkaru — Tue, 29 Mar 2022 09:09:46 GMT

Hi, For 50% this option is ok.

output_row.string = input_row.string.replaceAll("\\[\\]","\"\"");

But in my json object there are specific arrays and objects as well. For an empty array [] is fine.

Im specifically replacing them first and doing the rest to the others.

Re: Empty string value is output as empty array

gjeremy1617088143 — Tue, 29 Mar 2022 09:21:49 GMT

you could focus on specific field like input_row.string.replaceAll("\"site_id\":\\[\\]","\"site_id\":\"\"");