I’m trying to load the PSC snapshot file (JSON format) into Excel Power Query and am getting the error: ‘Unable to connect. We found extra characters at the end of the JSON input’.
I’m hoping to use PQ to merge a list of company numbers with this snapshot to give me the PSC. Is this possible and what is the error?
Any help appreciated.
Thanks
1 Like
Did you ever resolve this Robert. I have the same issue.
No. Never got to the bottom of this. Have you managed to connect PQ directly to the CH database?
What’s the api query you are using? I’m interested in PSC data and currently replying on items in the filing list. If there’s a json error I’d be interested in finding an example in case it effects my project.
Hi andrew2, sorry we are not using the API to get the PSC.
We are using the snapshot files - Companies House. Our developer downloads them and unpacks them to our DB - but i am also trying to load them into PQ. Sorry for the confusion there.
1 Like
I’m having the same issue with R jsonlite::fromJSON()