Parse JSON error

(0) Share

Report

Posted on by senna

189

I have some json that i get from a website using the http connector, i then parse the json but getting an error

"Invalid type. Expected Integer but got Null."

I have check and the json below gets returned as valid and when i enter it as a sample for the parse JSON it does not throw the error, but when the flow runs it errors out, any idea what they below is throwing an error;

[
 {
 "kind":"special",
 "data":{
 "after":null,
 "dist":1,
 "geo_filter":"",
 "children":[
 {
 "kind":"t3",
 "data":{
 "saved":false,
 "is_video":false
 }
 }
 ],
 "now":null
 }
 },
 {
 "kind":"special",
 "data":{
 "after":null,
 "dist":null,
 "geo_filter":"",
 "children":[
 {
 "kind":"t1",
 "data":{
				 "collapsed":false,
 "body":"1-0",
 "ups":1
 }
 },
 {
 "kind":"t1",
 "data":{
 "collapsed":false,
 "body":"0-4",
 "ups":1
 }
 }
 ],
 "now":null
 }
 }
]

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

SanmeshG 1,947 Moderator on at

Like (0)

Report

Hi @CiaranCampbell ,

This issue is caused when you have parsed the JSON initially when the datatype of a particular column was of type int , but later for the JSON received, it had a null value in place of the integer , and hence there is a schema mismatch and you are running into this error.

Please change the schema of the integer type to any in the JSON schema , this will help in schema validation if even there is a type mismatch.

If this helps please accept it as solution.

Thanks,
Sanmesh

Was this reply helpful? Yes No
Verified answer

SanmeshG 1,947 Moderator on at

Like (1)

Report

Hi @CiaranCampbell ,

This issue is caused when you have parsed the JSON initially when the datatype of a particular column was of type int , but later for the JSON received, had a null value in place of the integer , and null hence there is a schema mismatch and you are running into this error.

Please change the schema of the integer type to any in the JSON schema , this will help in schema validation if even there is a type mismatch.

If this helps please accept it as solution.

Thanks,
Sanmesh

Was this reply helpful? Yes No