logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
Data Source Google Sheets ERROR - ERROR: 429 Too Many Requests
Options
Go to last post Go to first unread
Previous Topic Next Topic
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
Back to top

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
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,162
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.
Back to top
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.
Back to top
Users browsing this topic
Guest (2)
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.

Privacy Policy | Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.103 seconds.