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
UR_Sage  
#1 Posted : Sunday, September 25, 2022 2:51:14 AM(UTC)
UR_Sage

Rank: Newbie

Groups: Registered
Joined: 4/30/2017(UTC)
Posts: 4
Location: Chicago

Hello! Looking for some guidance/assistance as I feel like I'm slamming my head against a wall.

Currently, I am pulling data from a spreadsheet at a rate of 5000 ms. Even with what I would consider a fairly slow pull frequency, I am running in to errors saying too many requests back to the google sheets api.

This goes on top of the fact that our quota is sitting well under the 300 read requests / minute, at least in the telemetry of GCP dashboard. When monitoring the API, it looks like I'm fluctuating between 8% all the way to 35% errors in GCP dashboard as well.

Does anyone happen to know if size of spreadsheet, or # of tabs has any particular affect on how often I'm seeing my read requests fail? Based on everything I see in GCP, I shouldn't be having any errors. Is vMIX sending read requests as a user and I'm looking at the wrong telemetry? Don't have a lot of experience in APIs so any help would be amazing.





Peter1000  
#2 Posted : Sunday, September 25, 2022 7:19:38 AM(UTC)
Peter1000

Rank: Advanced Member

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

Thanks: 17 times
Was thanked: 79 time(s) in 60 post(s)
if you do not pay for googles API, you can only pull data every 8 seconds. 8000 in vmix. with lower values, you will get the error message.
thanks 1 user thanked Peter1000 for this useful post.
sinc747 on 9/26/2022(UTC)
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.