Unanswered

Parse JSON Required Properties Missing

(0) Share

Report

Posted on by RedSnow_94

Hello,

I have a flow used to register chemicals in a lab. The user submits an MS Form to capture details of the chemical and create a List entry. Part of the flow sends an HTTP request to an online database to fetch chemical details (name, hazards etc) based on a unique chemical number. Sometimes this information is available, sometimes not, but I have built the flow to handle when it cannot find any information.

However, I have found the flow failing when trying to Parse the response of the HTTP request with the error message:

"Required properties are missing from object: bonds."

The screenshot below is the schema of the Parse step:

And the output of the failed Parse step is:

I'm confused as the error message suggests the required property "bonds" is missing, but according to the output the "bonds" property is populated?

If anyone can help my understand where I am going wrong or misunderstanding I would be grateful!

Thanks

I have the same question (0)

All responses (5)

Answers (0)

Expiscornovus 32,914 Most Valuable Professional on at

Like (0)

Report

Re: Parse JSON Required Properties Missing

Hi @RedSnow_94,

I see a content property in the top of your json, but that seems to be missing in your Parse Json schema?

Can you used the output of the failed parse json step and generate an new schema with the Generate from sample button?

Was this reply helpful? Yes No
RedSnow_94 32 on at

Like (0)

Report

Re: Parse JSON Required Properties Missing

Thank you for replying. Not sure I follow, the output of the failed step is below:

Was this reply helpful? Yes No
Expiscornovus 32,914 Most Valuable Professional on at

Like (0)

Report

Re: Parse JSON Required Properties Missing

Hi @RedSnow_94,

Apologies for not being clear. I just wanted to double check how you created your json schema. It looks like it is missing something.

Normally the easiest way is to use a sample inputs payload with the Generate from sample button. Did you generate it like that?

Can you also share that specific sample payload (obfuscate data if needed) over here as a code snippet (instead of a screenshot). This way we can also check it in an IDE/json viewer. Makes troubleshooting a bit easier.

Was this reply helpful? Yes No
RedSnow_94 32 on at

Like (0)

Report

Re: Parse JSON Required Properties Missing

No problem! I appreciate your help.

I have pasted below the full schema and below that, an example of the payload that returns an error:

{
"type": "object",
"properties": {
"PC_Compounds": {
"type": "array",
"items": {
"type": "object",
"properties": {
"id": {
"type": "object",
"properties": {
"id": {
"type": "object",
"properties": {
"cid": {
"type": "integer"
}
}
}
}
},
"atoms": {
"type": "object",
"properties": {
"aid": {
"type": "array",
"items": {
"type": "integer"
}
},
"element": {
"type": "array",
"items": {
"type": "integer"
}
}
}
},
"bonds": {
"type": "object",
"properties": {
"aid1": {
"type": "array",
"items": {
"type": "integer"
}
},
"aid2": {
"type": "array",
"items": {
"type": "integer"
}
},
"order": {
"type": "array",
"items": {
"type": "integer"
}
}
}
},
"coords": {
"type": "array",
"items": {
"type": "object",
"properties": {
"type": {
"type": "array",
"items": {
"type": "integer"
}
},
"aid": {
"type": "array",
"items": {
"type": "integer"
}
},
"conformers": {
"type": "array",
"items": {
"type": "object",
"properties": {
"x": {
"type": "array"
},
"y": {
"type": "array",
"items": {
"type": "number"
}
}
},
"required": [
"x",
"y"
]
}
}
},
"required": [
"type",
"aid",
"conformers"
]
}
},
"charge": {
"type": "integer"
},
"props": {
"type": "array",
"items": {
"type": "object",
"properties": {
"urn": {
"type": "object",
"properties": {
"label": {
"type": "string"
},
"name": {
"type": "string"
},
"datatype": {
"type": "integer"
},
"release": {
"type": "string"
}
}
},
"value": {
"type": "object",
"properties": {
"ival": {
"type": "integer"
}
}
}
},
"required": [
"urn",
"value"
]
}
},
"count": {
"type": "object",
"properties": {
"heavy_atom": {
"type": "integer"
},
"atom_chiral": {
"type": "integer"
},
"atom_chiral_def": {
"type": "integer"
},
"atom_chiral_undef": {
"type": "integer"
},
"bond_chiral": {
"type": "integer"
},
"bond_chiral_def": {
"type": "integer"
},
"bond_chiral_undef": {
"type": "integer"
},
"isotope_atom": {
"type": "integer"
},
"covalent_unit": {
"type": "integer"
},
"tautomers": {
"type": "integer"
}
}
}
},
"required": [
"id",
"atoms",
"coords",
"charge",
"props",
"count"
]
}
}
}
}

Was this reply helpful? Yes No
RedSnow_94 32 on at

Like (0)

Report

Re: Parse JSON Required Properties Missing

Payload exceed character limit to post, have attached as a doc file.

json payload.docx

Was this reply helpful? Yes No