App Connections

Encrypted credential records (OAuth2 tokens, API keys, basic/custom auth, OIDC props) that flow steps use to call external services. Support automatic OAuth2 refresh with distributed locking, a project-or-platform scope model, and a project-scoped "replace" that rewires flow references from one connection to another.

Entity

AppConnection: id, displayName, externalId (stable ref in flow settings, survives rename), type, status (ACTIVE/EXPIRED/ERROR), value (encrypted AES-256), platformId, pieceName/Version, projectIds[], scope (PROJECT/PLATFORM), preSelectForNewProjects.

Connection types (8)

OAUTH2, CLOUD_OAUTH2 (exchanged via secrets.activepieces.com), PLATFORM_OAUTH2 (platform-managed OAuth app), SECRET_TEXT, BASIC_AUTH, CUSTOM_AUTH (opt-in refresh callback), NO_AUTH, OIDC.

How it works

• OAuth2 auto-refresh on retrieval: lockAndRefreshConnection() refreshes 15 min early; acquires Redis lock keyed ${platformId}_${externalId} (60s) so projects sharing a connection serialize; re-encrypts tokens; sets status ERROR on invalid refresh. API responses always strip refresh_token + client_secret.
• Custom-auth refresh: piece defines a refresh.generate callback; token_refresh_at = now + expiresIn - min(15min, expiresIn/2); dispatched via EXECUTE_TOKEN_REFRESH worker job. Support cached in pieceRefreshSupportCache (LRU 500, 5-min TTL). Timeout keeps old creds (no ERROR); engine error → ERROR.
• OIDC: AP acts as an OIDC identity provider so pieces get short-lived cloud creds (e.g. AWS AssumeRoleWithWebIdentity). Engine calls POST /api/v1/worker/oidc-token with {audience, expiresInSeconds?} → RS256 JWT sub: platform:{id}:project:{id}, TTL default/cap 1h. Public discovery: /.well-known/openid-configuration + /jwks.json; kid is an RFC 7638 SHA-256 thumbprint. Signing key auto-generated + persisted (encrypted) to the shared flag table with first-writer-wins (INSERT ... ON CONFLICT DO NOTHING), no env var needed.

Endpoints

POST /v1/app-connections (upsert, validates via worker EXECUTE_VALIDATION), POST /:id (update meta), GET (filters), GET /owners, POST /replace, DELETE /:id, POST /oauth2/authorization-url (optional scope subset).

Gotchas

• Deleting a PLATFORM-scope connection via the project route is rejected 403 — delete those via platform admin DELETE /v1/global-connections/:id.
• Replace: platform/global connections can be the source, but deleteSourceConnection on a platform source → 403; deleting a project source while a published version still references it → 409. Draft versions always updated; published only when requested.
• Deleting a connection does NOT cascade to flows; they fail at runtime with a validation error.
• Global (platform-scope) connections require globalConnectionsEnabled; bulk-delete in the project UI skips them client-side.
• metadata.accountIdentifier (the "which account is this" label) must be rewritten on every upsert, never left untouched — spreadIfDefined omits the column and TypeORM upsert(connection, ['id']) then leaves the old value in place, so a reconnect that fails to resolve would keep labelling the connection with an account it no longer authenticates as. mergeConnectionMetadata also strips the key from caller-supplied metadata, because metadata is a caller-owned jsonb bag: without that, any WRITE_APP_CONNECTION holder can forge the label. Note POST /:id (update) still replaces the whole bag.

Key files

Entry point: appConnectionService, exported from the app-connection service and reached through appConnectionModule, registered in packages/server/api/src/app/app.ts.

• packages/server/api/src/app/app-connection/ — backend module: controllers (project, platform, worker), entity, module wiring, and the app-connection-service/ folder holding the service, handler, and OAuth2 handlers
• packages/server/api/src/app/core/security/oidc/ — OIDC provider: key manager, token controller, discovery controller, module
• packages/core/shared/src/lib/automation/app-connection/ — shared types, enums, value unions, and the upsert/read DTOs under dto/
• packages/web/src/features/connections/ — frontend slice: api/ clients, hooks/ TanStack Query hooks, components/ global and rename dialogs, utils/ OAuth2 redirect and name-uniqueness helpers
• packages/web/src/app/connections/ — connection dialogs and per-auth-type form settings (new, create/edit, replace, reconnect, OIDC, OAuth2, custom, basic, secret text)
• packages/web/src/app/routes/connections/ — project connections list page
• packages/web/src/app/routes/platform/setup/connections/ — platform-wide global connections page

Paths verified 2026-07-17.