cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TonySuslovich
Helper II
Helper II

Parse JSON action: missing properties

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.

1 ACCEPTED SOLUTION

Accepted Solutions
fchopo
Super User
Super User

Hi @TonySuslovich 

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

required_parse_json.png

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

 

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

View solution in original post

2 REPLIES 2
fchopo
Super User
Super User

Hi @TonySuslovich 

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

required_parse_json.png

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

 

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!
TonySuslovich
Helper II
Helper II

Hi @fchopo Excellent!

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (2,375)