web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / JSON schema validation...
Power Automate
Unanswered

JSON schema validation errors when parsing JSON

(0) ShareShare
ReportReport
Posted on by 17

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": []
}
]
Categories:
I have the same question (0)
  • Pstork1 Profile Picture
    68,691 Most Valuable Professional on at

    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.

  • VictorTek Profile Picture
    127 on at

    Hi

     

    Do you know if you can export error output from parse json ?

     

    thank you

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 425 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard