Forum Discussion
Unexpected end of input was found in JSON content
Hello Anonymous
this means a Json-file is corrupted. Maybe created by a interface. What you could do if one character is missing at the end and in case put it... so basically reading the binary from json, adding the missing character if missing and then reread it.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
JimmyHello Anonymous
I think the error is not even caused by this query but the error is caused by the query you are merging with. So the error appears when the merged query is queried. But still.... the problem is probably a corrupted json-file.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hi Jimmy801 ,
Update on above. Now it refreshes fine at the powerQuery level. Havent dont anything at all 🙄
and give the same below error after close and apply. But again it will pop up once i refresh the current view in powerQuery!
I know this question is old, but maybe this helps someone. In my case invalid JSON was the consequence of timeout. Query was not finished and followup action failed to process invalid data in json format. The solution is straight forward, give quesry more time.