AnsweredAssumed Answered

Mapping a JSON Profile field with an empty string value

Question asked by kat.austria697779 on Jul 8, 2016
Latest reply on Jul 11, 2016 by Adam Arrowsmith

We have a process wherein we have a map between two JSON profiles. The input document is JSON array, and the output is a single JSON object. The profiles are essentially the same except that input is an array of the json output object.

 

What I'm seeing is that if the input value has a field and this field has an empty string value, the Map function seems to treat this field as NULL and drops the field altogether in the Output profile. So you see the resulting document, the field is omitted.

 

Is there a way to make it retain the empty string by default so we don't have to add an additional function?

Empty string is technically different from NULL, so I was not expecting that to be converted..

Thanks!

Outcomes