.github/9
ISSUE_TEMPLATE/3bug_report.md config.yml feature_request.md
workflows/3ci.yml clean-clone.yml release.yml
CODEOWNERS dependabot.yml pull_request_template.md
apps/630
api/250
src/243
common/30
__tests__/3authorize.test.ts bigint-serialization.interceptor.test.ts files-limits.test.ts
filters/1all-exceptions.filter.ts
guards/3auth.guard.ts internal-service.guard.ts rate-limit.guard.ts
interceptors/2actor-context.interceptor.ts bigint-serialization.interceptor.ts
middleware/2idempotency.test.ts idempotency.ts
pipes/1zod-validation.pipe.ts
actor-context.ts audit.service.ts cache.test.ts cache.ts cookies.ts core.module.ts deprecation.ts email.service.ts errors.ts event-bus.ts log-scrubber.test.ts log-scrubber.ts logger.ts permission-cache-bridge.ts prisma.service.ts redis.service.ts trace-metadata.ts types.ts
config/1env.ts
lib/11
__tests__/5crypto.test.ts filter-builder.test.ts jwt.test.ts pagination.test.ts positions.test.ts
authorize.ts crypto.ts filter-builder.ts jwt.ts pagination.ts positions.ts
modules/197
ai/28
__tests__/4ai-writing.test.ts database-ai.test.ts generate-executor.test.ts prompts.test.ts
generator/4executor.ts generate.controller.ts generate.dto.ts generate.service.ts
ai-chat.service.ts ai-rate-limit.ts ai-writing.controller.ts ai-writing.dto.ts ai-writing.service.ts ai.controller.ts ai.module.ts ai.service.ts budget-guard.service.ts database-ai.controller.ts database-ai.dto.ts database-ai.service.ts db-prompts.ts dto.ts gateway-provider.ts ledger.service.ts prompts.ts rag.controller.ts rag.dto.ts rag.service.ts
api-keys/3api-keys.controller.ts api-keys.module.ts api-keys.service.ts
audit/2audit-log.controller.ts audit.module.ts
auth/4auth.controller.ts auth.module.ts auth.service.ts dto.ts
automations/5automations.controller.ts automations.module.ts automations.service.ts dto.ts webhook-incoming.controller.ts
blocks/5
__tests__/1batch-version-cas.test.ts
block.service.ts blocks.controller.ts blocks.module.ts dto.ts
comments/4comments.controller.ts comments.module.ts comments.service.ts dto.ts
databases/9
__tests__/3normalize-select-options.test.ts option-id-canonicalization.test.ts record-open-query-shape.test.ts
database.service.ts databases.controller.ts databases.module.ts dto.ts property-cache-schema.ts query.service.ts
docs/2docs.controller.ts docs.module.ts
files/10
__tests__/1quota.test.ts
dto.ts files.controller.ts files.module.ts files.service.ts quota.ts record.ts s3.ts uploads.controller.ts uploads.service.ts
forms/18debug.controller.ts form.dto.ts forms.controller.ts forms.module.ts forms.service.ts markdown.test.ts markdown.ts optional-auth.guard.ts public-forms.controller.ts public-forms.service.ts question.dto.ts questions.service.ts rate-limit.ts recaptcha.ts slug.ts submissions.controller.ts submissions.service.ts submit-schema.ts
health/3health.controller.ts health.module.ts health.service.ts
integrations/3integrations.controller.ts integrations.module.ts integrations.service.ts
internal/12
__tests__/2flush-query-shape.test.ts internal.endpoints.test.ts
ai-test-seam.controller.ts ai-test-seam.dto.ts ai-test-seam.service.ts internal.controller.ts internal.dto.ts internal.module.ts internal.service.ts test-seam.controller.ts test-seam.dto.ts test-seam.service.ts
notifications/3notifications.controller.ts notifications.module.ts notifications.service.ts
oauth/6
__tests__/1oauth.scopes.test.ts
oauth.controller.ts oauth.module.ts oauth.service.ts scopes.ts token-keys.ts
org/15audit.service.ts embed-preview.controller.ts guards.ts members.service.ts org-admin.controller.ts org-policy.service.ts org.module.ts overview.service.ts policy-effective.controller.ts policy.schema.ts policy.test.ts retention.service.ts totp.test.ts totp.ts two-factor.service.ts
orgs/5dto.ts orgs.controller.ts orgs.module.ts orgs.service.ts util.ts
pages/4dto.ts page.service.ts pages.controller.ts pages.module.ts
scim/15
__tests__/3email-mapping.test.ts etag.test.ts filters.test.ts
etag.ts filters.ts groups.service.ts schemas.ts scim-admin.controller.ts scim-admin.service.ts scim-auth.guard.ts scim-auth.service.ts scim-errors.ts scim.controller.ts scim.module.ts users.service.ts
search/4
__tests__/1search.service.test.ts
search.controller.ts search.module.ts search.service.ts
sessions/3sessions.controller.ts sessions.module.ts sessions.service.ts
share/3share.controller.ts share.module.ts share.service.ts
sso/16
__tests__/4enforcement.test.ts oidc.verify.test.ts provisioning.test.ts saml.validate.test.ts
enforcement.ts oidc.controller.ts oidc.service.ts oidc.ts provisioning.service.ts saml.controller.ts saml.ts schemas.ts sso-admin.controller.ts sso-admin.service.ts sso-secrets.ts sso.module.ts
teams/4dto.ts teams.controller.ts teams.module.ts teams.service.ts
users/4dto.ts users.controller.ts users.module.ts users.service.ts
webhooks/3webhooks.controller.ts webhooks.module.ts webhooks.service.ts
workspaces/4dto.ts workspaces.controller.ts workspaces.module.ts workspaces.service.ts
types/1xmldom.d.ts
app.module.ts constants.ts main.ts
_probe_rawbody.cjs .env.example Dockerfile package.json README.md tsconfig.json vitest.config.ts
realtime/33
src/17auth.ts comments.ts config.ts event-source.ts http-store.ts index.ts metrics.ts notifications.ts page-updated-source.ts presence.ts prisma-store.ts protocol.ts rate-limit.ts room-key.ts rooms.ts server.ts update-log.ts
test/11auth.test.ts config.test.ts event-source.test.ts http-store.test.ts metrics-merge.test.ts page-updated-source.test.ts presence.test.ts protocol.test.ts rate-limit.test.ts rooms.test.ts task-0094-builders.test.ts
.env.example Dockerfile package.json README.md tsconfig.json
web/255
src/244
app/45
__tests__/1theme-tokens.test.ts
(app)/26
w/25
[workspace]/25
ask/1page.tsx
databases/1
[id]/1page.tsx
favorites/1page.tsx
files/1page.tsx
notifications/1page.tsx
page/4
[id]/4
[block]/1page.tsx
share/1page.tsx
layout.tsx page.tsx
search/1page.tsx
settings/10
appearance/1page.tsx
automations/3
[id]/1page.tsx
new/1page.tsx
page.tsx
billing/1page.tsx
developers/1page.tsx
members/1page.tsx
permissions/1page.tsx
teams/1page.tsx
page.tsx
shared/1page.tsx
templates/1page.tsx
trash/1page.tsx
layout.tsx page.tsx
layout.tsx
(auth)/4
login/1page.tsx
register/1page.tsx
reset-password/1page.tsx
layout.tsx
api/2
metrics/1route.ts
v1/1
health/1route.ts
f/1
[slug]/1page.tsx
health/1
ready/1route.ts
org/2
[orgId]/2
admin/2
integrations/1page.tsx
page.tsx
share/1
[id]/1page.tsx
error.tsx global-error.tsx globals.css layout.tsx not-found.tsx page.tsx providers.tsx
components/118
admin/10
org-admin/8ApiKeysTab.tsx AuditTab.tsx MembersTab.tsx OverviewTab.tsx PoliciesTab.tsx RetentionTab.tsx WebhooksTab.tsx WorkspacePicker.tsx
ScimCard.tsx SsoTabs.tsx
ai/6ai-panel.tsx ask-ai-submenu.tsx db-ai-dialog.tsx generate-page-dialog.tsx writing-actions-menu.tsx writing-diff.tsx
automations/5action-editor.tsx condition-editor.tsx lib.ts run-history.tsx trigger-editor.tsx
collaboration/6CursorLayer.tsx OfflineBanner.tsx PresenceBar.tsx README.md ReviewFailedDialog.tsx StatusChip.tsx
comments/3comment-panel.tsx comment-thread.tsx mention-input.tsx
database/27
__tests__/2cell-editor.test.tsx cell-renderer.test.tsx
AiExtractDialog.tsx AiFormulaDialog.tsx AiGenerateDialog.tsx board-view.tsx buttons-panel.tsx calendar-view.tsx cell-editor.tsx cell-renderer.tsx chart-view.tsx database-page-view.tsx database-toolbar.tsx database-view-renderer.tsx db-embedded.tsx filter-builder.tsx form-builder-view.tsx formula-editor.tsx gallery-view.tsx group-builder.tsx list-view.tsx property-editor.tsx record-header.tsx record-panel.tsx sort-builder.tsx table-view.tsx timeline-view.tsx
dialogs/7
__tests__/1move-to-dialog.test.tsx
create-dialog.tsx dialog.tsx file-permissions-dialog.tsx invite-dialog.tsx move-to-dialog.tsx share-dialog.tsx
editor/19
__tests__/3code-block-text.test.ts code-block.test.tsx expandable.test.tsx
block-card.tsx block-renderer.tsx block-save-queue.ts block-toolbar.tsx context-menu.tsx expandable.tsx history-popover.tsx inline-editor.tsx insert-dialog.tsx page-canvas.tsx page-spinner.tsx page-view.tsx selection-toolbar.tsx slash-menu.tsx template-dialog.tsx type-menu.tsx
files/4FileBlock.tsx FileBrowser.tsx FilePicker.tsx PreviewModal.tsx
form/4form-field.tsx form-renderer.tsx form-responses-view.tsx form-view.tsx
layout/8
__tests__/1page-tree-icon.test.tsx
command-palette.tsx factory-logo.tsx page-tree-node.tsx sidebar.tsx theme-provider.tsx topbar.tsx workspace-shell.tsx
mentions/3
__tests__/1mention-model.test.ts
mention-model.ts MentionPopup.tsx
search/3ask-ai-search.tsx results-list.tsx search-dialog.tsx
settings/10
api-keys/4ApiKeyCreateDialog.tsx ApiKeyRevealDialog.tsx ApiKeyTable.tsx ScopesBadge.tsx
webhooks/5CurlExamples.tsx DeliveryInspector.tsx EventExplorer.tsx OverviewTab.tsx WebhooksTab.tsx
settings-shell.tsx
ui/3confirm-dialog.tsx form.tsx toaster.tsx
hooks/21
__tests__/4realtime-frame-handler.test.ts use-blocks.test.ts use-database-options.test.ts use-workspace.test.tsx
realtime-frame-handler.ts use-ai-stream.ts use-auth.ts use-blocks.ts use-database.ts use-db-ai-stream.ts use-forms.ts use-members.ts use-mention-sources.ts use-notifications.ts use-offline-status.ts use-pages.ts use-presence-announcer.ts use-presence-toasts.ts use-presence.ts use-realtime.ts use-workspace.ts
lib/50
__tests__/21ai-database.test.ts ai-generate.test.ts ai-sse.test.ts ai-writing.test.ts api-keys.test.ts api-members.test.ts auth-refresh.test.ts auth-store.test.ts batch-queue-drop.test.ts block-content.test.ts clipboard-import.test.ts code-highlight.test.ts offline-status.test.ts presence-announcer.test.ts presence-color.test.ts presence-cursor.test.ts presence-emitter.test.ts realtime-url.test.ts search.test.ts utils.test.ts writing-diff.test.ts
files/7
__tests__/2picker.test.ts upload.test.ts
api.ts picker.ts upload-store.ts upload.ts use-file-uploads.ts
ai-database.ts ai.ts api-keys.ts api.ts auth-store.ts batch-queue.ts block-content.ts clipboard-import.ts code-highlight.ts constants.ts offline-status.ts org-admin.ts presence-announcer.ts presence-color.ts presence-cursor.ts presence-editor-views.ts presence-emitter.ts query-client.ts realtime.ts search.ts types.ts utils.ts
stores/8
__tests__/1block-patch-store.test.ts
block-patch-store.ts comment-pill-store.ts database-store.ts editor-store.ts offlineQueue.ts presence-store.ts ui-store.ts
instrumentation.ts middleware.ts
.env.example Dockerfile next-env.d.ts next.config.mjs package.json postcss.config.mjs README.md tailwind.config.ts tsconfig.json tsconfig.tsbuildinfo vitest.config.ts
worker/92
src/87
__tests__/13ai-embedding.test.ts ai-request.test.ts ai-usage-budget.test.ts audit-export.test.ts email-decision.test.ts encrypt.test.ts health-search-index-lag.test.ts mime.test.ts retention.test.ts s3-sign.test.ts search-index.test.ts smtp.test.ts webhook-sign.test.ts
health/1server.ts
lib/12
__tests__/1clamav.test.ts
clamav.ts encrypt.ts job-otel.ts mime.ts notify.ts prisma.ts redis-stream.ts redis.ts s3.ts sharp.ts smtp.ts
processors/56
automations/28
__tests__/3condition-evaluator.spec.ts executors.spec.ts run-pipeline.spec.ts
executors/17assign-user.ts call-integration.ts change-status.ts classify.ts create-notification.ts create-page.ts email-cap.ts helpers.ts integration-registry.ts permission.ts record-write.ts registry.ts run-ai-action.ts send-email.ts send-webhook.ts types.ts update-record.ts
condition-evaluator.ts dead-letter.ts log.ts matcher.ts pipeline.ts run-state.ts schedule.ts watchdog.ts
files/15
__tests__/4errors.test.ts scan-gate.test.ts status.test.ts temp.test.ts
steps/4finalize.ts metadata.ts scan.ts thumbnails.ts
cleanup.ts errors.ts generateThumbs.ts processor.ts status.ts temp.ts types.ts
search-index/4builders.ts grants.ts index.ts processor.ts
ai-embedding.ts ai.processor.ts audit-export.ts automations.processor.ts email-decision.processor.ts email.processor.ts maintenance.processor.ts retention.ts webhooks.processor.ts
config.ts events.ts index.ts logger.ts queues.ts
.env.example Dockerfile package.json README.md tsconfig.json
docs/73
api/17ai.md authentication.md automations.md blocks.md comments.md databases.md files.md forms.md openapi.yaml org-admin.md pages.md scim.md search.md sso.md versioning.md webhooks.md workspaces.md
architecture/10ai-architecture.md automation.md backend-architecture.md database-architecture.md frontend-architecture.md realtime-architecture.md search-architecture.md security-architecture.md storage.md system-architecture.md
database/2database-architecture.md redis-keys.md
development/8admin-guide.md coding-standards.md deployment.md development-guide.md files-pipeline.md perf-report.md performance.md testing.md
product/4functional-requirements.md non-functional-requirements.md product-requirements.md ux-requirements.md
requirements/1requirements-matrix.md
security/5audit-report.md files.md forms.md license-allowlist.md security-architecture.md
tasks/16phase-00-foundation.md phase-01-authentication.md phase-02-workspace.md phase-03-pages.md phase-04-editor.md phase-05-databases.md phase-06-relations.md phase-07-collaboration.md phase-08-search.md phase-09-files.md phase-10-forms.md phase-11-automation.md phase-12-ai.md phase-13-api.md phase-14-enterprise.md phase-15-production.md
ui/9ai.md automations.md design-system.md developers.md files.md forms.md org-admin.md scim.md sso.md
support-matrix.md
infrastructure/71
caddy/1Caddyfile
docker/6
init/101-extensions.sql
opensearch/1init-indices.json
.env.docker docker-compose.yml opensearch-init.sh README.md
kubernetes/40
observability/20
alertmanager/1alertmanager.yaml
grafana/8
dashboards/6ai.json api-overview.json infra.json realtime.json search.json workers-queues.json
provisioning/2
dashboards/1dashboards.yaml
datasources/1datasource.yaml
prometheus/3alerts.yaml recording-rules.yaml scrape.yaml
scripts/1sync-sources.mjs
alertmanager.yaml grafana.yaml kustomization.yaml namespace.yaml node-exporter.yaml otel-collector.yaml prometheus.yaml
postgres/7configmap.yaml cronjob-backup.yaml cronjob-opensearch-snapshot.yaml pgbouncer.yaml replica.yaml statefulset.yaml walg-iam-policy.yaml
api.yaml configmap.yaml ingress.yaml kustomization.yaml namespace.yaml networkpolicy.yaml pdb.yaml README.md realtime.yaml redis.yaml secret.example.yaml web.yaml worker.yaml
nginx/2nginx.conf README.md
observability/14
alertmanager/1alertmanager.yaml
grafana/8
dashboards/6ai.json api-overview.json infra.json realtime.json search.json workers-queues.json
provisioning/2
dashboards/1dashboards.yaml
datasources/1datasource.yaml
prometheus/3alerts.yaml recording-rules.yaml scrape.yaml
scripts/1dashboard-completeness.mjs
README.md
terraform/8compute.tf data.tf main.tf network.tf outputs.tf README.md security.tf variables.tf
packages/289
ai/24
src/20
providers/7anthropic.ts google.ts http.ts index.ts openai-compatible.ts rag.test.ts writing.test.ts
schemas/2database.ts generate.ts
adapters.test.ts config.test.ts config.ts gateway.test.ts gateway.ts index.ts tools.test.ts tools.ts types.ts usage.test.ts usage.ts
package.json README.md tsconfig.json vitest.config.ts
auth/11
src/7index.ts passwords.test.ts passwords.ts sessions.test.ts sessions.ts tokens.test.ts tokens.ts
package.json README.md tsconfig.json vitest.config.ts
collaboration/17
src/13awareness.ts codec.test.ts codec.ts index.ts lww.test.ts lww.ts mapping.ts offline.ts outbox.test.ts outbox.ts provider.test.ts provider.ts types.ts
package.json README.md tsconfig.json vitest.config.ts
config/7
src/4eslint.base.js index.ts prettier.base.json tsconfig.base.json
package.json README.md tsconfig.json
database-client/5
src/2index.test.ts index.ts
package.json README.md tsconfig.json
database-engine/33
src/29
filter/2filter.test.ts index.ts
formula/8evaluator.ts formula.test.ts functions.ts index.ts lexer.ts parser.ts types.ts validate.ts
query/6group.ts index.ts paginate.ts pivot.ts query.test.ts sort.ts
relations/2index.ts relations.test.ts
rollups/2index.ts rollups.test.ts
values/5dates.ts index.ts registry.ts types.ts values.test.ts
views/3buttons.ts index.ts views.test.ts
index.ts
package.json README.md tsconfig.json vitest.config.ts
editor/25
src/21
marks/1highlight.ts
nodes/2equation.ts mention.ts
autosave.test.ts autosave.ts clipboard.test.ts clipboard.ts codec.test.ts codec.ts context-menu.test.ts context-menu.ts diff.test.ts diff.ts factory.ts history.test.ts history.ts index.ts positions.ts slash.test.ts slash.ts types.ts
package.json README.md tsconfig.json vitest.config.ts
observability/20
src/16
__tests__/8db-redis-metrics.test.ts metrics.test.ts otel.test.ts pino-otel.test.ts prometheus.test.ts resource.test.ts scrubber.test.ts traceparent.test.ts
index.ts metrics.ts otel.ts pino-otel.ts prometheus.ts resource.ts scrubber.ts traceparent.ts
package.json README.md tsconfig.json vitest.config.ts
permissions/11
src/7index.ts levels.test.ts levels.ts resolve.test.ts resolve.ts rules.test.ts rules.ts
package.json README.md tsconfig.json vitest.config.ts
search/22
src/18chunking.test.ts chunking.ts client.test.ts client.ts embeddings.test.ts embeddings.ts hybrid.test.ts hybrid.ts index.ts indexer.test.ts indexer.ts mapping.test.ts mapping.ts queries.test.ts queries.ts rrf.test.ts rrf.ts types.ts
package.json README.md tsconfig.json vitest.config.ts
shared/61
src/57
dto/17ai.dto.ts auth.dto.test.ts auth.dto.ts block.dto.ts browser-safety.test.ts comment.dto.ts database.dto.test.ts database.dto.ts file.dto.ts formula-ast.ts index.ts notification.dto.ts page.dto.ts search.dto.ts share.dto.ts webhook.dto.ts workspace.dto.ts
events/8audit-catalog.test.ts audit-catalog.ts audit-csv.test.ts audit-csv.ts audit-scope.test.ts audit-scope.ts catalog.test.ts catalog.ts
realtime/6comment-events.ts frames.test.ts frames.ts notification-policy.ts notification-prefs.ts task-0094.test.ts
automation.test.ts automation.ts constants.ts crypto.test.ts crypto.ts env.ts errors.ts events.test.ts events.ts forms.test.ts forms.ts index.ts markdown.test.ts markdown.ts mentions.test.ts mentions.ts net.test.ts net.ts positions.test.ts positions.ts presence.test.ts presence.ts security-headers.ts webhook-delivery.test.ts webhook-delivery.ts webhook-events.ts
package.json README.md tsconfig.json vitest.config.ts
storage/16
src/12client.test.ts client.ts index.ts keys.test.ts keys.ts mime.test.ts mime.ts presign.test.ts presign.ts thumbnails.test.ts thumbnails.ts types.ts
package.json README.md tsconfig.json vitest.config.ts
ui/37
src/33
components/19avatar.tsx badge.tsx button.tsx checkbox.tsx command.tsx context-menu.tsx dialog.tsx dropdown-menu.tsx empty-state.tsx index.ts popover.tsx separator.tsx skeleton.tsx slider.tsx spinner.tsx switch.tsx tabs.tsx toast.tsx tooltip.tsx
color.ts command-filter.test.ts command-filter.ts focus.test.ts focus.ts formatters.test.ts formatters.ts index.ts theme.test.ts theme.ts toast-store.test.ts toast-store.ts tokens.test.ts tokens.ts
package.json README.md tsconfig.json vitest.config.ts
prisma/16
migrations/13
20260927000000_init/1migration.sql
20260928000000_search_documents_content_hash/1migration.sql
20260929000000_workspace_usage_storage_bytes/1migration.sql
20260930000000_form_submitted_notification_type/1migration.sql
20261001000000_ai_phase12/1migration.sql
20261002000000_webhooks_secret_encrypted_dlq/1migration.sql
20261002111436_webhook_delivery_latency/1migration.sql
20261002120000_org_admin_2fa_retention_unique/1migration.sql
20261002215124_audit_export/1migration.sql
20261003210000_perf_indexes_hot_paths/1migration.sql
20261004004500_perf_indexes_hot_paths_2/1migration.sql
migration_lock.toml README.md
schema.prisma seed.ts verify.ts
scripts/7backup-health.ts docs-completeness.mjs generate-openapi.mjs minio-init.ts opensearch-reindex.ts storage-orphans.ts verify-clean-clone.sh
tests/169
e2e/63
.auth/1user.json
fixtures/7
files/6clip.mp4 clip.wav clip.webm hero-1400.png note.docx note.txt
realtime.ts
mocks/2oidc-issuer.ts saml-idp.ts
playwright-report/3
data/2a6557bae9c2714a658968d4eb8534195c08ebda8.png e3092d07d00a16063e46385c02a559a9054fa847.webm
index.html
reports/1files-security.json
specs/34ai-database.spec.ts ai-generate.spec.ts ai-rag.spec.ts ai-security.spec.ts ai-writing.spec.ts ai.spec.ts api-keys.spec.ts appearance-theme.spec.ts auth.spec.ts automation.spec.ts collab-two-tab.spec.ts comments.spec.ts databases.spec.ts default-workspace-alias.spec.ts developers.spec.ts editor.spec.ts files.spec.ts final-flow.spec.ts forms.spec.ts oauth.spec.ts org-admin.spec.ts pages.spec.ts performance.spec.ts presence-cursors.spec.ts qa-paste-toggle.spec.ts realtime.spec.ts scim.spec.ts search-index-lag.spec.ts search.spec.ts sharing.spec.ts sso.spec.ts task-0094-comments-notifications.spec.ts webhooks.spec.ts workspace.spec.ts
test-results-final-flow/3
final-flow-Release-v1-0-fi-6c06b-w-state-carries-sequential--chromium-desktop/2test-failed-1.png trace.zip
.last-run.json
utils/4api.ts dnd.ts search-lag.ts wait.ts
.gitignore fixtures.ts global-setup.ts package.json playwright.config.ts playwright.final-flow.config.ts README.md tsconfig.json
fixtures/1
files/1make-sparse.ts
integration/60
ai-capability/2ai-app.capability.test.ts gateway.capability.test.ts
drill/2seed-drill.mjs verify-restore.mjs
fixtures/5
files/5clip.mp4 clip.wav doc.pdf hero-1400.png note.txt
helpers/3api.ts containers.ts seed.ts
realtime/11control-channel.test.ts convergence.test.ts flush-rebase-http.test.ts handshake.test.ts heartbeat-limits.test.ts lifecycle.test.ts presence.test.ts rebase.test.ts resume.test.ts rt-helpers.ts task-0094-fanout.test.ts
ai-chat.integration.test.ts ai-database.integration.test.ts ai-generate.integration.test.ts ai-rag.integration.test.ts ai-writing.integration.test.ts api-keys.integration.test.ts audit-completeness.integration.test.ts audit-export-s3.integration.test.ts auth.integration.test.ts automation-pipeline.integration.test.ts automations.integration.test.ts blocks.integration.test.ts cache-invalidation.integration.test.ts comments.integration.test.ts databases.integration.test.ts files-lifecycle.integration.test.ts files-pipeline.integration.test.ts files-security.integration.test.ts files.integration.test.ts forms-responses.integration.test.ts forms.integration.test.ts oauth.integration.test.ts openapi.contract.test.ts org-admin.integration.test.ts package.json pages.integration.test.ts permissions.integration.test.ts README.md replica-routing.integration.test.ts retention-engine.integration.test.ts scim.integration.test.ts search.integration.test.ts sso.integration.test.ts tsconfig.json vitest.config.ts webhooks.integration.test.ts workspace.integration.test.ts
performance/28
fixtures/1search-100k.ts
helpers/2seed-100k.mjs seed-1k-load.mjs
reports/7api-load-smoke.json database-load-smoke.json editor-local.json realtime-load.json search-full.json search-last.json search-reduced.json
api-load.js api.js archive.tar database-load.js database.js editor-local.mjs extract-100k-env.mjs package.json README.md realtime-1k.js realtime-load.js realtime.js run-realtime-load.sh search-search.k6.js search-summary.json seed-100k.mjs threshold-breach-demo.js verify-zero-op-loss.mjs
security/16
helpers/1app.ts
audit-report.test.ts auth-paths.test.ts deps.test.ts formula-fuzz.test.ts gitleaks-config.test.ts headers.test.ts images.test.ts oracle.ts package.json permission-fuzz.test.ts rate-limits.test.ts README.md tsconfig.json upload-abuse.test.ts vitest.config.ts
README.md
.dockerignore .env .env.bak-task0125 .env.example .eslintrc.json .gitignore .npmrc .prettierignore .prettierrc.json AGENTS.md ARCHITECTURE.md CHANGELOG.md CONTRIBUTING.md gitleaks.toml LICENSE package.json pnpm-lock.yaml pnpm-workspace.yaml PRODUCT-SPEC.md README.md ROADMAP.md SECURITY.md tsconfig.json turbo.json
webhooks.service.tsapps/api/src/modules/webhooks/webhooks.service.tsraw← webhooks24,346 B← Back to the app
1/**
2 * Webhooks (TASK-0130): workspace-level event subscriptions, production-grade.
3 *
4 * Contract: docs/api/webhooks.md (the published spec) + the task requirements.
5 *   - CRUD with catalog validation (unknown event → 400 listing the catalog),
6 *     SSRF-guarded delivery URLs (private/link-local/loopback rejected;
7 *     `WEBHOOK_ALLOW_PRIVATE=true` dev override), 20-per-workspace cap (409).
8 *   - Secret storage: `secretEncrypted` (AES-256-GCM, shared envelope) is the
9 *     source of truth for NEW rows; `secretHash` = sha256hex(secret)
10 *     bookkeeping. The worker's `resolveSigningSecret` keeps Phase-11 legacy
11 *     rows (ciphertext-in-secretHash / bare hash) working (C-13.8a).
12 *   - The raw secret is returned EXACTLY ONCE (create + rotate). List/get
13 *     expose only `secretPrefix`.
14 *   - Test send: SYNCHRONOUS dispatch through the shared delivery core
15 *     (docs §2 — the test delivery does not enter the retry queue).
16 *   - Deliveries: list (filters status/event/since/until, newest first, no
17 *     payload) + single (full payload) + per-delivery retry (doc §6) +
18 *     resubmit (task: new rows linked by originDeliveryId, attempts reset).
19 *   - DELETE is a soft delete (active=false; the row + delivery log are kept).
20 *
21 * Dispatch + retries + DLQ live in the worker (`webhooks.processor.ts`); the
22 * delivery contract itself is the single shared implementation
23 * (`@factory/shared` `webhook-delivery.ts`).
24 */
25import { Inject, Injectable } from "@nestjs/common";
26import { Queue } from "bullmq";
27import { jobTraceMetadata } from "../../common/trace-metadata.js";
28import { PrismaService } from "../../common/prisma.service.js";
29import { AuditService } from "../../common/audit.service.js";
30import { RedisService } from "../../common/redis.service.js";
31import { ApiError } from "../../common/errors.js";
32import {
33  aes256gcmEncrypt,
34  sha256hex
35} from "../../lib/crypto.js";
36import { assertRole } from "../../lib/authorize.js";
37import { loadEnv } from "../../config/env.js";
38import { parsePagination } from "../../lib/pagination.js";
39import {
40  assertSafeDeliveryUrl,
41  buildDeliveryEnvelope,
42  classifyDeliveryResult,
43  generateId,
44  generateWebhookSecret,
45  newDeliveryId,
46  postWebhookDelivery,
47  resolveSigningSecret,
48  validateWebhookEvents,
49  WEBHOOK_EVENT_NAMES
50} from "@factory/shared";
51 
52/** Max webhooks per workspace (docs §1.1: 409 beyond 20). */
53const MAX_WEBHOOKS_PER_WORKSPACE = 20;
54/** The test-send payload is fixed (docs §2 — a synthetic webhook.test). */
55const TEST_SEND_MESSAGE = "This is a test delivery from the Factory developer hub.";
56 
57function secretPrefix(secretHash: string): string {
58  // Bookkeeping-only identifier: the first 4 hash chars, whsec_-styled.
59  // (The raw secret's own prefix is never derivable from the hash; this is
60  // the doc §1.3 `secretPrefix` field and leaks nothing about the secret.)
61  return `whsec_${secretHash.slice(0, 4)}`;
62}
63 
64@Injectable()
65export class WebhooksService {
66  constructor(
67    @Inject(PrismaService) private readonly prisma: PrismaService,
68    @Inject(AuditService) private readonly audit: AuditService,
69    @Inject(RedisService) private readonly redis: RedisService
70  ) {}
71 
72  private masterKey(): string {
73    const key = loadEnv().MASTER_ENCRYPTION_KEY;
74    if (!key) {
75      throw new ApiError(
76        "INTERNAL_ERROR",
77        500,
78        "MASTER_ENCRYPTION_KEY is not configured — webhook secrets cannot be stored."
79      );
80    }
81    return key;
82  }
83 
84  private allowPrivate(): boolean {
85    return loadEnv().WEBHOOK_ALLOW_PRIVATE === "true";
86  }
87 
88  private async requireAdmin(workspaceId: string, userId: string) {
89    await assertRole(this.prisma, { workspaceId, userId }, ["OWNER", "ADMIN"]);
90  }
91 
92  /** URL validation per docs §1.1: http(s), SSRF-guarded. */
93  private async validateUrl(url: string): Promise<string> {
94    let u: URL;
95    try {
96      u = new URL(url);
97    } catch {
98      throw ApiError.validation("Webhook URL must be a valid absolute URL.", [
99        { field: "url", issue: "invalid_url" }
100      ]);
101    }
102    if (u.protocol !== "https:" && u.protocol !== "http:") {
103      throw ApiError.validation("Webhook URL must be http(s).", [
104        { field: "url", issue: "invalid_scheme", received: u.protocol }
105      ]);
106    }
107    if (u.search) {
108      throw ApiError.validation("Webhook URL must not contain a query string.", [
109        { field: "url", issue: "query_string_not_allowed" }
110      ]);
111    }
112    try {
113      await assertSafeDeliveryUrl(u.toString(), this.allowPrivate());
114    } catch (err) {
115      // Name check (not instanceof): the API (CJS) and shared (ESM) may load
116      // different class instances of the same package.
117      if (err instanceof Error && err.name === "SsrfError") {
118        throw ApiError.validation("Webhook URL targets a private address.", [
119          { field: "url", issue: "private_address_not_allowed" }
120        ]);
121      }
122      throw err;
123    }
124    return u.toString();
125  }
126 
127  /** Events must be catalog names (or `*`); unknown → 400 listing the catalog. */
128  private validateEvents(events: string[]): string[] {
129    const { valid, unknown } = validateWebhookEvents(events);
130    if (!valid) {
131      throw ApiError.validation("Unknown webhook event name.", [
132        {
133          field: "events",
134          issue: "unknown_event",
135          received: unknown,
136          validEvents: WEBHOOK_EVENT_NAMES
137        }
138      ]);
139    }
140    return events;
141  }
142 
143  async create(
144    workspaceId: string,
145    userId: string,
146    input: { url: string; events?: string[]; secret?: string; active?: boolean },
147    req: any
148  ) {
149    await this.requireAdmin(workspaceId, userId);
150    const url = await this.validateUrl(input.url);
151    const events = this.validateEvents(input.events ?? ["*"]);
152 
153    const count = await this.prisma.webhook.count({ where: { workspaceId } });
154    if (count >= MAX_WEBHOOKS_PER_WORKSPACE) {
155      throw ApiError.conflict("Workspace webhook limit reached (20).", [
156        { field: "url", issue: "webhook_limit", max: MAX_WEBHOOKS_PER_WORKSPACE }
157      ]);
158    }
159 
160    const secret = input.secret ?? generateWebhookSecret();
161    const webhook = await this.prisma.webhook.create({
162      data: {
163        workspaceId,
164        url,
165        secretHash: sha256hex(secret),
166        secretEncrypted: Buffer.from(aes256gcmEncrypt(secret, this.masterKey()), "base64"),
167        events,
168        active: input.active ?? true,
169        createdById: userId
170      }
171    });
172    await this.audit.audit(req, req?.auth, {
173      action: "webhook.created",
174      resourceType: "webhook",
175      resourceId: webhook.id,
176      workspaceId,
177      metadata: { url, events }
178    });
179    return {
180      ...this.shape(webhook),
181      secret, // shown ONCE — never retrievable again
182      warning: "Store this secret now — it cannot be retrieved again."
183    };
184  }
185 
186  async list(workspaceId: string, userId: string, query: { cursor?: string; limit?: string }) {
187    await this.requireAdmin(workspaceId, userId);
188    const { limit } = parsePagination(query);
189    const webhooks = await this.prisma.webhook.findMany({
190      where: { workspaceId },
191      orderBy: { createdAt: "asc" },
192      take: limit
193    });
194    return { data: webhooks.map((w) => this.shape(w)) };
195  }
196 
197  async get(workspaceId: string, webhookId: string, userId: string) {
198    await this.requireAdmin(workspaceId, userId);
199    const webhook = await this.prisma.webhook.findFirst({ where: { id: webhookId, workspaceId } });
200    if (!webhook) throw ApiError.notFound("Webhook not found.");
201    const recent = await this.prisma.webhookDelivery.groupBy({
202      by: ["status"],
203      where: { webhookId },
204      _count: { _all: true }
205    });
206    const last = await this.prisma.webhookDelivery.findFirst({
207      where: { webhookId, status: "DELIVERED" },
208      orderBy: { deliveredAt: "desc" },
209      select: { deliveredAt: true }
210    });
211    const total = recent.reduce((n, r) => n + (r._count._all ?? 0), 0);
212    const failed =
213      (recent.find((r) => r.status === "FAILED")?._count._all ?? 0) +
214      (recent.find((r) => r.status === "DEAD_LETTER")?._count._all ?? 0) +
215      (recent.find((r) => r.status === "REJECTED")?._count._all ?? 0);
216    return {
217      ...this.shape(webhook),
218      recentDeliveries: {
219        total,
220        failed,
221        lastDeliveredAt: last?.deliveredAt ?? null
222      }
223    };
224  }
225 
226  /** Merge-patch url / events / active (docs §1.4). */
227  async update(
228    workspaceId: string,
229    webhookId: string,
230    userId: string,
231    patch: { url?: string; events?: string[]; active?: boolean },
232    req: any
233  ) {
234    await this.requireAdmin(workspaceId, userId);
235    const webhook = await this.prisma.webhook.findFirst({ where: { id: webhookId, workspaceId } });
236    if (!webhook) throw ApiError.notFound("Webhook not found.");
237    const data: Record<string, unknown> = {};
238    if (patch.url) data.url = await this.validateUrl(patch.url);
239    if (patch.events) data.events = this.validateEvents(patch.events);
240    if (patch.active !== undefined) data.active = patch.active;
241    const updated = await this.prisma.webhook.update({ where: { id: webhookId }, data });
242    await this.audit.audit(req, req?.auth, {
243      action: "webhook.updated",
244      resourceType: "webhook",
245      resourceId: webhookId,
246      workspaceId,
247      metadata: { fields: Object.keys(patch) }
248    });
249    return this.shape(updated);
250  }
251 
252  /** Rotate the signing secret (docs §1.4 `rotateSecret`) — new secret shown once. */
253  async rotateSecret(workspaceId: string, webhookId: string, userId: string, req: any) {
254    await this.requireAdmin(workspaceId, userId);
255    const webhook = await this.prisma.webhook.findFirst({ where: { id: webhookId, workspaceId } });
256    if (!webhook) throw ApiError.notFound("Webhook not found.");
257    const secret = generateWebhookSecret();
258    const updated = await this.prisma.webhook.update({
259      where: { id: webhookId },
260      data: {
261        secretHash: sha256hex(secret),
262        secretEncrypted: Buffer.from(aes256gcmEncrypt(secret, this.masterKey()), "base64")
263      }
264    });
265    await this.audit.audit(req, req?.auth, {
266      action: "webhook.secret_rotated",
267      resourceType: "webhook",
268      resourceId: webhookId,
269      workspaceId
270      // The raw secret is NEVER audited (task Security section).
271    });
272    return {
273      ...this.shape(updated),
274      secret,
275      warning: "Store this secret now — it cannot be retrieved again. In-flight deliveries signed with the old secret will fail verification."
276    };
277  }
278 
279  /** Soft delete (docs §1.5): deliveries stop; the row + log are kept. */
280  async remove(workspaceId: string, webhookId: string, userId: string, req: any) {
281    await this.requireAdmin(workspaceId, userId);
282    const webhook = await this.prisma.webhook.findFirst({ where: { id: webhookId, workspaceId } });
283    if (!webhook) throw ApiError.notFound("Webhook not found.");
284    await this.prisma.webhook.update({ where: { id: webhookId }, data: { active: false } });
285    // TASK-0133 audit catalog: the soft-delete is `webhook.revoked` (the
286    // catalog's name for "a webhook was revoked/disabled"), with the
287    // CATALOG-required `url` (the delivery target).
288    await this.audit.audit(req, req?.auth, {
289      action: "webhook.revoked",
290      resourceType: "webhook",
291      resourceId: webhookId,
292      workspaceId,
293      metadata: { url: webhook.url }
294    });
295    return { deleted: true };
296  }
297 
298  /**
299   * Test send (docs §2): SYNCHRONOUS delivery of a fixed webhook.test
300   * payload through the shared transport. Does NOT enter the retry queue —
301   * the result (delivered/rejected/failed) is recorded on the delivery row
302   * and returned to the caller.
303   */
304  async test(workspaceId: string, webhookId: string, userId: string, req: any) {
305    await this.requireAdmin(workspaceId, userId);
306    const webhook = await this.prisma.webhook.findFirst({ where: { id: webhookId, workspaceId } });
307    if (!webhook) throw ApiError.notFound("Webhook not found.");
308    const ws = await this.prisma.workspace.findUnique({
309      where: { id: webhook.workspaceId },
310      select: { id: true, name: true, slug: true }
311    });
312    const eventId = generateId("evt");
313    const envelope = buildDeliveryEnvelope({
314      id: eventId,
315      type: "webhook.test",
316      workspaceId: webhook.workspaceId,
317      workspace: ws ?? undefined,
318      data: { message: TEST_SEND_MESSAGE, sentAt: new Date().toISOString() },
319      test: true
320    });
321    const deliveryId = newDeliveryId();
322    await this.prisma.webhookDelivery.create({
323      data: {
324        id: deliveryId,
325        webhookId,
326        event: "webhook.test",
327        payload: envelope as object,
328        status: "PENDING",
329        attempts: 1
330      }
331    });
332    const resolved = this.resolveSecretOrThrow(webhook);
333    const result = await postWebhookDelivery(
334      {
335        url: webhook.url,
336        secret: resolved,
337        event: "webhook.test",
338        envelope,
339        deliveryId,
340        attempt: 1
341      },
342      { allowPrivate: this.allowPrivate() }
343    );
344    const outcome = classifyDeliveryResult(result);
345    await this.prisma.webhookDelivery.update({
346      where: { id: deliveryId },
347      data: {
348        status: outcome,
349        statusCode: result.status || null,
350        error:
351          outcome === "DELIVERED"
352            ? null
353            : result.transportError ?? `non-2xx: HTTP ${result.status}`,
354        deliveredAt: outcome === "DELIVERED" ? new Date() : null,
355        latencyMs: result.latencyMs
356      }
357    });
358    await this.audit.audit(req, req?.auth, {
359      action: "webhook.test_sent",
360      resourceType: "webhook",
361      resourceId: webhookId,
362      workspaceId,
363      metadata: { deliveryId, outcome, statusCode: result.status || null }
364    });
365    return {
366      deliveryId,
367      status: outcome,
368      statusCode: result.status || null,
369      attempts: 1,
370      latencyMs: result.latencyMs
371    };
372  }
373 
374  /** Delivery log (docs §6): newest first, filters, no payload in the list. */
375  async deliveries(
376    workspaceId: string,
377    webhookId: string,
378    userId: string,
379    query: {
380      cursor?: string;
381      limit?: string;
382      status?: string;
383      event?: string;
384      since?: string;
385      until?: string;
386    }
387  ) {
388    await this.requireAdmin(workspaceId, userId);
389    const webhook = await this.prisma.webhook.findFirst({ where: { id: webhookId, workspaceId } });
390    if (!webhook) throw ApiError.notFound("Webhook not found.");
391    const { cursor, limit } = parsePagination(query);
392    const since = query.since ? new Date(query.since) : undefined;
393    const until = query.until ? new Date(query.until) : undefined;
394    const rows = await this.prisma.webhookDelivery.findMany({
395      where: {
396        webhookId,
397        ...(query.status ? { status: query.status as never } : {}),
398        ...(query.event ? { event: query.event } : {}),
399        ...(since || until
400          ? {
401              createdAt: {
402                ...(since ? { gte: since } : {}),
403                ...(until ? { lte: until } : {})
404              }
405            }
406          : {})
407      },
408      ...(cursor ? { cursor: { id: cursor.id }, skip: 1 } : {}),
409      orderBy: { createdAt: "desc" },
410      take: limit + 1
411    });
412    const page = rows.slice(0, limit);
413    const next = rows.length > limit ? page[page.length - 1] : undefined;
414    return {
415      data: page.map((d) => this.shapeDelivery(d)),
416      nextCursor: next ? Buffer.from(JSON.stringify({ id: next.id })).toString("base64url") : null
417    };
418  }
419 
420  /** Single delivery INCLUDING the full payload (docs §6 drawer). */
421  async delivery(workspaceId: string, webhookId: string, deliveryId: string, userId: string) {
422    await this.requireAdmin(workspaceId, userId);
423    const webhook = await this.prisma.webhook.findFirst({ where: { id: webhookId, workspaceId } });
424    if (!webhook) throw ApiError.notFound("Webhook not found.");
425    const d = await this.prisma.webhookDelivery.findFirst({
426      where: { id: deliveryId, webhookId }
427    });
428    if (!d) throw ApiError.notFound("Delivery not found.");
429    return {
430      ...this.shapeDelivery(d),
431      payload: d.payload
432    };
433  }
434 
435  /**
436   * Per-delivery manual retry (docs §6): FAILED/REJECTED → PENDING, attempt
437   * counter reset, original payload re-signed with the CURRENT secret.
438   * 409 when the delivery already succeeded.
439   */
440  async retryDelivery(
441    workspaceId: string,
442    webhookId: string,
443    deliveryId: string,
444    userId: string,
445    req: any
446  ) {
447    await this.requireAdmin(workspaceId, userId);
448    const webhook = await this.prisma.webhook.findFirst({ where: { id: webhookId, workspaceId } });
449    if (!webhook) throw ApiError.notFound("Webhook not found.");
450    const d = await this.prisma.webhookDelivery.findFirst({ where: { id: deliveryId, webhookId } });
451    if (!d) throw ApiError.notFound("Delivery not found.");
452    if (d.status === "DELIVERED") {
453      throw ApiError.conflict("Delivery already succeeded — nothing to retry.", [
454        { field: "deliveryId", issue: "already_delivered" }
455      ]);
456    }
457    const envelope = d.payload as Record<string, unknown>;
458    await this.prisma.webhookDelivery.update({
459      where: { id: deliveryId },
460      data: { status: "PENDING", attempts: 0, error: null, nextRetryAt: null }
461    });
462    await this.enqueueDeliveryJob(webhook, d, envelope, 1);
463    await this.audit.audit(req, req?.auth, {
464      action: "webhook.delivery_retried",
465      resourceType: "webhook",
466      resourceId: webhookId,
467      workspaceId,
468      metadata: { deliveryId }
469    });
470    return { deliveryId, status: "PENDING", attempts: 0 };
471  }
472 
473  /**
474   * Resubmit (task AC): re-queue FAILED / DEAD_LETTER / REJECTED deliveries
475   * as NEW rows linked by `originDeliveryId` (the originals stay put for
476   * the log), attempts reset. `scope: "all_dead"` = DEAD_LETTER (the AC
477   * wording); "all_failed" adds FAILED; "all" adds REJECTED.
478   */
479  /**
480   * Resubmit (task L349 body): `{ deliveryId? }` (one specific row),
481   * `{ all_dead: true }` (every DEAD_LETTER row — the AC wording), or
482   * `{ window: { since, until } }` (failed/DLQ rows in a time window).
483   * Each becomes a NEW row linked by `originDeliveryId`, attempt counter
484   * reset (the originals stay put for the log).
485   */
486  async resubmit(
487    workspaceId: string,
488    webhookId: string,
489    userId: string,
490    input: {
491      deliveryId?: string;
492      all_dead?: boolean;
493      window?: { since?: string; until?: string };
494    },
495    req: any
496  ): Promise<{ resubmitted: number; deliveryIds: string[]; originDeliveryIds: string[] }> {
497    await this.requireAdmin(workspaceId, userId);
498    const webhook = await this.prisma.webhook.findFirst({ where: { id: webhookId, workspaceId } });
499    if (!webhook) throw ApiError.notFound("Webhook not found.");
500    const where: Record<string, unknown> = { webhookId };
501    if (input.deliveryId) {
502      const d = await this.prisma.webhookDelivery.findFirst({
503        where: { id: input.deliveryId, webhookId }
504      });
505      if (!d) throw ApiError.notFound("Delivery not found.");
506      if (d.status === "DELIVERED" || d.status === "PENDING") {
507        throw ApiError.conflict("Only FAILED, REJECTED or DEAD_LETTER deliveries can be resubmitted.", [
508          { field: "deliveryId", issue: "not_retriable", status: d.status }
509        ]);
510      }
511      where.id = input.deliveryId;
512    } else if (input.window?.since || input.window?.until) {
513      where.status = { in: ["DEAD_LETTER", "FAILED", "REJECTED"] as const };
514      where.createdAt = {
515        ...(input.window.since ? { gte: new Date(input.window.since) } : {}),
516        ...(input.window.until ? { lte: new Date(input.window.until) } : {})
517      };
518    } else {
519      // default (the AC "resubmit all_dead")
520      where.status = "DEAD_LETTER";
521    }
522    const rows = await this.prisma.webhookDelivery.findMany({
523      where,
524      orderBy: { createdAt: "desc" },
525      take: 200 // bound: resubmit is a manual operation, not a sweep
526    });
527    const deliveryIds: string[] = [];
528    const originDeliveryIds: string[] = [];
529    for (const d of rows) {
530      const envelope = d.payload as Record<string, unknown>;
531      const newId = newDeliveryId();
532      await this.prisma.webhookDelivery.create({
533        data: {
534          id: newId,
535          webhookId,
536          event: d.event,
537          payload: d.payload as object,
538          status: "PENDING",
539          attempts: 0,
540          originDeliveryId: d.id
541        }
542      });
543      await this.enqueueDeliveryJob(webhook, d, envelope, 1, newId);
544      deliveryIds.push(newId);
545      originDeliveryIds.push(d.id);
546    }
547    await this.audit.audit(req, req?.auth, {
548      action: "webhook.deliveries_resubmitted",
549      resourceType: "webhook",
550      resourceId: webhookId,
551      workspaceId,
552      metadata: { mode: input.deliveryId ? "single" : input.window ? "window" : "all_dead", count: deliveryIds.length }
553    });
554    return { resubmitted: deliveryIds.length, deliveryIds, originDeliveryIds };
555  }
556 
557  // ---------------------------------------------------------------- helpers
558 
559  private resolveSecretOrThrow(webhook: {
560    secretEncrypted: Uint8Array | null;
561    secretHash: string;
562  }): string {
563    const resolved = resolveSigningSecret(
564      this.masterKey(),
565      webhook.secretEncrypted,
566      webhook.secretHash
567    );
568    if (!resolved) {
569      throw new ApiError(
570        "INTERNAL_ERROR",
571        500,
572        "Webhook signing secret is unrecoverable — recreate the webhook."
573      );
574    }
575    return resolved.secret;
576  }
577 
578  /** Enqueue a row dispatch job on the worker's `webhooks` queue. */
579  private async enqueueDeliveryJob(
580    webhook: { id: string; workspaceId: string },
581    delivery: { id: string; event: string },
582    envelope: Record<string, unknown>,
583    attempt: number,
584    deliveryId?: string
585  ): Promise<void> {
586    const targetId = deliveryId ?? delivery.id;
587    const eventId = typeof envelope.id === "string" ? envelope.id : generateId("evt");
588    const occurredAt = typeof envelope.occurredAt === "string" ? envelope.occurredAt : undefined;
589    try {
590      const q = new Queue("webhooks", { connection: this.redis.getRedis().options as never });
591      try {
592        await q.add("webhooks", {
593          kind: "row",
594          webhookId: webhook.id,
595          event: delivery.event,
596          payload: envelope.data ?? {},
597          deliveryId: targetId,
598          eventId,
599          ...(occurredAt ? { occurredAt } : {}),
600          attempt
601        },
602        // TASK-0135: continue the enqueueing request's trace into the job.
603        { ...jobTraceMetadata() }
604        );
605      } finally {
606        await q.close();
607      }
608    } catch (err) {
609      // Leave the row PENDING; the worker's watchdog/final-failure hook
610      // dead-letters orphans (same degrade as the automation runs).
611      console.warn(`webhook delivery ${targetId} enqueue failed: ${(err as Error).message}`);
612    }
613  }
614 
615  private shape(webhook: {
616    id: string;
617    url: string;
618    events: string[];
619    active: boolean;
620    createdById: string;
621    workspaceId: string;
622    createdAt: Date;
623    updatedAt: Date;
624    secretHash: string;
625  }) {
626    return {
627      id: webhook.id,
628      workspaceId: webhook.workspaceId,
629      url: webhook.url,
630      events: webhook.events,
631      active: webhook.active,
632      secretPrefix: secretPrefix(webhook.secretHash),
633      createdById: webhook.createdById,
634      createdAt: webhook.createdAt,
635      updatedAt: webhook.updatedAt
636    };
637  }
638 
639  private shapeDelivery(d: {
640    id: string;
641    webhookId: string;
642    event: string;
643    status: string;
644    attempts: number;
645    statusCode: number | null;
646    error: string | null;
647    deliveredAt: Date | null;
648    nextRetryAt: Date | null;
649    createdAt: Date;
650    originDeliveryId: string | null;
651    latencyMs?: number | null;
652    payload?: unknown;
653  }) {
654    const env = (d.payload ?? {}) as Record<string, unknown>;
655    return {
656      id: d.id,
657      webhookId: d.webhookId,
658      event: d.event,
659      eventId: typeof env.id === "string" ? env.id : undefined,
660      status: d.status,
661      attempts: d.attempts,
662      statusCode: d.statusCode,
663      error: d.error,
664      deliveredAt: d.deliveredAt,
665      nextRetryAt: d.nextRetryAt,
666      createdAt: d.createdAt,
667      originDeliveryId: d.originDeliveryId,
668      latencyMs: d.latencyMs ?? null
669    };
670  }
671}
672