Answered

Parse JSON error

(0) Share

Report

Posted on by ArisTale

Hello,

I am trying to Parse JSON to get an outcome from the approval where to let pass it with or without comments, but getting an error "message" like: "Required properties are missing from object: comments.".

Here is the schema used:

{
"type": "array",
"items": {
"type": "object",
"properties": {
"responder": {
"type": "object",
"properties": {
"id": {
"type": "string"
},
"displayName": {
"type": "string"
},
"email": {
"type": "string"
},
"tenantId": {
"type": "string"
},
"userPrincipalName": {
"type": "string"
}
}
},
"requestDate": {
"type": "string"
},
"responseDate": {
"type": "string"
},
"approverResponse": {
"type": "string"
},
"comments": {
"type": [
"string", "null"
]
}
},
"required": [
"responder",
"requestDate",
"responseDate",
"approverResponse",
"comments"
]
}
}

Please, help me to figure out what is wrong?!

Best regards,

Alexandra

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @ArisTale ,

are you using the "Approvals" connector? If yes, you should be able to grab the comments without parsing a JSON.

Please let me know if the issue is fixed.

If I have answered your question, please mark my post as Solved.

If you like my response, please give it a Thumbs Up.

I may not have all the answers, but I'm curious and passionate enough to keep looking for answers and to keep sharing them.

My blog site about Power Automate: https://powerautomatejoy.com/

BR,

Marco

Was this reply helpful? Yes No
ArisTale 72 on at

Like (0)

Report
Copy link

Link copied!

Hello @MarconettiMarco ,
I need to Parse JSON in my case and comments just a little piece of it. I am trying to find a solution for this part of the code which I shared here. Do you know how to fix it?

Do you have any link with an explanation for grabbing the comments in the Approvals? Curious now.

Best regards,
Alexandra

Was this reply helpful? Yes No
Verified answer

okeks 802 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

It seems that in some cases your input doesn't have data for some fields. E.g. in one of your inputs may be no comment.

In this case you need to remove this property from the required section and take care in the following actions that this field could be null.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ArisTale ,

As far as @okeks said, please remove the parts I marked and try again. If it works please consider mark @okeks 's solution as a 'solution' to help others.

Best Regards,

Bof

Was this reply helpful? Yes No
ThamiMtombeni 71 on at

Like (0)

Report
Copy link

Link copied!

Hi @ArisTale ,

Delete/remove all the required properties from your schema.
If I solved your issue ,please mark it as solution

Was this reply helpful? Yes No