Unanswered

Parse json

(0) Share

Report

Posted on by JeffC

I have a weird issue going on. I have a PA job that has been running for months. However, all of a sudden both the parse json tasks inside the job says it fails but they actually succeed and the job continues. All the tasks after the parse json tasks also say fail but they still execute successfully (see screenshot).

If I switch the json jobs to go in a different order, whatever json task is first fails. The error that both jobs get is below.

Unable to process template language expressions in action 'Parse_JSON_-_Orientation_IT_Resource' inputs at line '0' and column '0': 'Required property 'content' expects a value but got null. Path ''.'.

Unable to process template language expressions in action 'Parse_JSON_-_Orientation_Time' inputs at line '0' and column '0': 'Required property 'content' expects a value but got null. Path ''.'.

Any assistance would be greatly appreciated.

Thank you,

Jeff

Categories:

Building flows

2023-03-31_23-41-...

2023-03-31_23-35-...

I have the same question (0)

All responses (6)

Answers (1)

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @JeffC

This happens because null comes in that particular field.

So, go to the schema and in all the fields or which ever field you are getting error just change its type.

So let's say you have a field:

"Type": "string"

Change it to:

"Type":["string","null"]

You can also remove all the fields from required in json schema, sometimes that works too.

This should work for you.

I hope this helps 🙂

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Could you show the output of "Compose - orienation..."?

Was this reply helpful? Yes No
Verified answer

JeffC on at

Like (0)

Report

This issue has been solved. There was an entry in the SharePoint list that was messing up the flow. I deleted the entry and the problem went away. Doesn't make a lot of sense but since nothing changes in the flow I guess something happened with this entry that was messing it up.

Thank you all for your replies. I really appreciate it.

Was this reply helpful? Yes No
MyMy 4 on at

Like (0)

Report

Hello JeffC, I have faced with this error as well. Do you have any idea with this? I've the sharepoint but nothing has changed :((

Was this reply helpful? Yes No
JeffC on at

Like (0)

Report

Unfortunately, I don't have any additonal info from you. As the solution stated, there was an entry in my SharePoint list that was causing an issue and when I removed the entry the problem went away.

If you expand out your flow so people can see it, perhaps we can assist. The parsed json says it isn't finding any data.

Was this reply helpful? Yes No
MyMy 4 on at

Like (0)

Report

Hi JeffC, Thank you for your support. I have already found out the issue. The parsed json has no problems, it belongs to my Microsoft form. I've already fixed it. Thanks again for your kind support. Have a nice week ahead.

Was this reply helpful? Yes No