error with flow - Action 'Parse_JSON' failed

(0) Share

Report

Posted on by Teaquell

Hi all,

I have an error with my flow - Action 'Parse_JSON' failed:

Details:

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

Screenshot 2022-10-18 143304.png

It appears when a the file upload feature on the MS Form is not inputted, but as this question on the Form is optional we need this flow to work either when the file upload is present or not.

Attached is a screenshot.

Many thanks,

Andy

All responses (3)

Answers (0)

Teaquell on at

Like (0)

Report

Re: error with flow - Action 'Parse_JSON' failed

Hey this did not work and I am still getting an error (see image below) I can provide my schema:
{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "name": {
                "type": ["string","null"]
            },
            "link": {
                "type": ["string","null"]
            },
            "id": {
                "type": ["string","null"]
            },
            "type": {},
            "size": {
                "type": ["integer","null"]
            },
            "referenceId": {
                "type": ["string","null"]
            },
            "driveId": {
                "type": ["string","null"]
            },
            "status": {
                "type": ["integer" , "null"]
            },
            "uploadSessionUrl": {}
        }


    }
}

Thanks,
Andy
Kaif_Siddique 2,104 Super User 2024 Season 1 on at

Like (0)

Report

Re: error with flow - Action 'Parse_JSON' failed

Hi @Teaquell

Try the below steps:

Step1: Remove the Parse Json step and run the flow.

Step2: Copy the body from the Get response details output and paste to Parse JSON Schema.

Step3: Add Parse JSON and provide Schema.

Step4: Run the flow again

Let me know if this works for you.

Regards
Kaif
Sundeep_Malik 6,480 on at

Like (0)

Report

Re: error with flow - Action 'Parse_JSON' failed

Hey @Teaquell
Not sure this method will work in your case or not.
But modify your parse json.

Where ever you are getting error.

Just modify somethings there.
So for example, the following is written there:
"type": "string"
Instead of the above write there:
"type": ["string","null"]