Google API Error But Config Refresh Briefly Fixes It

[Nerdvana12]

Describe the bug
Popup saying "unable to parse response from google - expected json but received the following". Reloading the config fixes it briefly and things run fine but then it pops up again. This happens to both me and another person set up with the sheet

To Reproduce
Unsure what's causing it

Expected behavior
Popup matching the SS below

Screenshots
Screenshot and logs from my PC

app-2024-09-24.log
app-2024-09-23.log
app-2024-09-25.log

Logs from the other person's PC
app-2024-09-23.log
app-2024-09-24.log

Desktop (please complete the following information):

• OS: Windows 10 Home
• Version 22H2

Additional context
Unsure the version of the other person's PC. I know the OS is windows

[GrandyB]

Thank you for the detailed report!
In the last day I've received 4 or so reports of this issue.
With one of them, I have gotten them to make the exact same request SheetsIO uses but in the browser, and they can still hit this issue through the browser, which to me suggests that the issue is not strictly SheetsIO's problem.

However, I have a Discord group chat with the 4 of them, trying things out, and looking to improve SheetsIO by being less brittle to responses like this and instead opting to allow the update chain to retry without throwing a hissy fit, and logging that it did this somewhere obvious.

So stay tuned.

[GrandyB]

Aight - sent a few variations of logging over to them and gotten valuable info back.
Massive thanks to Ely, Thyme, Joryan and Mileve!
I also eventually managed to get it to happen to me locally (only took 16 minutes for it to encounter a 502!).

Either way, here's a very temporary build that adds said logging and skips any >500 response code (>500 codes are usually tied to the server/google having issues basically): https://drive.google.com/file/d/1YcXuK9cni6Zl9JfL5dYpWqbnRgadnxrx/view?usp=sharing

If you need something desperately quick, consider using that - you just delete the .jar file from your SheetsIO directory, put this one in, and then run runJar.bat and it'll load up. It will log the issue in the console as e.g. ERROR: 502 found, but skipped: and skip the current update cycle, but then attempt again on the next loop.

I'll now be working on reducing the # of error popups and introducing a logging view for request issues and producing a more official next release of the tool.