testing meltano against google sheets. getting CRI...
# troubleshooting
e
testing meltano against google sheets. getting CRITICAL HTTP-error-code: 400 invalid_grant: Bad Request. any way I can get the error body as it should contain a description? can't see it with debug level on
v
Assuming they are using the requests library I wanted something like this back then (there may be much easier ways) https://meltano.slack.com/archives/C01PKLU5D1R/p1614795211012800
e
Thanks
Messing around with oauth was a giant waste of time. Not sure why the taps doesn't use service accounts instead
v
Google doesn't recommend service accounts in a lot of scenarios, not so bad once you get the handoff process but I understand the first time doing it is a big pain
e
Yea, but they expire, so that means you need another support system for Meltano
v
refresh tokens do not
They can in certain situations, but they are pretty rare
e
Somewhat reluctant to start fighting with the google oauth for another hour 😂
Wasn't aware that the refresh tokens will keep going
v
Not trying to fight 😄 I've just done it for years 🤷
e
Sure beats having to upload the same mp4 file to 8 different data access capabilities only to have it rejected
at facebook
v
haha I've never dealt with that sounds horrible
e
all good times
v
hahaha, I don't know about facebook but anytime I've had to figure one of those out you can normal document the "secret words / phrases" you have to use to get through the support contract person on FB's end or wherever
Always horrible the first time, so silly they put up walls anyways 🤷