Forum Discussion
Service Now API Invalid Character between object key and value
Having the same issue. It sometimes works then sometimes fails with this error message.
Hi bdarcy , did you ever solved the ServiceNow data load issue "We found an invalid character between object key and value in the JSON input."?
I am facing the same. Sometimes it works, sometimes it doesn't. Very anoying 😒
Hi tasa , we ended up doing a workaround by splitting the single dataflow into multiple. Basically having a couple source queries (ie: using the sysparam filter to divvy up the data which seemed to help) then combining into a final staging dataflow.
Since we only had Pro version of Power BI and could not use incremental load, this helped alleviate the volume of data being returned and the risk of it "falling in on itself".
May not be the most elegant solution but it seemed to work
Hi bdarcy , thanks a lot for your reply! I am glad you mentioned this because this is exctly what I had to do as well, splid the data extraction from ServiceNow by multiple queries by YEAR and then combine them at the end. Anyways, I agree with you, not the most elegant solutions, but it worked at the end 😊. Thanks a for your time!