Parse Json to include Null?

(0) Share

Report

Posted on by hmenzel

How can I edit this parse Json to allow "null" items? The flow needs to proceed both with or without a file attachment.

{

"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"

]

}

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Not sure if I understood the question correct but you can change the type to an array and add the possibility to allow null.

change the type from

"type": "string"

to

"type": ["string", "null"]

Was this reply helpful? Yes No
hmenzel 23 on at

Like (0)

Report

Thanks for the suggestion. I added those (see below), but it still produced an error "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 ''.'." Any other ideas?

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "name": {
                "type": [
                    "string",
                    "null"
                ]
            },
            "link": {
                "type": [
                    "string",
                    "null"
                ]
            },
            "id": {
                "type": [
                    "string",
                    "null"
                ]
            },
            "type": {},
            "size": {
                "type": "integer"
            },
            "referenceId": {
                "type": "string"
            },
            "driveId": {
                "type": "string"
            },
            "status": {
                "type": "integer"
            },
            "uploadSessionUrl": {}
        },
        "required": [
            "name",
            "link",
            "id",
            "type",
            "size",
            "referenceId",
            "driveId",
            "status",
            "uploadSessionUrl"
        ]
    }
}

Was this reply helpful? Yes No
Verified answer

Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report
Ok, now I think I got it. You don't need the change the schema. The content is the problem. You could use this function in the content to solve the problem.

coalesce(null, json('[]'))

Instead of null you have to put in whatever is currently in the content field.

Was this reply helpful? Yes No
hmenzel 23 on at

Like (0)

Report

Ah, okay. Where would I add this exactly?

Was this reply helpful? Yes No
Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Was this reply helpful? Yes No