vMix Forums
»
General
»
General Discussion
»
Help! Bad Request (400) on Google Sheets Data Source
Rank: Advanced Member
Groups: Registered
Joined: 7/23/2013(UTC) Posts: 122  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?
|
|
|
|
|
|
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?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 7/23/2013(UTC) Posts: 122 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
|
|
|
|
|
|
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.htmlhttp://www.vmix.com/help19/GoogleAPIKey.htmlBut 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 The logs say that VMIX keeps the requests at the maximum, even adjusting the request delays.
|
|
|
|
|
|
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
|
|
|
|
|
|
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.
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 2/4/2021(UTC) Posts: 23   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.  It works for me.
|
|
|
|
|
|
vMix Forums
»
General
»
General Discussion
»
Help! Bad Request (400) on Google Sheets Data Source
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.
Important Information:
The vMix Forums uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close
