I’m a developer for a small closed community which relies on Google Spreadsheets for specific goals like storing player data across multiple games. I’m fully aware that Google Spreadsheets do not serve as a database and as the only reason this is being used is because as I said it’s a small community, thus spending extra money on a proper one is expensive compared to this.
The database system stores all the player data in a JSON encoded value per player key which has significantly reduced the amount of HttpRequests the system used to create per sheet.
This problem has occured once in 2018 which was shortly fixed 2 weeks later. We assumed this was the case for the problem again, however it wasn’t.
The issue itself is that we can retrieve data via GetAsync but cannot edit data via PostAsync. This is a confirmed Roblox issue as using the url that usually gets sent in the Lua code for PostAsync(url) in Chrome seems to work seamlessly and from what I’ve head HTTP 405 is a client error. Do correct me if I’m mistaken.
The bug happens in normal games as well as in the Roblox Studio application. Before this all happened there was an occurance where you couldn’t use PostAsync with it in Studio, but could in-game.
It firstly occured 7th of July at 5:16PM Central European Time.
Other Groups in the community seem to be having the same issue.
The url key is structured as https://script.google.com/macros/s/APIKEY/exec
and the arguments and information that needs to get passed on is added on to the link upon request.
This system was set up by using this tutorial: