whollacsek
whollacsek12mo ago

Gsheets token not refreshed when used by other users

I've created a flow that uses gsheets integration, however when the flow is run by another user this error is thrown:
AxiosError: Google API error - [401] Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.
Error:
at new AxiosError (/tmp/windmill/cache/bun/axios@1.6.5/lib/core/AxiosError.js:21:4)
at settle (/tmp/windmill/cache/bun/axios@1.6.5/lib/core/settle.js:2:0)
at handleStreamEnd (/tmp/windmill/cache/bun/axios@1.6.5/lib/adapters/http.js:589:9)
at endReadableNT (native)
at processTicksAndRejections (native)
AxiosError: Google API error - [401] Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.
Error:
at new AxiosError (/tmp/windmill/cache/bun/axios@1.6.5/lib/core/AxiosError.js:21:4)
at settle (/tmp/windmill/cache/bun/axios@1.6.5/lib/core/settle.js:2:0)
at handleStreamEnd (/tmp/windmill/cache/bun/axios@1.6.5/lib/adapters/http.js:589:9)
at endReadableNT (native)
at processTicksAndRejections (native)
When this happens I need to manually run the flow myself for it to work, afterwards for a period of time the other users can run the flow as well until the error appear again. The flow and all resources are in a folder that has the group 'all' assigned. I can't find anything in the documentation or online talking about managing token refresh. Can anyone help me with this?
11 Replies
Alper
Alper12mo ago
the google suite has rate limits, could that be related?
rubenf
rubenf12mo ago
@whollacsek it's in all but do they have write permission on it?
whollacsek
whollacsekOP12mo ago
They should be in all by default no? I've put them in the folder's permission too
whollacsek
whollacsekOP12mo ago
this is the folder permissions
No description
whollacsek
whollacsekOP12mo ago
this is the resource permissions
No description
rubenf
rubenf12mo ago
I see, so that can't be the issue
whollacsek
whollacsekOP12mo ago
Yes since they can run the flow successfully It's just that the token refresh logic seems not to be run when it's another user
rubenf
rubenf12mo ago
I know what the issue is
rubenf
rubenf12mo ago
you can follow this issue ^
whollacsek
whollacsekOP12mo ago
Thanks!