Forum Discussion
Service Now API Invalid Character between object key and value
Recently ran into this issue. JSON payload met RFC standards and could be validated in other tools.
Resolution was upgrading from the v110 (November 2022) to v114 of Power BI.
No idea what other versions of Power BI were affected.
😱mine is v114 and is throwing this same error over and over
Anyone any other idea???
- DonBates3 years agoNew Member
Just to verify it's definitely the "We found an invalid character between object key and value in the JSON input."?
Are you running table API or a custom Scripted REST API?With API Explorer it was definitely a valid JSON payload?
Once I had validated it was a valid JSON payload I did play around with ensuring data was trimmed, but with the specific message we're getting here, none of that would have resolved the issue. There was no invalid characters, just a non-printable ASCII 20 space between name-value pair.
I suppose there could be some quotation marks in your value that isn't properly escaped by ServiceNow, but seems odd. If you're running a Scripted REST API then start limiting the number of records returned, and make sure they have a specific order, to make your troubleshooting easier. Start with only returning a single specific record.
I had loaded BI fresh on another computer, but the gentleman that originally reported the issue really did just upgrade his BI in place.- joserenato-nova3 years agoNew Member
It just worked
An update from yesterday to Version: 2.115.663.0 64-bit (March 2023)
All blue sky again😉