Output json file not correct

I have made a scenario with these steps:

In the json file from the CMS sometimes there are values written as “”.

In the output json file from my scenario, I don’t get “” as value.

In the data structure in the module Aggregate to Json they are mapped as text.
See for example

In the mapping field I tried to leave it empty, but then I get null in the output file. And if I fill in “” I got something like “content”: “""”.

How is it possible to have a value like “” in the output json file?

The empty values are not written in the Google Sheets from the trigger.

Hopefully someone can help me with this :slight_smile:

1 Like

Someone who can help me? Or do I need to provide more information?

1 Like

Hi @Eline_de_Hamer

You can use emptystring.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation

1 Like