You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Currently the only way to update who guessed the movie is via the spreadsheet although this works it means if we want others to host the guessing they would need access to the master data and it is better to not allow direct editing there unless required. As a result it makes sense to do it via the app providing they have the key of course.
Implementation Details
As Sheet.Best has limits on how often we can hit their endpoints each month keeping an eye on that is important after this rollout and frequent use. As it may facilitate the need to move to Google Sheet API instead.
As the spreadsheet also uses fixed names in the spreadsheet we should extract them and bring them to the front as well, would require a new call and this section should be very heavily cached maybe 1 week as names do not get added or removed often, but have a cache kill endpoint if needed to update.
As this new endpoint would return names it needs to use the token as well.
Most of the functionality should already exist for this just the last bit calling the sheet.best update endpoint needs some testing to get it working correctly
Acceptance Criteria
I am able to once authorized select the winner and save that into the sheet correctly
The text was updated successfully, but these errors were encountered:
Background
Currently the only way to update who guessed the movie is via the spreadsheet although this works it means if we want others to host the guessing they would need access to the master data and it is better to not allow direct editing there unless required. As a result it makes sense to do it via the app providing they have the key of course.
Implementation Details
As Sheet.Best has limits on how often we can hit their endpoints each month keeping an eye on that is important after this rollout and frequent use. As it may facilitate the need to move to Google Sheet API instead.
As the spreadsheet also uses fixed names in the spreadsheet we should extract them and bring them to the front as well, would require a new call and this section should be very heavily cached maybe 1 week as names do not get added or removed often, but have a cache kill endpoint if needed to update.
As this new endpoint would return names it needs to use the token as well.
Most of the functionality should already exist for this just the last bit calling the sheet.best update endpoint needs some testing to get it working correctly
Acceptance Criteria
The text was updated successfully, but these errors were encountered: