Parse JSON action: missing properties

[TonySuslovich]

Hi all,

I have a List Records action (source is CDS) which pulls some data from CDS. Some records may not have certain attributes (they're NULL) and List Records doesn't return attributes with value = NULL for some reason. I have Parse JSON action following List Records where I parse JSON output from List Records and its schema has all the possible attributes that I'm trying to fetch from List Records. So Parse JSON is failing when it comes across a record which doesn't match the schema due to missing attributes. Is there any way around this...like indicating in Parse JSON schema that some attributes may be optional or perhaps telling List Records option to return all attributes even if they have NULL values?

TIA,

-Tony Suslovich.

[fchopo · Accepted solution]

Hi @TonySuslovich 

In the "Parse JSON" action you will have a list with all the required properties:

Therefore, you should remove those attributes that are not required (they may not be present in the JSON file) from that list.

Hope it helps!

Ferran

[TonySuslovich]

Hi @fchopo Excellent!