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
jip  
#1 Posted : Wednesday, March 8, 2017 4:58:59 AM(UTC)
jip

Rank: Advanced Member

Groups: Registered
Joined: 7/23/2013(UTC)
Posts: 122
Estonia
Location: North

Thanks: 12 times
Was thanked: 13 time(s) in 11 post(s)
Hello,

I'm having trouble accessing Google Sheets as Data Source. I have followed the vMix help instructions for setting up API Key and getting the link to desired Sheets document. However, vMix only gives an error 400 about Bad request when accessing the sheets. I'm using the latest vMix 18.

Is there a general issue with Google Sheets?

API key should be fine, as with other key the error is 403 Forbidden.
URL to Sheets is directly from sharing page, in format
https://docs.google.com/spreadsheets/d/[sheet ID]/edit?usp=sharing

I've tried also without URL parameters with no change.

Any help on this matter?
MCPSStv  
#2 Posted : Thursday, July 20, 2017 11:08:24 AM(UTC)
MCPSStv

Rank: Newbie

Groups: Registered
Joined: 8/15/2015(UTC)
Posts: 8
Location: Mobile, AL USA

We are having the same issue now. Did you ever find a solution?
jip  
#3 Posted : Thursday, July 20, 2017 5:15:38 PM(UTC)
jip

Rank: Advanced Member

Groups: Registered
Joined: 7/23/2013(UTC)
Posts: 122
Estonia
Location: North

Thanks: 12 times
Was thanked: 13 time(s) in 11 post(s)
MCPSStv wrote:
We are having the same issue now. Did you ever find a solution?


Hi,
If I remember correctly, the Google Api Keys did require some additional setup. Therefore, make sure that you have the API key as well as credentials set up properly.
Eventually, I think carefully following the steps outlined in the vMix help should do it:
http://www.vmix.com/help19/GoogleAPIKey.html
RandomStreamer  
#4 Posted : Thursday, July 20, 2017 6:12:27 PM(UTC)
RandomStreamer

Rank: Advanced Member

Groups: Registered
Joined: 5/19/2017(UTC)
Posts: 54

Thanks: 3 times
Was thanked: 13 time(s) in 12 post(s)
jip wrote:
MCPSStv wrote:
We are having the same issue now. Did you ever find a solution?


Hi,
If I remember correctly, the Google Api Keys did require some additional setup. Therefore, make sure that you have the API key as well as credentials set up properly.
Eventually, I think carefully following the steps outlined in the vMix help should do it:
http://www.vmix.com/help19/GoogleAPIKey.html


I got mine working after follow these 2:

http://www.vmix.com/help19/DataSourcesTypes.html
http://www.vmix.com/help19/GoogleAPIKey.html


But I have another problem with it, the limit of requests / second. Even tho I increase the request to 10000MS or more, i keep getting the "Too many requests" error.

Could be there a possibility where Vmix makes more requests than needed, spamming the API limits?

reference: https://developers.google.com/sheets/api/limits

UserPostedImage

The logs say that VMIX keeps the requests at the maximum, even adjusting the request delays.


waldron18  
#5 Posted : Thursday, July 20, 2017 11:44:03 PM(UTC)
waldron18

Rank: Advanced Member

Groups: Registered
Joined: 7/23/2015(UTC)
Posts: 75
Location: Australia

Thanks: 3 times
Was thanked: 1 time(s) in 1 post(s)
Yeah I was trying to use a Google sheet as datasource/scoreboard and it kept saying "too many requests". Which made it pretty annoying as you really need fast updating for scoring.

I had to revert back to a local excel file but that meant I couldn't get someone remotely to update it for me.

Anyone got a workaround for the Google API Too Many Requests issue?

N
321actionvideo  
#6 Posted : Wednesday, October 25, 2017 2:09:17 PM(UTC)
321actionvideo

Rank: Advanced Member

Groups: Registered
Joined: 11/17/2015(UTC)
Posts: 34

Was thanked: 2 time(s) in 2 post(s)
I had a show this weekend that I used google sheets on another computer to post results as my main computer was already handling 3 cameras and many ads, so I didnt want to use it for anything else but vmix as I am on the lower end of the recommended setup for this. So what I had to do was when I was posting results, I set the google sheets to refresh rate to 5000 (5 sec) and when I was not updating, I would just add zeros on end to 50000 or more. I really wish vmix had a way to make a shortcut to adjust the refresh rate by assigning a shortcut, as I would just have to hit the button when I want it to update, and another when I dont. That way I could have control on the fly.
gujingc  
#7 Posted : Sunday, June 27, 2021 10:39:36 AM(UTC)
gujingc

Rank: Member

Groups: Registered
Joined: 2/4/2021(UTC)
Posts: 12
Man
United States
Location: Porter Ranch

I got the exact same error and found a solution.

The problem with with the Google API http reference.

So choose none for the reference, or vmix.* as the permitted http, like this.
UserPostedImage

It works for me.
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.