cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JAngle
Level: Power Up

JSON schema validation errors when parsing JSON

My flow takes a JSON from powerapps. I've used the output from that to generate my schema in the Parse JSON aspect of my flow. Sadly I get an error about not being provided with the items laid out in the schema. 

 

The JSON is made up of two strings. One represents a Base64 string and the other is a general text string. I can download the input my the test results and it clearly contains the elements I want to parse. 

 

I've tweaked the schema after reading some blogs but to no avail: http://johnliu.net/blog/2018/6/a-thesis-on-the-parse-json-action-in-microsoft-flow

 

My error:

[
{
"message": "Required properties are missing from object: ItemID.",
"lineNumber": 0,
"linePosition": 0,
"path": "[0]",
"value": [
"CmrImg"
],
"schemaId": "#/items",
"errorType": "required",
"childErrors": []
},
{
"message": "Required properties are missing from object: CmrImg.",
"lineNumber": 0,
"linePosition": 0,
"path": "[1]",
"value": [
"CmrImg"
],
"schemaId": "#/items",
"errorType": "required",
"childErrors": []
},
{
"message": "Required properties are missing from object: ItemID.",
"lineNumber": 0,
"linePosition": 0,
"path": "[2]",
"value": [
"CmrImg"
],
"schemaId": "#/items",
"errorType": "required",
"childErrors": []
},
{
"message": "Required properties are missing from object: CmrImg.",
"lineNumber": 0,
"linePosition": 0,
"path": "[3]",
"value": [
"CmrImg"
],
"schemaId": "#/items",
"errorType": "required",
"childErrors": []
},
{
"message": "Required properties are missing from object: ItemID.",
"lineNumber": 0,
"linePosition": 0,
"path": "[4]",
"value": [
"CmrImg"
],
"schemaId": "#/items",
"errorType": "required",
"childErrors": []
},
{
"message": "Required properties are missing from object: CmrImg.",
"lineNumber": 0,
"linePosition": 0,
"path": "[5]",
"value": [
"CmrImg"
],
"schemaId": "#/items",
"errorType": "required",
"childErrors": []
}
]
1 REPLY 1
Dual Super User
Dual Super User

Re: JSON schema validation errors when parsing JSON

One of the issues I ran into recently with Parse JSON was dealing with values or properties that were Null.  When I used the sample output to get the schema it automatically set the type to "string", but it needed to be {"type": ["string", "null"]} instead.  It was still a string value, but if it was missing the JSON still parsed correctly.  I'm wondering if your required properties are the same kind of problem.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (3,860)