Unable to parse response from Google - expected json but received the following

[Neopolitan234]

Describe the bug
Not sure it's a bug, but I uploaded my json and received a Google Parse error. Tried rewriting the json and resetting/assigning the API key, but no difference.

Expected behavior
I expected the file to write out properly with the cell information... but instead the written file was blank. All of my files and keys are set up correctly as far as json checkers and the software are concerned

Desktop (please complete the following information):

• OS: Windows
• Version 11
  

[GrandyB]

The error is suggesting that the URL for the sheet cannot be found. It tried, and it 404'd. Looking at the URL it tried, just at face value it doesn't seem weird (am afk this very moment).

The most common cause of this is when people don't set their Google sheet sharing settings so that it's viewable by "anyone with this link".

If you've already got that, try removing the space from the tab name and in your config and see if that fixes it. I don't know if this is a limitation, but figured I'd mention it on a hunch.

If those don't fix it, we can look deeper at it, and do let me know if you end up using SheetsIO as part of a project etc!

[Neopolitan234]

My sheet is set to that… so I was sure that wasn’t the issue

…

On Mon, Jan 9, 2023 at 5:14 PM Mark Bishop ***@***.***> wrote: The error is suggesting that the URL for the sheet cannot be found. It tried, and it 404'd. The most common cause of this is when people don't set their Google sheet sharing settings so that it's viewable by "anyone with this link". If that doesn't fix it, we can look deeper at it. — Reply to this email directly, view it on GitHub <#45 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A5FID33VF7TTQOAX3R42ZFDWRSLW7ANCNFSM6AAAAAATV7JVFM> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[GrandyB]

Ah! Fair enough, thought I'd double check.
Just had a second look and have another hunch.

You've got a forward slash in your tab name which doesn't look like it's being encoded in the URL properly. Try removing or replacing the forward slash. I'll see if I can do something about that in the code for a future release.

[Neopolitan234]

That worked!

…

On Mon, Jan 9, 2023 at 6:21 PM Mark Bishop ***@***.***> wrote: Ah! Just had a second look and I think I know what it is. You've got a forward slash in your tab name which is not being encoded in the URL properly. Try removing or replacing it. — Reply to this email directly, view it on GitHub <#45 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A5FID325COERCAGCKQK5PZ3WRSTPVANCNFSM6AAAAAATV7JVFM> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[GrandyB]

Jolly good.

Best of luck with your project, and if you encounter any more issues please raise new issues for them; will keep this one open just as a reminder for me to take a look at fixing this.

Cheers!

[suhibsb]

i have the same problem but all correct can you please help me

[GrandyB]

i have the same problem but all correct can you please help me

Hi there, first thing to do would be to remove the /edit#gid=0 bit from the end of your spreadsheetId.
If that's the only thing wrong, hopefully it'll then connect right up.

[suhibsb]

Hi there, i did but still the same, i really need this to work i have important thing to do

[GrandyB]

@suhibsb You haven't saved the config file...
You'll then need to press the reload config button in the program and/or relaunch it.

[suhibsb]

i did still not working @GrandyB i dont know whats the problem

it gives me files but empty

[suhibsb]

well it worked the problem was with colmn 3 i dont know why
when i deleted the data it wokred

[suhibsb]

but i have another problem when i put a photo in cell it dosent get updated

[GrandyB]

Well, that error is because your config expects the cell to be a link to an image, but at the time the cell had "asdasd" in it, which isn't an image link. Image cells must always have a link to an image in them.

Not all image hosting websites work so perhaps try a different one? Imgur usually works for me.

Either way, this is off topic for this issue thread and I would advise going through the wiki tab in this repo and reading the readme thoroughly as the things you're coming across should be explained as part of that. Any other issues, raise a new ticket for it please instead of putting it in this one.

[suhibsb]

Thank you very much @GrandyB everything working good now thanks for your time