Unanswered

The 'content' property of actions of type 'ParseJson' must be valid JSON. The provided value cannot be parsed: 'Error parsing Infinity value'

(0) Share

Report

Posted on by bchea

Trying to understand where the issue is with the JSON on the parse JSON step.

Full Error: The 'content' property of actions of type 'ParseJson' must be valid JSON. The provided value cannot be parsed: 'Error parsing Infinity value. Path '', line 1, position 1.'.

JSON response in body:

{

"@odata.context": "$metadata#Students(studentID,domainID,orgID,lastName,firstName,notActive,roleID)",

"@odata.metadataEtag": "W/\"705e7fea-6c73-4b97-9aeb-9be57bfa2033\"",

"value": [

{

"studentID": "68818",

"domainID": "XXX",

"orgID": "TD1701MC1132",

"lastName": "SMITH",

"firstName": "ABEL",

"notActive": "no",

"roleID": "EMPLOYEE_XXX"

}

]

}

The Parse JSON schema is below:

{

"type": "object",

"properties": {

"value": {

"type": "array",

"items": {

"type": "object",

"properties": {

"studentID": {

"type": "string"

"domainID": {

"type": "string"

"orgID": {

"type": "string"

"lastName": {

"type": "string"

"firstName": {

"type": "string"

"notActive": {

"type": "string"

"roleID": {

"type": "string"

}

"required": [

"studentID",

"domainID",

"orgID",

"lastName",

"firstName",

"notActive",

"roleID"

]

}

"@odata.context": {

"type": "string"

"@odata.metadataEtag": {

"type": "string"

}

I copied and pasted the JSON to generate the schema and it recognized it. However, when running the flow, it keeps hanging on this parse JSON step. What does 'Error parsing Infinity value' mean?

Thanks in advance.

Categories:

Process Advisor

All responses (2)

Answers (0)

bchea 2 on at

Like (0)

Report

Re: The 'content' property of actions of type 'ParseJson' must be valid JSON. The provided value cannot be parsed: 'Error parsing Infinity value'

Still getting the same error. While I did update the schema to add the extra @:

the resulting error still looks like there is only one @:
Expiscornovus 32,131 Most Valuable Professional on at

Like (0)

Report
Re: The 'content' property of actions of type 'ParseJson' must be valid JSON. The provided value cannot be parsed: 'Error parsing Infinity value'

Hi @bchea,

I just tried to reproduce this issue.

When I use your payload sample to generate a json schema I am getting the parse json schema below. As you can see it is slightly different because the @ characters are escaped for the data.context & data.metadataEtag properties.

Can you try if this json schema works for your setup?

{ "type": "object", "properties": { "@@odata.context": { "type": "string" }, "@@odata.metadataEtag": { "type": "string" }, "value": { "type": "array", "items": { "type": "object", "properties": { "studentID": { "type": "string" }, "domainID": { "type": "string" }, "orgID": { "type": "string" }, "lastName": { "type": "string" }, "firstName": { "type": "string" }, "notActive": { "type": "string" }, "roleID": { "type": "string" } }, "required": [ "studentID", "domainID", "orgID", "lastName", "firstName", "notActive", "roleID" ] } } } }