Answered

Parsing json failed

(0) Share

Report

Posted on by Libor

Hi,

Can anyone help me with a problem parsing json?
I am using an HTTP module to call an endpoint in the Confluence cloud. The response is in json. I need to find all the page IDs and titles. So I want to parse json using the Parse JSON module. And even when I use the response as a pattern for json schema, I still get an error that the schema validation failed.

I went through the steps that Copilot recommended to me and manually changed the types in the schema but now I am stuck with the type "results". I have used array, object and string but nothing has worked.
Also Copilot is quite unsure - when I use "array" it recommends "object", when I use "object" it recommends "array".

Does anyone know what I am doing wrong?

The schema and response are attached.

response.txt

schema.json

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Gyllentid 894 on at

Like (0)

Report
Copy link

Link copied!

Hello,

The old designer gives much better error message why the schema fails. I found, using your payload that the generated json schema had issues with fields either being string or null. ParentType and ParentId both can be either of type string or null.

You can amend them:

"parentType": {

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

"parentId": {

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

I had success using this schema:

{

"type": "object",

"properties": {

"results": {

"type": "array",

"items": {

"type": "object",

"properties": {

"parentType": {

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

},

"parentId": {

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

},

"spaceId": {

"type": "string"

},

"ownerId": {

"type": "string"

},

"lastOwnerId": {},

"createdAt": {

"type": "string"

},

"authorId": {

"type": "string"

},

"version": {

"type": "object",

"properties": {

"number": {

"type": "integer"

},

"message": {

"type": "string"

},

"minorEdit": {

"type": "boolean"

},

"authorId": {

"type": "string"

},

"createdAt": {

"type": "string"

}

}

},

"position": {

"type": "integer"

},

"body": {

"type": "object",

"properties": {}

},

"status": {

"type": "string"

},

"title": {

"type": "string"

},

"id": {

"type": "string"

},

"_links": {

"type": "object",

"properties": {

"editui": {

"type": "string"

},

"webui": {

"type": "string"

},

"edituiv2": {

"type": "string"

},

"tinyui": {

"type": "string"

}

}

}

},

"required": [

"parentType",

"parentId",

"spaceId",

"ownerId",

"lastOwnerId",

"createdAt",

"authorId",

"version",

"position",

"body",

"status",

"title",

"id",

"_links"

]

}

},

"_links": {

"type": "object",

"properties": {

"base": {

"type": "string"

}

}

}

}

}

Was this reply helpful? Yes No
Libor 8 on at

Like (0)

Report
Copy link

Link copied!

Excellent,

thank you for the quick reply and for the solution.

I changed both types as you described and now it works as I wanted.

Have a nice day

Libor

Was this reply helpful? Yes No