Unanswered

Parse JSON error

(0) Share

Report

Posted on by Community Power Pla...

I'm following this blog post to create a SharePoint group then assign permissions and users.

My flow fails at step 5 - Parse JSON.

Error message is: Unable to process template language expressions in action 'Parse_JSON_-_Owners' inputs at line '1' and column '16532': 'Required property 'content' expects a value but got null. Path ''.'. Any idea where I could be going wrong with it?

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (1)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report

@Anonymous when you use sample json which does not handle null value.

Please go through this post

https://www.google.com/amp/s/msolenacrm.blog/2020/07/06/power-automate-parse-json-action-with-value-or-null/amp/

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Double check that your HTTP request is actually returning data and not a null array. This error complaining about a null Path usually means there is no data in the Body you are trying to parse.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks @Hardesh15 - that's helpful. I might try option 1 as I don't need to generate dynamic content value.
Could you tell me where I would need to add the null value to this part of the code?:
"Owner": {
"type": "object",
"properties": {
"__deferred": {
"type": "object","null"
"properties": {
"uri": {
"type": "string"
}
}
}
}
},
"Users": {
"type": "object",
"properties": {
"__deferred": {
"type": "object","null"
"properties": {
"uri": {
"type": "string"
}

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Pstork1 Thanks, that was my first thought. However there is data in the Body of the HTTP request:

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous Run your flow and expand https action copy http action output and put this in parse json sample. Try this and let me know.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Still no luck @Hardesh15 . I identified a property that was coming up as null and tried option 1 and 3 from the post but get the same error.
"RequestToJoinLeaveEmailSetting": {}

"RequestToJoinLeaveEmailSetting": {"type": [
                    "number",
                    "null"
                ]}

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous As expected. Please use in this way.

"RequestToJoinLeaveEmailSetting":

[

{

"type": "number"

},

{

"type": "null"
}

]

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks for the suggestion @Hardesh15 but this didn't work on my flow, nor did any other attempts at getting rid of that null value.
I do wonder if the issue is with the body of the HTTP request as @Pstork1 suggested, since that is what the error message suggests too. But I can't see how it could be turning up null.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous

Check the response status code from the HTTP Post. You might be getting 202. The request has been accepted for processing, but the processing has not been completed.

Thanks

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (1)

Report

I worked it out finally. In the HTTP request to create the group, I had to add "RequestToJoinLeaveEmailSetting": "true" in the body.

Was this reply helpful? Yes No