logo

Live Production Software Forums


Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
curtismacd31  
#1 Posted : Saturday, January 26, 2019 8:07:03 AM(UTC)
curtismacd31

Rank: Advanced Member

Groups: Registered
Joined: 7/18/2014(UTC)
Posts: 84

Was thanked: 10 time(s) in 8 post(s)

Hi All,

I have been using Google Sheets for quite a number of projects and this is a problem that has troubled me every time. Some of the time when a user updates the spreadsheet to updates instantly in vMix and without issue, But a lot of the time I get this error:

ERROR: the remote server returned an error: (429) Too Many Requests.

Could I have missed something with the api or setting something up incorrectly to get this so frequently?

Thanks
ask  
#2 Posted : Saturday, January 26, 2019 2:29:18 PM(UTC)
ask

Rank: Advanced Member

Groups: Registered
Joined: 10/13/2012(UTC)
Posts: 1,161
Australia
Location: Melbourne

Thanks: 220 times
Was thanked: 199 time(s) in 181 post(s)
I seem to remember that there was an issue with Google sheets and high volumes of transactions. Do a search on this forum.
MartLeib  
#3 Posted : Saturday, January 26, 2019 7:25:01 PM(UTC)
MartLeib

Rank: Advanced Member

Groups: Registered
Joined: 2/23/2017(UTC)
Posts: 189
Estonia

Thanks: 1 times
Was thanked: 52 time(s) in 42 post(s)
It is not an "issue" it is by design to limit "free" account's requests. In your Google API console it says, how much requests you can make per day/100s. Also, each sheet will get seperate requests. For example, you have 5 sheets in a single spreadsheet document and you update it every 1000ms, it will make out to 5 requests per second.

You can easily upgrade to higher number of allowed requests. Check in the Api Console and Sheets API - Quotas.
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.