Forum Discussion

mohit3's avatar
mohit3
New Contributor
4 years ago

Generating wrong Json format for empty values

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 : Getting be...
ptaylor's avatar
ptaylor
Employee
4 years ago

Mohit, this is just an odd bug in the Designer’s viewer for JSON preview data. If you actually save the output of the JSON Formatter to a file using a File Writer, you’ll see that the empty string is a pair of double quotes as you expect.

djsiegel's avatar
djsiegel
Former Employee
4 years ago

Can confirm, Patrick - I happened to just be building an example to test myself.
When I download it, I do see the doublequotes.
Mohit - here’s my example, with both the input and output. Hope that helps.

CommunityExampleJSON.zip (4.3 KB)

  • ptaylor's avatar
    ptaylor
    Employee
    4 years ago

    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:

    Your Mapper doesn’t change these values since they are already strings.