logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
Google Sheets data source 400 bad request error
Options
Go to last post Go to first unread
Previous Topic Next Topic
ElBurrito  
#1 Posted : Thursday, September 16, 2021 12:11:03 AM(UTC)
ElBurrito

Rank: Member

Groups: Registered
Joined: 11/13/2017(UTC)
Posts: 27

Thanks: 3 times
I'm following these instructions to add Google Sheets as a source for a data source: https://www.vmix.com/kno...s-with-vmix-data-sources

I do that, and when I try to add it in vMix I get a 400 bad request error so it won't connect to Google Sheets. I've tried doing this over starting from scratch and got the same error. Can anyone help with what I'm doing wrong?
Back to top

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
cchhita  
#2 Posted : Friday, September 17, 2021 9:49:16 AM(UTC)
cchhita

Rank: Member

Groups: Registered
Joined: 4/14/2020(UTC)
Posts: 17
United States
Location: Dallas, TX

Thanks: 5 times
I have been using Google Sheets for a very long time, and this has just started happening to me yesterday. I am not sure what the issue is, but changing to a different Google Sheet and API key renders the same result.
Back to top
justpushplay  
#3 Posted : Friday, January 28, 2022 5:24:28 PM(UTC)
justpushplay

Rank: Newbie

Groups: Registered
Joined: 8/15/2018(UTC)
Posts: 7
Location: Finland

Was thanked: 1 time(s) in 1 post(s)
Is Google Sheets integration broken because I keep getting the same error message (400 bad request) no matter what I do? I have followed all the setup instructions and created a few new API keys but I can't seem to get it to work.
Back to top
MattGrover  
#4 Posted : Friday, March 11, 2022 7:12:37 AM(UTC)
MattGrover

Rank: Member

Groups: Registered
Joined: 7/20/2020(UTC)
Posts: 14
Man
United Kingdom
Location: Henfield
Just having this issue as well...
Back to top
WWW BLOG
MattGrover  
#5 Posted : Thursday, March 17, 2022 5:35:59 PM(UTC)
MattGrover

Rank: Member

Groups: Registered
Joined: 7/20/2020(UTC)
Posts: 14
Man
United Kingdom
Location: Henfield
I've just been trying to sort mine again as another one I made worked.

It could be to do with the Table name.

The default "Sheet1" "Sheet2" seems to work fine, when I rename them to "day1" "day2" I get the (400) error.
(now I've got a (429) Too Many Requests, but that's clearly something else)
Back to top
WWW BLOG
Peter1000  
#6 Posted : Thursday, March 17, 2022 5:55:36 PM(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)
unpaid Google API allows requests only every 8-9 seconds (try) you have to put that value (8000) in the lower right field of your datasorce settings
Back to top
Users browsing this topic
Guest (3)
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.143 seconds.