logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
Google Sheets "Too Many Requests" - Ever fixed??
Options
Go to last post Go to first unread
Previous Topic Next Topic
BoxMan_Actual  
#1 Posted : Wednesday, August 28, 2024 5:58:05 AM(UTC)
BoxMan_Actual

Rank: Member

Groups: Registered
Joined: 4/15/2023(UTC)
Posts: 14
United States
Location: Austin

Thanks: 1 times
Hey I've searched the forums and not seen anything on this. I've properly implemented Google Sheets API and it pulls text from my google sheet, but I get the error "Too Many Requests" from within vMix, no matter how infrequently I have the data update (30,000 milliseconds). I'm only pulling from 5 text fields.

Is this error still going? That seems insane if so! Help!
Back to top

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
Peter1000  
#2 Posted : Wednesday, August 28, 2024 3:11:46 PM(UTC)
Peter1000

Rank: Advanced Member

Groups: Registered
Joined: 1/25/2019(UTC)
Posts: 303
Switzerland

Thanks: 17 times
Was thanked: 79 time(s) in 60 post(s)
The Google Sheets API is free to use, but usage limits apply to each user. If your app is heavily used by many users, you will receive an error message (429: Too many requests)
You can buy credits to avoid this if you need shorter response times. In my experience, a value below 8000 ms results in an error message too many requests (in the “Manage Datasource” window of vMix, bottom right, Update Data every xxx Miliseconds)
There is a good description here
https://golayer.io/blog/google-sheets/google-sheets-api/
Back to top
BoxMan_Actual  
#3 Posted : Thursday, August 29, 2024 1:08:02 AM(UTC)
BoxMan_Actual

Rank: Member

Groups: Registered
Joined: 4/15/2023(UTC)
Posts: 14
United States
Location: Austin

Thanks: 1 times
Thanks for this! I actually set the refresh time to every 30,000 milliseconds though!
Back to top
Henny  
#4 Posted : Thursday, August 29, 2024 5:47:08 AM(UTC)
Henny

Rank: Advanced Member

Groups: Registered
Joined: 5/14/2013(UTC)
Posts: 140
Man
Location: uk

Thanks: 2 times
Was thanked: 24 time(s) in 20 post(s)
Also one thing to note if your google sheet has more than one page/sheet vmix will request all sheets every time to increasing your request rate
Back to top
Users browsing this topic
Guest
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.159 seconds.