On this page
Connections, shared credentials, uploads, mapping templates, backfill, validation and organization datasets.
connectors#
Source: apps/web/src/server/routers/connectors.ts
| Procedure | Type | Access | Description |
|---|---|---|---|
connectors. |
query | brandProcedure, manage_ |
Reads are gated the same as writes: connector config/health (which platforms are wired, sync state, settlement/live rollups) is org-admin material. |
connectors. |
query | brandProcedure, manage_ |
Connector presentation/demo posture for this org. |
connectors. |
query | brandProcedure |
Cosmetic topology metadata: which analytics surface the 2nd right-side output slot in the connector topology diagram represents. |
connectors. |
mutation | rateLimited |
Super-admin toggle for connector presentation mode. |
connectors. |
query | brandProcedure |
Connector-type gating for the "add connection" picker. |
connectors. |
query | brandProcedure, manage_ |
— |
connectors. |
mutation | authed, manage_ |
Test credentials before the connector is saved (create-wizard gate). |
connectors. |
mutation | authed, manage_ |
Build the seller-consent (OAuth) URL for the "Authorize" button. |
connectors. |
query | brandProcedure, manage_ |
How orders were ingested: live API sync vs CSV/XLSX upload. |
connectors. |
query | brandProcedure, manage_ |
— |
connectors. |
query | brandProcedure, manage_ |
live-session performance rollup (live-room GMV + session count). |
connectors. |
query | brandProcedure, manage_ |
Finance/settlement rollup — net payout vs revenue vs fees per platform. |
connectors. |
mutation | rateLimited, manage_ |
— |
connectors. |
mutation | rateLimited, manage_ |
— |
connectors. |
mutation | rateLimited, manage_ |
— |
connectors. |
mutation | rateLimited, manage_ |
— |
connectors. |
mutation | authed, manage_ |
— |
connectors. |
mutation | authed, manage_ |
— |
connectors. |
mutation | rateLimited, manage_ |
— |
connectors. |
query | brandProcedure, manage_ |
— |
connectors. |
query | brandProcedure, manage_ |
— |
connectors. |
query | authed, manage_ |
— |
connectors. |
query | authed, manage_ |
— |
connectors. |
mutation | brandProcedure, manage_ |
— |
connectors. |
query | brandProcedure, manage_ |
The org's active packs and the tabs each binds — what the bind-all button on a dataset org's Google Sheets connector lists. |
connectors. |
mutation | authed, manage_ |
— |
connectors. |
query | brandProcedure, manage_ |
— |
connectors. |
mutation | rateLimited, manage_ |
— |
connectors. |
query | brandProcedure, manage_ |
— |
connectors. |
mutation | rateLimited, manage_ |
Operator-facing manual sync (incremental or explicit ICT date-range backfill). |
orgCredentials#
Source: apps/web/src/server/routers/org-credentials.ts
| Procedure | Type | Access | Description |
|---|---|---|---|
orgCredentials. |
query | brandProcedure, manage_ |
List saved identities with the number of connectors linked to each. |
orgCredentials. |
mutation | rateLimited, manage_ |
— |
orgCredentials. |
mutation | rateLimited, manage_ |
— |
orgCredentials. |
mutation | rateLimited, manage_ |
— |
orgCredentials. |
mutation | rateLimited, manage_ |
Re-encrypt a new payload onto the same row — every linked connector picks it up on next decrypt. |
orgCredentials. |
mutation | rateLimited, manage_ |
Blocked while any connector references the identity. |
connectorBackfill#
Source: apps/web/src/server/routers/connector-backfill.ts
| Procedure | Type | Access | Description |
|---|---|---|---|
connector |
mutation | rateLimited, manage_ |
— |
connector |
query | orgProcedure, manage_ |
A connector's most recent runs (newest first, capped at 50). |
connector |
query | orgProcedure, manage_ |
A single run (for polling one run's live progress). |
connector |
mutation | rateLimited, manage_ |
Cooperative cancel — flips cancel_; the worker skips the remaining slices. |
pipeline#
Source: apps/web/src/server/routers/pipeline.ts
| Procedure | Type | Access | Description |
|---|---|---|---|
pipeline. |
query | authed |
High-level topology + counts per stage. |
pipeline. |
query | authed |
Connector-level health: watermark, last sync, throughput since. |
pipeline. |
query | brandProcedure |
Hourly activity by stream for the last N hours — for a small sparkline grid. |
pipeline. |
query | brandProcedure |
Recent sync runs — the ticker for the pipeline page. |
pipeline. |
query | brandProcedure, owner or admin |
Dead-letter queue page. |
pipeline. |
mutation | rateLimited, manage_ |
— |
manualUploads#
Source: apps/web/src/server/routers/manual-uploads.ts
| Procedure | Type | Access | Description |
|---|---|---|---|
manual |
query | brandProcedure |
Schema metadata for every upload type — required and optional column aliases, plus a hint. |
manual |
query | brandProcedure |
Returns a starter CSV containing just the header row + an empty placeholder, so users can fill it in their spreadsheet and re-upload. |
manual |
query | brandProcedure |
— |
manual |
query | brandProcedure |
— |
manual |
query | brandProcedure |
The receipt of one content_mention upload (funnel, retired rows, pending tags, deck refresh state). |
manual |
mutation | rateLimited, owner or admin |
An admin re-runs a content upload's deck refresh once the cause it stopped on is fixed (label-quality recorded, admin now acting). |
manual |
query | brandProcedure, manage_ |
Re-download the exact bytes an operator uploaded, when still in the system. |
manual |
mutation | rateLimited, manage_ |
— |
manual |
mutation | rateLimited, manage_ |
Wave 3 — templated upload. |
validation#
Source: apps/web/src/server/routers/validation.ts
| Procedure | Type | Access | Description |
|---|---|---|---|
validation. |
query | brandProcedure |
Dataset catalog + per-dataset availability: |
validation. |
mutation | rateLimited, manage_ |
Peek an uploaded file without creating a run: |
validation. |
mutation | rateLimited, manage_ |
— |
validation. |
query | brandProcedure |
— |
validation. |
query | brandProcedure |
— |
validation. |
query | brandProcedure |
— |
validation. |
mutation | rateLimited, manage_ |
Delete a run + all associated diffs. |
validation. |
query | brandProcedure |
— |
categories#
Source: apps/web/src/server/routers/categories.ts
| Procedure | Type | Access | Description |
|---|---|---|---|
categories. |
query | orgProcedure, owner or admin |
Canonical categories + their platform mappings + SKU rules, assembled without N+1 (parents limited, children fetched via inArray). |
categories. |
query | orgProcedure |
— |
categories. |
mutation | rateLimited, owner or admin |
— |
categories. |
mutation | rateLimited, owner or admin |
— |
categories. |
mutation | rateLimited, owner or admin |
— |
categories. |
mutation | rateLimited, owner or admin |
— |
categories. |
mutation | rateLimited, owner or admin |
— |
categories. |
mutation | rateLimited, owner or admin |
— |
categories. |
mutation | rateLimited, owner or admin |
— |
categories. |
mutation | rateLimited, owner or admin |
— |
shopAliases#
Source: apps/web/src/server/routers/shop-aliases.ts
| Procedure | Type | Access | Description |
|---|---|---|---|
shopAliases. |
query | orgProcedure |
— |
shopAliases. |
query | orgProcedure, owner or admin |
— |
shopAliases. |
query | orgProcedure, owner or admin |
— |
shopAliases. |
mutation | rateLimited, owner or admin |
— |
shopAliases. |
mutation | rateLimited, owner or admin |
— |
importTemplates#
Source: apps/web/src/server/routers/import-templates.ts
Mapping templates router.
| Procedure | Type | Access | Description |
|---|---|---|---|
import |
query | brandProcedure |
List all templates the user can see. |
import |
query | brandProcedure |
Catalog of canonical streams + their target fields. |
import |
mutation | rateLimited, manage_ |
Install every mapping template this org can be given without authoring one — one affordance, two derivations: |
import |
mutation | rateLimited, manage_ |
— |
import |
mutation | rateLimited, manage_ |
— |
import |
mutation | rateLimited |
— |
import |
mutation | rateLimited |
Header sniff — accepts a sample upload, returns the parsed header columns so the wizard can render the source-side dropdowns. |
import |
query | brandProcedure |
Stats: how many staging rows queued / promoted / rejected per template. |
import |
mutation | rateLimited |
— |
import |
query | brandProcedure |
Generate the customer's file template: |
orgDatasets#
Source: apps/web/src/server/routers/org-datasets.ts
| Procedure | Type | Access | Description |
|---|---|---|---|
orgDatasets. |
query | rateLimited, view_ |
Every dataset (any brand, any status) the active org owns — org-wide admin surface, mirrors content_' own list shape. |
orgDatasets. |
query | rateLimited, view_ |
One dataset + its full field catalog (every status, the UI renders suggested differently from active, never conflating the two). |
orgDatasets. |
query | rateLimited |
— |
orgDatasets. |
query | rateLimited |
— |
orgDatasets. |
mutation | rateLimited, owner or admin |
— |
orgDatasets. |
mutation | rateLimited, owner or admin |
— |
orgDatasets. |
mutation | rateLimited, owner or admin |
— |
orgDatasets. |
query | rateLimited, view_ |
Every link the active org owns (any status, the admin surface tells active from archived apart, never conflating the two). |
orgDatasets. |
mutation | rateLimited, owner or admin |
— |
orgDatasets. |
mutation | rateLimited, owner or admin |
Archive one link — the worker's executor skips a non-active link entirely (runDataset's own WHERE status = 'active'); |
orgDatasets. |
query | authed, view_ |
The form model of an editable settings card, plus whether the caller may edit it. |
orgDatasets. |
mutation | rateLimited, view_ |
Save the caller's own override: one row for this person, never the shared settings. |
orgDatasets. |
mutation | rateLimited, view_ |
Drop the caller's own override: back to the shared settings. |
orgDatasets. |
mutation | rateLimited |
Save the whole form as manual settings rows (written by the worker). |
orgDatasets. |
mutation | rateLimited |
Drop every manual settings row: back to the uploaded file's settings. |