Unanswered

Null Value Error in Parse JSON

(0) Share

Report

Posted on 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!

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

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.

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

Like (0)

Report

Thanks Pstork1,
Would you be able to elaborate a bit more on how to bypass the parse JSON if it is null?

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

Like (0)

Report

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.

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

Like (1)

Report

I am still receiving the same error message.

Was this reply helpful? Yes No
Suggested answer

Hellen ramos 12 on at

Like (1)

Report

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!

Was this reply helpful? Yes No