Skip to content
MSO CloudDocumentation

Data sources and datasets

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.list query brandProcedure, manage_connectors Reads are gated the same as writes: connector config/health (which platforms are wired, sync state, settlement/live rollups) is org-admin material.
connectors.demoMode query brandProcedure, manage_connectors Connector presentation/demo posture for this org.
connectors.topologyProfile query brandProcedure Cosmetic topology metadata: which analytics surface the 2nd right-side output slot in the connector topology diagram represents.
connectors.setDemoMode mutation rateLimitedBrandProcedure Super-admin toggle for connector presentation mode.
connectors.enabledTypes query brandProcedure Connector-type gating for the "add connection" picker.
connectors.oauthCallbackUrls query brandProcedure, manage_connectors —
connectors.testDraft mutation authedProcedure, manage_connectors Test credentials before the connector is saved (create-wizard gate).
connectors.authorizeUrl mutation authedProcedure, manage_connectors Build the seller-consent (OAuth) URL for the "Authorize" button.
connectors.ingestSourceSummary query brandProcedure, manage_connectors How orders were ingested: live API sync vs CSV/XLSX upload.
connectors.fileSources query brandProcedure, manage_connectors —
connectors.liveSummary query brandProcedure, manage_connectors live-session performance rollup (live-room GMV + session count).
connectors.settlementSummary query brandProcedure, manage_connectors Finance/settlement rollup — net payout vs revenue vs fees per platform.
connectors.create mutation rateLimitedBrandProcedure, manage_connectors —
connectors.updateLabel mutation rateLimitedBrandProcedure, manage_connectors —
connectors.updateConfig mutation rateLimitedBrandProcedure, manage_connectors —
connectors.rotateSecret mutation rateLimitedBrandProcedure, manage_connectors —
connectors.test mutation authedProcedure, manage_connectors —
connectors.sniffSheetRange mutation authedProcedure, manage_connectors —
connectors.bindDatasetTab mutation rateLimitedBrandProcedure, manage_connectors —
connectors.datasetTabDefaults query brandProcedure, manage_connectors —
connectors.datasetBindingTargets query brandProcedure, manage_connectors —
connectors.sheetTabTitles query authedProcedure, manage_connectors —
connectors.listDatasetSources query authedProcedure, manage_connectors —
connectors.activateDomain mutation brandProcedure, manage_connectors —
connectors.packTabs query brandProcedure, manage_connectors 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.bindPackTabs mutation authedProcedure, manage_connectors —
connectors.recentSyncJobs query brandProcedure, manage_connectors —
connectors.delete mutation rateLimitedBrandProcedure, manage_connectors —
connectors.dataInRange query brandProcedure, manage_connectors —
connectors.backfill mutation rateLimitedBrandProcedure, manage_connectors 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.list query brandProcedure, manage_connectors List saved identities with the number of connectors linked to each.
orgCredentials.create mutation rateLimitedBrandProcedure, manage_connectors —
orgCredentials.rename mutation rateLimitedBrandProcedure, manage_connectors —
orgCredentials.setActive mutation rateLimitedBrandProcedure, manage_connectors —
orgCredentials.rotate mutation rateLimitedBrandProcedure, manage_connectors Re-encrypt a new payload onto the same row — every linked connector picks it up on next decrypt.
orgCredentials.remove mutation rateLimitedBrandProcedure, manage_connectors Blocked while any connector references the identity.

connectorBackfill#

Source: apps/web/src/server/routers/connector-backfill.ts

Procedure Type Access Description
connectorBackfill.request mutation rateLimitedOrgProcedure, manage_connectors —
connectorBackfill.list query orgProcedure, manage_connectors A connector's most recent runs (newest first, capped at 50).
connectorBackfill.get query orgProcedure, manage_connectors A single run (for polling one run's live progress).
connectorBackfill.cancel mutation rateLimitedOrgProcedure, manage_connectors Cooperative cancel — flips cancel_requested; the worker skips the remaining slices.

pipeline#

Source: apps/web/src/server/routers/pipeline.ts

Procedure Type Access Description
pipeline.overview query authedProcedure High-level topology + counts per stage.
pipeline.connectorsHealth query authedProcedure Connector-level health: watermark, last sync, throughput since.
pipeline.activity query brandProcedure Hourly activity by stream for the last N hours — for a small sparkline grid.
pipeline.recentSyncs query brandProcedure Recent sync runs — the ticker for the pipeline page.
pipeline.deadLetters query brandProcedure, owner or admin Dead-letter queue page.
pipeline.pauseConnector mutation rateLimitedBrandProcedure, manage_connectors —

manualUploads#

Source: apps/web/src/server/routers/manual-uploads.ts

Procedure Type Access Description
manualUploads.schemas query brandProcedure Schema metadata for every upload type — required and optional column aliases, plus a hint.
manualUploads.template 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.
manualUploads.list query brandProcedure —
manualUploads.get query brandProcedure —
manualUploads.contentReceipt query brandProcedure The receipt of one content_mention upload (funnel, retired rows, pending tags, deck refresh state).
manualUploads.refreshContentDeck mutation rateLimitedBrandProcedure, 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).
manualUploads.download query brandProcedure, manage_data_pipeline Re-download the exact bytes an operator uploaded, when still in the system.
manualUploads.upload mutation rateLimitedBrandProcedure, manage_data_pipeline —
manualUploads.uploadTemplated mutation rateLimitedBrandProcedure, manage_data_pipeline Wave 3 — templated upload.

validation#

Source: apps/web/src/server/routers/validation.ts

Procedure Type Access Description
validation.datasets query brandProcedure Dataset catalog + per-dataset availability:
validation.peekRange mutation rateLimitedBrandProcedure, manage_reports Peek an uploaded file without creating a run:
validation.createRun mutation rateLimitedBrandProcedure, manage_reports —
validation.listRuns query brandProcedure —
validation.getRun query brandProcedure —
validation.dayDiffs query brandProcedure —
validation.deleteRun mutation rateLimitedBrandProcedure, manage_reports Delete a run + all associated diffs.
validation.orderDiffs query brandProcedure —

categories#

Source: apps/web/src/server/routers/categories.ts

Procedure Type Access Description
categories.list query orgProcedure, owner or admin Canonical categories + their platform mappings + SKU rules, assembled without N+1 (parents limited, children fetched via inArray).
categories.platforms query orgProcedure —
categories.autoMap mutation rateLimitedOrgProcedure, owner or admin —
categories.create mutation rateLimitedOrgProcedure, owner or admin —
categories.update mutation rateLimitedOrgProcedure, owner or admin —
categories.remove mutation rateLimitedOrgProcedure, owner or admin —
categories.upsertMapping mutation rateLimitedOrgProcedure, owner or admin —
categories.removeMapping mutation rateLimitedOrgProcedure, owner or admin —
categories.upsertRule mutation rateLimitedOrgProcedure, owner or admin —
categories.removeRule mutation rateLimitedOrgProcedure, owner or admin —

shopAliases#

Source: apps/web/src/server/routers/shop-aliases.ts

Procedure Type Access Description
shopAliases.platforms query orgProcedure —
shopAliases.list query orgProcedure, owner or admin —
shopAliases.distinctShops query orgProcedure, owner or admin —
shopAliases.upsert mutation rateLimitedOrgProcedure, owner or admin —
shopAliases.remove mutation rateLimitedOrgProcedure, owner or admin —

importTemplates#

Source: apps/web/src/server/routers/import-templates.ts

Mapping templates router.

Procedure Type Access Description
importTemplates.list query brandProcedure List all templates the user can see.
importTemplates.catalog query brandProcedure Catalog of canonical streams + their target fields.
importTemplates.installStarterPack mutation rateLimitedBrandProcedure, manage_org_settings Install every mapping template this org can be given without authoring one — one affordance, two derivations:
importTemplates.upsertVersion mutation rateLimitedBrandProcedure, manage_org_settings —
importTemplates.cloneToBrand mutation rateLimitedOrgProcedure, manage_org_settings —
importTemplates.preview mutation rateLimitedBrandProcedure —
importTemplates.sniffHeaders mutation rateLimitedBrandProcedure Header sniff — accepts a sample upload, returns the parsed header columns so the wizard can render the source-side dropdowns.
importTemplates.stats query brandProcedure Stats: how many staging rows queued / promoted / rejected per template.
importTemplates.previewRows mutation rateLimitedBrandProcedure —
importTemplates.sampleFile query brandProcedure Generate the customer's file template:

orgDatasets#

Source: apps/web/src/server/routers/org-datasets.ts

Procedure Type Access Description
orgDatasets.list query rateLimitedOrgProcedure, view_dashboard Every dataset (any brand, any status) the active org owns — org-wide admin surface, mirrors content_datasets' own list shape.
orgDatasets.get query rateLimitedOrgProcedure, view_dashboard One dataset + its full field catalog (every status, the UI renders suggested differently from active, never conflating the two).
orgDatasets.latestPeriod query rateLimitedOrgProcedure —
orgDatasets.listFieldValues query rateLimitedOrgProcedure —
orgDatasets.suggestFromSample mutation rateLimitedOrgProcedure, owner or admin —
orgDatasets.decideFields mutation rateLimitedOrgProcedure, owner or admin —
orgDatasets.declareGrain mutation rateLimitedOrgProcedure, owner or admin —
orgDatasets.linksList query rateLimitedOrgProcedure, view_dashboard Every link the active org owns (any status, the admin surface tells active from archived apart, never conflating the two).
orgDatasets.linksUpsert mutation rateLimitedOrgProcedure, owner or admin —
orgDatasets.linksArchive mutation rateLimitedOrgProcedure, owner or admin Archive one link — the worker's executor skips a non-active link entirely (runDatasetLinkRollup's own WHERE status = 'active');
orgDatasets.panelSettingsForm query authedProcedure, view_dashboard The form model of an editable settings card, plus whether the caller may edit it.
orgDatasets.panelSettingsSaveMine mutation rateLimitedBrandProcedure, view_dashboard Save the caller's own override: one row for this person, never the shared settings.
orgDatasets.panelSettingsResetMine mutation rateLimitedBrandProcedure, view_dashboard Drop the caller's own override: back to the shared settings.
orgDatasets.panelSettingsSave mutation rateLimitedBrandProcedure Save the whole form as manual settings rows (written by the worker).
orgDatasets.panelSettingsReset mutation rateLimitedBrandProcedure Drop every manual settings row: back to the uploaded file's settings.