WindmillWWindmill
Powered by
whollacsekW
Windmill•3y ago•
13 replies
whollacsek

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?
WindmillJoin
3,362Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements
Recent Announcements
henri-c

Weekly kenote to tell you about our latest updates https://discord.com/channels/930051556043276338/1278977038430240813 https://youtube.com/live/2dGd9TdT8xs?feature=share

henri-c · 4d ago

Pyra

### HTTP tracing (EE) Capture HTTP requests made by job scripts as observability spans Features: - View HTTP request traces (method, URL, status, timing) in the job details UI - Auto-instrumentation for Native TypeScript, MITM proxy for other languages - Integrates with external OpenTelemetry collectors changelog: https://www.windmill.dev/changelog/http-tracing docs: https://www.windmill.dev/docs/advanced/instance_settings#http-tracing Additionally jobs memory metrics are now fully OSS!

Pyra · 2w ago

henri-c

First keynote of the year here https://discord.com/channels/930051556043276338/1278977038430240813 🙂

henri-c · 4w ago

Similar Threads

Gsheets & Python
Chris @ Konnect3dCChris @ Konnect3d / help
2y ago
Configuring docker daemon used by windmill
floodyFfloody / help
3y ago
Which deno version is used by worker ?
ym1198Yym1198 / help
2y ago
Setting up oauth resources for gdrive/gsheets on self-hosted
OmenOOmen / help
3y ago