cancel
Showing results for 
Search instead for 
Did you mean: 

Generating wrong Json format for empty values

mohit3
New Contributor

Hi All,

I am creating a Json file by using the Json formatter but I am not getting the json in correct format for all the empty values.

Below is the input for Json Formatter :

image

Getting below output from Json Formatter.
image

The output should look like below. Empty fields should be enclosed in double codes.
“Bankgroup” : “”,
“BankNumber” : “”,

Please let me know how we can achieve this.
@dmiller

Thanks
Mohit

5 REPLIES 5

David, I downloaded and validated your pipeline. Even with the Mapper, the preview dialog for the JSON Formatter’s output shows the same problem with displaying a single double quote instead of two double quotes:
image
Your Mapper doesn’t change these values since they are already strings.