Unanswered

Null Value Error in Parse JSON

Like (0) Share

Report

Posted on 15 Dec 2020 17:01:38 by Community Power Pla...

Hello I receive the following error when running my flow.

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

Below is my Parse JSON schema:

{

"type": "array",

"items": {

"type": "object",

"properties": {

"name": {

"type": "string"

"link": {

"type": "string"

"id": {

"type": "string"

"type": {},

"size": {

"type": "integer"

"referenceId": {

"type": "string"

"driveId": {

"type": "string"

"status": {

"type": "integer"

"uploadSessionUrl": {}

"required": [

"name",

"link",

"id",

"type",

"size",

"referenceId",

"driveId",

"status",

"uploadSessionUrl"

]

}

The flow is pulling picture attachments from a Microsoft Form and putting it into a sharepoint grid. I want it to allow a null value, but I'm not entirely sure how. There are multiple attachments from different forms questions. I am still fairly new to this, so any help would be appreciated. Thank you!

All responses (5)

Answers (0)

Suggested answer

Hellen ramos 12 on 19 Mar 2025 at 17:10:03

Like (1)

Report

Null Value Error in Parse JSON

Hey!
Try to modify your array like this:

{

    "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": {}

        }

    }

}

Every time you need to pass values that may be empty, you need to add the "null" type in the parse and remove the required part.

Hope it helped!
Community Power Pla... on 15 Dec 2020 at 18:43:44

Like (1)

Report

Re: Null Value Error in Parse JSON

I am still receiving the same error message.
Pstork1 66,454 Most Valuable Professional on 15 Dec 2020 at 17:47:32

Like (0)

Report

Re: Null Value Error in Parse JSON

Put a condition before the Parse JSON action and test the input to see if its blank. only execute the Parse JSON step if the input isn't blank.
Community Power Pla... on 15 Dec 2020 at 17:25:33

Like (0)

Report

Re: Null Value Error in Parse JSON

Thanks Pstork1,
Would you be able to elaborate a bit more on how to bypass the parse JSON if it is null?
Pstork1 66,454 Most Valuable Professional on 15 Dec 2020 at 17:06:10

Like (0)

Report

Re: Null Value Error in Parse JSON

The problem is that the value you are trying to Parse is null. You need to put a condition in to evaluate the value before you feed it to the Parse JSON. If the value is empty (null) then you need to bypass the parse JSON or use a Parse JSON that is using static content.