Analytics and insights
Preview mapped report template fields
Preview mapped report template fields. Uses the explicit reviewed dataset and version; no automatic source refresh. Render inputs can be piped to sosoapi report render --output FILE.
POST /analytics-api/reporting/templates/previewContract reviewed: · sha256:d6e85a113e8fb367
Overview
Preview mapped report template fields. Uses the explicit reviewed dataset and version; no automatic source refresh. Render inputs can be piped to sosoapi report render --output FILE.
A successful HTTP response can mean that a request was accepted rather than completed. For background work, save the returned ID and check the same operation until it finishes. A scheduled or accepted post is published only when the platform confirms it; a client timeout does not establish the result.
Authentication and permissions
A token can use only the rights held by its owner. Each request checks workspace membership, resource ownership, selected workspaces and granted capabilities. Core and full profiles change which tools are displayed; they do not grant access.
Request fields
Required means required inside its parent object and selected branch. A required child does not make an optional parent required. Rules and field names below are copied from the contract.
| Field / branch | Type / required | Constraints |
|---|---|---|
$ | objectRequired in parent |
|
workspace_id | stringRequired in parent |
|
id | stringRequired in parent |
|
version | integerRequired in parent |
|
dataset | objectRequired in parent |
|
dataset.contractVersion | stringRequired in parent |
|
dataset.id | stringRequired in parent |
|
dataset.reviewedAt | stringRequired in parent |
|
dataset.selection | objectRequired in parent |
|
dataset.selection.workspaceId | stringRequired in parent |
|
dataset.selection.accountIds | arrayRequired in parent |
|
dataset.selection.accountIds[] | stringOptional / item |
|
dataset.selection.platforms | arrayRequired in parent |
|
dataset.selection.platforms[] | stringOptional / item |
|
dataset.selection.startDate | stringRequired in parent |
|
dataset.selection.endDate | stringRequired in parent |
|
dataset.selection.timezone | stringRequired in parent |
|
dataset.accounts | arrayRequired in parent |
|
dataset.accounts[] | objectOptional / item |
|
dataset.accounts[].id | stringRequired in parent |
|
dataset.accounts[].workspaceId | stringRequired in parent |
|
dataset.accounts[].platform | stringRequired in parent |
|
dataset.accounts[].name | stringRequired in parent |
|
dataset.accounts[].connectionStatus | stringOptional / item |
|
dataset.accounts[].healthMessage | stringOptional / item |
|
dataset.posts | arrayRequired in parent |
|
dataset.posts[] | objectOptional / item |
|
dataset.posts[].social_post_id | stringRequired in parent |
|
dataset.posts[].workspace_id | stringRequired in parent |
|
dataset.posts[].social_account_id | stringRequired in parent |
|
dataset.posts[].platform | stringRequired in parent |
|
dataset.posts[].provider_post_id | stringRequired in parent |
|
dataset.posts[].provider_published_at | string | nullRequired in parent | — |
dataset.posts[].provider_published_atanyOf 1 | stringRequired in parent |
|
dataset.posts[].provider_published_atanyOf 2 | nullRequired in parent | — |
dataset.posts[].content_format | string | nullRequired in parent | — |
dataset.posts[].content_formatanyOf 1 | stringRequired in parent |
|
dataset.posts[].content_formatanyOf 2 | nullRequired in parent | — |
dataset.posts[].permalink | string | nullRequired in parent | — |
dataset.posts[].permalinkanyOf 1 | stringRequired in parent |
|
dataset.posts[].permalinkanyOf 2 | nullRequired in parent | — |
dataset.posts[].provider_state | stringRequired in parent |
|
dataset.posts[].first_seen_at | stringRequired in parent |
|
dataset.posts[].last_seen_at | stringRequired in parent |
|
dataset.posts[].scheduled_post_id | string | nullRequired in parent | — |
dataset.posts[].scheduled_post_idanyOf 1 | stringRequired in parent |
|
dataset.posts[].scheduled_post_idanyOf 2 | nullRequired in parent | — |
dataset.posts[].provenance | objectRequired in parent |
|
dataset.posts[].provenance.provider | stringRequired in parent |
|
dataset.posts[].provenance.source | stringRequired in parent |
|
dataset.posts[].provenance.source_job_id | string | nullRequired in parent | — |
dataset.posts[].provenance.source_job_idanyOf 1 | stringRequired in parent |
|
dataset.posts[].provenance.source_job_idanyOf 2 | nullRequired in parent | — |
dataset.posts[].provenance.provider_api_version | string | nullRequired in parent | — |
dataset.posts[].provenance.provider_api_versionanyOf 1 | stringRequired in parent |
|
dataset.posts[].provenance.provider_api_versionanyOf 2 | nullRequired in parent | — |
dataset.posts[].provenance.schema_version | string | nullRequired in parent | — |
dataset.posts[].provenance.schema_versionanyOf 1 | stringRequired in parent |
|
dataset.posts[].provenance.schema_versionanyOf 2 | nullRequired in parent | — |
dataset.sources | arrayRequired in parent |
|
dataset.sources[] | objectOptional / item |
|
dataset.sources[].accountId | stringRequired in parent |
|
dataset.sources[].platform | stringRequired in parent |
|
dataset.sources[].resourceKind | stringRequired in parent |
|
dataset.sources[].providerResourceId | string | nullRequired in parent | — |
dataset.sources[].providerResourceIdanyOf 1 | stringRequired in parent |
|
dataset.sources[].providerResourceIdanyOf 2 | nullRequired in parent | — |
dataset.sources[].requestId | string | nullRequired in parent | — |
dataset.sources[].requestIdanyOf 1 | stringRequired in parent |
|
dataset.sources[].requestIdanyOf 2 | nullRequired in parent | — |
dataset.sources[].status | stringRequired in parent |
|
dataset.sources[].reason | string | nullRequired in parent | — |
dataset.sources[].reasonanyOf 1 | stringRequired in parent |
|
dataset.sources[].reasonanyOf 2 | nullRequired in parent | — |
dataset.sources[].envelope | object | nullRequired in parent | — |
dataset.sources[].envelopeanyOf 1 | objectRequired in parent |
|
dataset.sources[].envelope.contract_versionanyOf 1 | stringRequired in parent |
|
dataset.sources[].envelope.request_idanyOf 1 | stringRequired in parent |
|
dataset.sources[].envelope.platformanyOf 1 | stringRequired in parent |
|
dataset.sources[].envelope.resourceanyOf 1 | objectRequired in parent |
|
dataset.sources[].envelope.resource.kindanyOf 1 | stringRequired in parent |
|
dataset.sources[].envelope.resource.social_account_idanyOf 1 | stringRequired in parent |
|
dataset.sources[].envelope.resource.provider_resource_idanyOf 1 | string | nullRequired in parent | — |
dataset.sources[].envelope.provider_api_versionanyOf 1 | stringRequired in parent |
|
dataset.sources[].envelope.fetched_atanyOf 1 | stringRequired in parent |
|
dataset.sources[].envelope.statusanyOf 1 | stringRequired in parent |
|
dataset.sources[].envelope.availabilityanyOf 1 | arrayRequired in parent |
|
dataset.sources[].envelope.availability[]anyOf 1 | objectOptional / item |
|
dataset.sources[].envelope.availability[].scopeanyOf 1 | stringRequired in parent |
|
dataset.sources[].envelope.availability[].statusanyOf 1 | stringRequired in parent |
|
dataset.sources[].envelope.availability[].reasonanyOf 1 | stringOptional / item |
|
dataset.sources[].envelope.availability[].diagnosticsanyOf 1 | objectOptional / item |
|
dataset.sources[].envelope.availability[].diagnostics.http_statusanyOf 1 | integerRequired in parent |
|
dataset.sources[].envelope.availability[].diagnostics.failed_stepanyOf 1 | stringOptional / item |
|
dataset.sources[].envelope.availability[].diagnostics.provider_codeanyOf 1 | number | stringOptional / item | — |
dataset.sources[].envelope.availability[].diagnostics.provider_codeanyOf 1 / anyOf 1 | numberOptional / item | — |
dataset.sources[].envelope.availability[].diagnostics.provider_codeanyOf 1 / anyOf 2 | stringOptional / item |
|
dataset.sources[].envelope.availability[].diagnostics.provider_subcodeanyOf 1 | number | stringOptional / item | — |
dataset.sources[].envelope.availability[].diagnostics.provider_subcodeanyOf 1 / anyOf 1 | numberOptional / item | — |
dataset.sources[].envelope.availability[].diagnostics.provider_subcodeanyOf 1 / anyOf 2 | stringOptional / item |
|
dataset.sources[].envelope.availability[].diagnostics.provider_typeanyOf 1 | stringOptional / item |
|
dataset.sources[].envelope.availability[].diagnostics.is_transientanyOf 1 | booleanOptional / item | — |
dataset.sources[].envelope.availability[].diagnostics.provider_request_idanyOf 1 | stringOptional / item |
|
dataset.sources[].envelope.availability[].diagnostics.accessanyOf 1 | objectOptional / item |
|
dataset.sources[].envelope.availability[].diagnostics.access.login_modeanyOf 1 | stringRequired in parent |
|
dataset.sources[].envelope.availability[].diagnostics.access.provider_hostanyOf 1 | stringRequired in parent |
|
dataset.sources[].envelope.availability[].diagnostics.access.required_permissionsanyOf 1 | arrayRequired in parent |
|
dataset.sources[].envelope.availability[].diagnostics.access.required_permissions[]anyOf 1 | stringOptional / item |
|
dataset.sources[].envelope.availability[].diagnostics.access.current_connection_policy_permissionsanyOf 1 | arrayRequired in parent |
|
dataset.sources[].envelope.availability[].diagnostics.access.current_connection_policy_permissions[]anyOf 1 | stringOptional / item |
|
dataset.sources[].envelope.availability[].diagnostics.access.granted_permissionsanyOf 1 | array | nullRequired in parent | — |
dataset.sources[].envelope.availability[].diagnostics.access.granted_permissionsanyOf 1 / anyOf 1 | arrayRequired in parent |
|
dataset.sources[].envelope.availability[].diagnostics.access.granted_permissions[]anyOf 1 / anyOf 1 | stringOptional / item |
|
dataset.sources[].envelope.availability[].diagnostics.access.granted_permissionsanyOf 1 / anyOf 2 | nullRequired in parent | — |
dataset.sources[].envelope.availability[].diagnostics.access.grant_evidenceanyOf 1 | stringRequired in parent |
|
dataset.sources[].envelope.availability[].diagnostics.access.permission_stateanyOf 1 | stringRequired in parent |
|
dataset.sources[].envelope.availability[].diagnostics.access.grant_observed_atanyOf 1 | stringOptional / item |
|
dataset.sources[].envelope.availability[].diagnostics.access.app_accessanyOf 1 | stringRequired in parent |
|
dataset.sources[].envelope.availability[].diagnostics.access.next_stepanyOf 1 | stringRequired in parent |
|
dataset.sources[].envelope.provider_dataanyOf 1 | any JSON value | nullRequired in parent | — |
dataset.sources[].envelope.provider_dataanyOf 1 / anyOf 1 | any JSON valueRequired in parent | — |
dataset.sources[].envelope.provider_dataanyOf 1 / anyOf 2 | nullRequired in parent | — |
dataset.sources[].envelope.requested_date_rangeanyOf 1 | object | nullRequired in parent | — |
dataset.sources[].envelope.requested_date_rangeanyOf 1 / anyOf 1 | objectRequired in parent |
|
dataset.sources[].envelope.requested_date_range.start_dateanyOf 1 / anyOf 1 | stringRequired in parent |
|
dataset.sources[].envelope.requested_date_range.end_dateanyOf 1 / anyOf 1 | stringRequired in parent |
|
dataset.sources[].envelope.requested_date_rangeanyOf 1 / anyOf 2 | nullRequired in parent | — |
dataset.sources[].envelope.cacheanyOf 1 | objectRequired in parent |
|
dataset.sources[].envelope.cache.authoritativeanyOf 1 | booleanRequired in parent |
|
dataset.sources[].envelope.cache.statusanyOf 1 | stringRequired in parent |
|
dataset.sources[].envelope.cache.expires_atanyOf 1 | stringRequired in parent |
|
dataset.sources[].envelopeanyOf 2 | nullRequired in parent | — |
dataset.sources[].metrics | arrayRequired in parent |
|
dataset.sources[].metrics[] | objectOptional / item |
|
dataset.sources[].metrics[].key | stringRequired in parent |
|
dataset.sources[].metrics[].definition | stringRequired in parent |
|
dataset.sources[].metrics[].unit | stringRequired in parent |
|
dataset.sources[].metrics[].grain | stringRequired in parent |
|
dataset.sources[].metrics[].value | number | nullRequired in parent | — |
dataset.sources[].metrics[].availability | stringRequired in parent |
|
dataset.sources[].metrics[].reason | string | nullRequired in parent | — |
dataset.sources[].metrics[].reasonanyOf 1 | stringRequired in parent |
|
dataset.sources[].metrics[].reasonanyOf 2 | nullRequired in parent | — |
dataset.sources[].metrics[].measurement | objectRequired in parent |
|
dataset.sources[].metrics[].measurement.kind | stringRequired in parent |
|
dataset.sources[].metrics[].measurement.period | string | nullRequired in parent | — |
dataset.sources[].metrics[].measurement.periodanyOf 1 | stringRequired in parent |
|
dataset.sources[].metrics[].measurement.periodanyOf 2 | nullRequired in parent | — |
dataset.sources[].metrics[].measurement.start | string | nullRequired in parent | — |
dataset.sources[].metrics[].measurement.startanyOf 1 | stringRequired in parent |
|
dataset.sources[].metrics[].measurement.startanyOf 2 | nullRequired in parent | — |
dataset.sources[].metrics[].measurement.end | string | nullRequired in parent | — |
dataset.sources[].metrics[].measurement.endanyOf 1 | stringRequired in parent |
|
dataset.sources[].metrics[].measurement.endanyOf 2 | nullRequired in parent | — |
dataset.sources[].metrics[].measurement.timezone | string | nullRequired in parent | — |
dataset.sources[].metrics[].measurement.timezoneanyOf 1 | stringRequired in parent |
|
dataset.sources[].metrics[].measurement.timezoneanyOf 2 | nullRequired in parent | — |
dataset.sources[].metrics[].sourcePath | stringRequired in parent |
|
dataset.coverage | objectRequired in parent |
|
dataset.coverage.population | stringRequired in parent |
|
dataset.coverage.postsComplete | booleanRequired in parent | — |
dataset.coverage.nextCursor | string | nullRequired in parent | — |
dataset.coverage.nextCursoranyOf 1 | stringRequired in parent |
|
dataset.coverage.nextCursoranyOf 2 | nullRequired in parent | — |
dataset.coverage.postLimit | integerRequired in parent |
|
dataset.coverage.postInsightsLimit | integerRequired in parent |
|
dataset.coverage.omittedPostInsights | integerRequired in parent |
|
dataset.coverage.notes | arrayRequired in parent |
|
dataset.coverage.notes[] | stringOptional / item |
|
dataset.customMetrics | arrayRequired in parent |
|
dataset.customMetrics[] | objectOptional / item |
|
dataset.customMetrics[].id | stringRequired in parent |
|
dataset.customMetrics[].name | stringRequired in parent |
|
dataset.customMetrics[].version | integerRequired in parent |
|
dataset.customMetrics[].expression | stringRequired in parent |
|
dataset.customMetrics[].definition | stringRequired in parent |
|
dataset.customMetrics[].unit | stringRequired in parent |
|
dataset.customMetrics[].grain | stringRequired in parent |
|
dataset.customMetrics[].rounding | objectRequired in parent |
|
dataset.customMetrics[].rounding.decimalPlaces | integerRequired in parent |
|
dataset.customMetrics[].rounding.mode | stringRequired in parent |
|
dataset.customMetrics[].inputs | arrayRequired in parent |
|
dataset.customMetrics[].inputs[] | objectOptional / item |
|
dataset.customMetrics[].inputs[].requestId | string | nullRequired in parent | — |
dataset.customMetrics[].inputs[].requestIdanyOf 1 | stringRequired in parent |
|
dataset.customMetrics[].inputs[].requestIdanyOf 2 | nullRequired in parent | — |
dataset.customMetrics[].inputs[].sourcePath | stringRequired in parent |
|
dataset.customMetrics[].inputs[].value | number | nullRequired in parent | — |
dataset.customMetrics[].inputs[].availability | stringRequired in parent |
|
dataset.customMetrics[].value | number | nullRequired in parent | — |
dataset.customMetrics[].availability | stringRequired in parent |
|
dataset.customMetrics[].reason | string | nullRequired in parent | — |
dataset.customMetrics[].reasonanyOf 1 | stringRequired in parent |
|
dataset.customMetrics[].reasonanyOf 2 | nullRequired in parent | — |
dataset.customMetrics[].formula | objectOptional / item |
|
dataset.customMetrics[].formula.contractVersion | stringRequired in parent |
|
dataset.customMetrics[].formula.id | stringRequired in parent |
|
dataset.customMetrics[].formula.workspaceId | stringRequired in parent |
|
dataset.customMetrics[].formula.name | stringRequired in parent |
|
dataset.customMetrics[].formula.version | integerRequired in parent |
|
dataset.customMetrics[].formula.expression | stringRequired in parent |
|
dataset.customMetrics[].formula.fields | arrayRequired in parent |
|
dataset.customMetrics[].formula.fields[] | objectOptional / item |
|
dataset.customMetrics[].formula.fields[].identifier | stringRequired in parent |
|
dataset.customMetrics[].formula.fields[].selector | objectRequired in parent |
|
dataset.customMetrics[].formula.fields[].selector.platform | stringRequired in parent |
|
dataset.customMetrics[].formula.fields[].selector.key | stringRequired in parent |
|
dataset.customMetrics[].formula.fields[].selector.definition | stringRequired in parent |
|
dataset.customMetrics[].formula.fields[].selector.unit | stringRequired in parent |
|
dataset.customMetrics[].formula.fields[].selector.grain | stringRequired in parent |
|
dataset.customMetrics[].formula.fields[].selector.measurementKind | stringRequired in parent |
|
dataset.customMetrics[].formula.fields[].selector.nativePeriod | string | nullRequired in parent | — |
dataset.customMetrics[].formula.fields[].selector.nativePeriodanyOf 1 | stringRequired in parent |
|
dataset.customMetrics[].formula.fields[].selector.nativePeriodanyOf 2 | nullRequired in parent | — |
dataset.customMetrics[].formula.fields[].selector.timezone | string | nullRequired in parent | — |
dataset.customMetrics[].formula.fields[].selector.timezoneanyOf 1 | stringRequired in parent |
|
dataset.customMetrics[].formula.fields[].selector.timezoneanyOf 2 | nullRequired in parent | — |
dataset.customMetrics[].formula.fields[].aggregation | stringRequired in parent |
|
dataset.customMetrics[].formula.rounding | objectRequired in parent |
|
dataset.customMetrics[].formula.rounding.decimalPlaces | integerRequired in parent |
|
dataset.customMetrics[].formula.rounding.mode | stringRequired in parent |
|
dataset.customMetrics[].calculation | objectOptional / item |
|
dataset.customMetrics[].calculation.contractVersion | stringRequired in parent |
|
dataset.customMetrics[].calculation.workspaceId | stringRequired in parent |
|
dataset.customMetrics[].calculation.datasetId | stringRequired in parent |
|
dataset.customMetrics[].calculation.formulaId | stringRequired in parent |
|
dataset.customMetrics[].calculation.name | stringRequired in parent |
|
dataset.customMetrics[].calculation.version | integerRequired in parent |
|
dataset.customMetrics[].calculation.expression | stringRequired in parent |
|
dataset.customMetrics[].calculation.rounding | objectRequired in parent |
|
dataset.customMetrics[].calculation.rounding.decimalPlaces | integerRequired in parent |
|
dataset.customMetrics[].calculation.rounding.mode | stringRequired in parent |
|
dataset.customMetrics[].calculation.value | number | nullRequired in parent | — |
dataset.customMetrics[].calculation.unit | stringRequired in parent |
|
dataset.customMetrics[].calculation.status | stringRequired in parent |
|
dataset.customMetrics[].calculation.code | stringRequired in parent |
|
dataset.customMetrics[].calculation.reason | string | nullRequired in parent | — |
dataset.customMetrics[].calculation.reasonanyOf 1 | stringRequired in parent |
|
dataset.customMetrics[].calculation.reasonanyOf 2 | nullRequired in parent | — |
dataset.customMetrics[].calculation.excludedInputIds | arrayRequired in parent |
|
dataset.customMetrics[].calculation.excludedInputIds[] | stringOptional / item |
|
dataset.customMetrics[].calculation.inputs | arrayRequired in parent |
|
dataset.customMetrics[].calculation.inputs[] | objectOptional / item |
|
dataset.customMetrics[].calculation.inputs[].inputId | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].selector | objectRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].selector.platform | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].selector.key | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].selector.definition | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].selector.unit | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].selector.grain | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].selector.measurementKind | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].selector.nativePeriod | string | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].selector.nativePeriodanyOf 1 | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].selector.nativePeriodanyOf 2 | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].selector.timezone | string | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].selector.timezoneanyOf 1 | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].selector.timezoneanyOf 2 | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].value | number | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].availability | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].reason | string | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].reasonanyOf 1 | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].reasonanyOf 2 | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].measurement | objectRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].measurement.kind | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].measurement.period | string | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].measurement.periodanyOf 1 | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].measurement.periodanyOf 2 | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].measurement.start | string | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].measurement.startanyOf 1 | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].measurement.startanyOf 2 | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].measurement.end | string | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].measurement.endanyOf 1 | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].measurement.endanyOf 2 | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].measurement.timezone | string | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].measurement.timezoneanyOf 1 | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].measurement.timezoneanyOf 2 | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].requestId | string | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].requestIdanyOf 1 | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].requestIdanyOf 2 | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].sourcePath | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].accountId | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].providerResourceId | string | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].providerResourceIdanyOf 1 | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].providerResourceIdanyOf 2 | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].fetchedAt | string | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].fetchedAtanyOf 1 | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].fetchedAtanyOf 2 | nullRequired in parent | — |
dataset.customMetrics[].calculation.inputs[].identifier | stringRequired in parent |
|
dataset.customMetrics[].calculation.inputs[].included | booleanRequired in parent | — |
Complete JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"type": "object",
"properties": {
"workspace_id": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
"id": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
"version": {
"type": "integer",
"minimum": 1,
"maximum": 1000000
},
"dataset": {
"type": "object",
"properties": {
"contractVersion": {
"type": "string",
"const": "analytics-report/v1"
},
"id": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
"reviewedAt": {
"type": "string",
"pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$",
"format": "date-time"
},
"selection": {
"type": "object",
"properties": {
"workspaceId": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
"accountIds": {
"minItems": 1,
"maxItems": 50,
"type": "array",
"items": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
}
},
"platforms": {
"minItems": 1,
"maxItems": 4,
"type": "array",
"items": {
"type": "string",
"enum": [
"facebook",
"instagram",
"threads",
"youtube"
]
}
},
"startDate": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$"
},
"endDate": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$"
},
"timezone": {
"type": "string",
"minLength": 1,
"maxLength": 100
}
},
"required": [
"workspaceId",
"accountIds",
"platforms",
"startDate",
"endDate",
"timezone"
],
"additionalProperties": false
},
"accounts": {
"maxItems": 50,
"type": "array",
"items": {
"type": "object",
"properties": {
"id": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
"workspaceId": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
"platform": {
"type": "string",
"enum": [
"facebook",
"instagram",
"threads",
"youtube"
]
},
"name": {
"type": "string",
"maxLength": 500
},
"connectionStatus": {
"type": "string",
"maxLength": 100
},
"healthMessage": {
"type": "string",
"maxLength": 1000
}
},
"required": [
"id",
"workspaceId",
"platform",
"name"
],
"additionalProperties": false
}
},
"posts": {
"maxItems": 1000,
"type": "array",
"items": {
"type": "object",
"properties": {
"social_post_id": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
"workspace_id": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
"social_account_id": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
"platform": {
"type": "string",
"enum": [
"instagram",
"facebook",
"threads",
"youtube"
]
},
"provider_post_id": {
"type": "string",
"minLength": 1,
"maxLength": 512
},
"provider_published_at": {
"anyOf": [
{
"type": "string",
"pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$",
"format": "date-time"
},
{
"type": "null"
}
]
},
"content_format": {
"anyOf": [
{
"type": "string",
"minLength": 1,
"maxLength": 100
},
{
"type": "null"
}
]
},
"permalink": {
"anyOf": [
{
"type": "string",
"maxLength": 2048,
"format": "uri"
},
{
"type": "null"
}
]
},
"provider_state": {
"type": "string",
"enum": [
"available",
"deleted",
"unavailable",
"unknown"
]
},
"first_seen_at": {
"type": "string",
"pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$",
"format": "date-time"
},
"last_seen_at": {
"type": "string",
"pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$",
"format": "date-time"
},
"scheduled_post_id": {
"anyOf": [
{
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
{
"type": "null"
}
]
},
"provenance": {
"type": "object",
"properties": {
"provider": {
"type": "string",
"enum": [
"instagram",
"facebook",
"threads",
"youtube"
]
},
"source": {
"type": "string",
"enum": [
"provider_api",
"provider_webhook",
"publication_outcome",
"backfill"
]
},
"source_job_id": {
"anyOf": [
{
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
{
"type": "null"
}
]
},
"provider_api_version": {
"anyOf": [
{
"type": "string",
"minLength": 1,
"maxLength": 200
},
{
"type": "null"
}
]
},
"schema_version": {
"anyOf": [
{
"type": "string",
"minLength": 1,
"maxLength": 200
},
{
"type": "null"
}
]
}
},
"required": [
"provider",
"source",
"source_job_id",
"provider_api_version",
"schema_version"
],
"additionalProperties": false
}
},
"required": [
"social_post_id",
"workspace_id",
"social_account_id",
"platform",
"provider_post_id",
"provider_published_at",
"content_format",
"permalink",
"provider_state",
"first_seen_at",
"last_seen_at",
"scheduled_post_id",
"provenance"
],
"additionalProperties": false
}
},
"sources": {
"maxItems": 30,
"type": "array",
"items": {
"type": "object",
"properties": {
"accountId": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
"platform": {
"type": "string",
"enum": [
"facebook",
"instagram",
"threads",
"youtube"
]
},
"resourceKind": {
"type": "string",
"enum": [
"account",
"post"
]
},
"providerResourceId": {
"anyOf": [
{
"type": "string",
"maxLength": 512
},
{
"type": "null"
}
]
},
"requestId": {
"anyOf": [
{
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
{
"type": "null"
}
]
},
"status": {
"type": "string",
"enum": [
"available",
"partial",
"not_returned",
"unsupported",
"permission_required",
"threshold_not_met",
"no_data",
"failed",
"pending",
"stale"
]
},
"reason": {
"anyOf": [
{
"type": "string",
"maxLength": 8000
},
{
"type": "null"
}
]
},
"envelope": {
"anyOf": [
{
"type": "object",
"properties": {
"contract_version": {
"type": "string",
"const": "provider-insights/v1"
},
"request_id": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
"platform": {
"type": "string",
"enum": [
"facebook",
"instagram",
"threads",
"youtube"
]
},
"resource": {
"type": "object",
"properties": {
"kind": {
"type": "string",
"enum": [
"account",
"post"
]
},
"social_account_id": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
"provider_resource_id": {
"type": [
"string",
"null"
]
}
},
"required": [
"kind",
"social_account_id",
"provider_resource_id"
],
"additionalProperties": false
},
"provider_api_version": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"fetched_at": {
"type": "string",
"pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$",
"format": "date-time"
},
"status": {
"type": "string",
"enum": [
"available",
"partial",
"unavailable"
]
},
"availability": {
"minItems": 1,
"maxItems": 64,
"type": "array",
"items": {
"type": "object",
"properties": {
"scope": {
"type": "string",
"minLength": 1,
"maxLength": 200
},
"status": {
"type": "string",
"enum": [
"available",
"partial",
"not_returned",
"unsupported",
"permission_required",
"threshold_not_met",
"no_data",
"failed"
]
},
"reason": {
"type": "string",
"minLength": 1,
"maxLength": 2000
},
"diagnostics": {
"type": "object",
"properties": {
"http_status": {
"type": "integer",
"minimum": 0,
"maximum": 599
},
"failed_step": {
"type": "string",
"minLength": 1,
"maxLength": 200
},
"provider_code": {
"anyOf": [
{
"type": "number"
},
{
"type": "string",
"maxLength": 100
}
]
},
"provider_subcode": {
"anyOf": [
{
"type": "number"
},
{
"type": "string",
"maxLength": 100
}
]
},
"provider_type": {
"type": "string",
"maxLength": 200
},
"is_transient": {
"type": "boolean"
},
"provider_request_id": {
"type": "string",
"maxLength": 200
},
"access": {
"type": "object",
"properties": {
"login_mode": {
"type": "string",
"enum": [
"instagram_login",
"facebook_login",
"threads_user"
]
},
"provider_host": {
"type": "string",
"maxLength": 200
},
"required_permissions": {
"maxItems": 16,
"type": "array",
"items": {
"type": "string",
"maxLength": 100
}
},
"current_connection_policy_permissions": {
"maxItems": 16,
"type": "array",
"items": {
"type": "string",
"maxLength": 100
}
},
"granted_permissions": {
"anyOf": [
{
"maxItems": 128,
"type": "array",
"items": {
"type": "string",
"maxLength": 100
}
},
{
"type": "null"
}
]
},
"grant_evidence": {
"type": "string",
"enum": [
"exact",
"unknown"
]
},
"permission_state": {
"type": "string",
"enum": [
"granted",
"missing",
"unknown"
]
},
"grant_observed_at": {
"type": "string",
"pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$",
"format": "date-time"
},
"app_access": {
"type": "string",
"const": "unverified"
},
"next_step": {
"type": "string",
"maxLength": 1500
}
},
"required": [
"login_mode",
"provider_host",
"required_permissions",
"current_connection_policy_permissions",
"granted_permissions",
"grant_evidence",
"permission_state",
"app_access",
"next_step"
],
"additionalProperties": false
}
},
"required": [
"http_status"
],
"additionalProperties": false
}
},
"required": [
"scope",
"status"
],
"additionalProperties": false
}
},
"provider_data": {
"anyOf": [
{},
{
"type": "null"
}
]
},
"requested_date_range": {
"anyOf": [
{
"type": "object",
"properties": {
"start_date": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$"
},
"end_date": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$"
}
},
"required": [
"start_date",
"end_date"
],
"additionalProperties": false
},
{
"type": "null"
}
]
},
"cache": {
"type": "object",
"properties": {
"authoritative": {
"type": "boolean",
"const": false
},
"status": {
"type": "string",
"enum": [
"stored",
"hit",
"bypassed"
]
},
"expires_at": {
"type": "string",
"pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$",
"format": "date-time"
}
},
"required": [
"authoritative",
"status",
"expires_at"
],
"additionalProperties": false
}
},
"required": [
"contract_version",
"request_id",
"platform",
"resource",
"provider_api_version",
"fetched_at",
"status",
"availability",
"provider_data",
"requested_date_range",
"cache"
],
"additionalProperties": false
},
{
"type": "null"
}
]
},
"metrics": {
"maxItems": 5000,
"type": "array",
"items": {
"type": "object",
"properties": {
"key": {
"type": "string",
"minLength": 1,
"maxLength": 150
},
"definition": {
"type": "string",
"minLength": 1,
"maxLength": 1000
},
"unit": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"grain": {
"type": "string",
"enum": [
"post",
"account"
]
},
"value": {
"type": [
"number",
"null"
]
},
"availability": {
"type": "string",
"enum": [
"available",
"partial",
"not_returned",
"unsupported",
"permission_required",
"threshold_not_met",
"no_data",
"failed",
"pending",
"stale"
]
},
"reason": {
"anyOf": [
{
"type": "string",
"maxLength": 4000
},
{
"type": "null"
}
]
},
"measurement": {
"type": "object",
"properties": {
"kind": {
"type": "string",
"enum": [
"lifetime",
"snapshot",
"period",
"unknown"
]
},
"period": {
"anyOf": [
{
"type": "string",
"maxLength": 100
},
{
"type": "null"
}
]
},
"start": {
"anyOf": [
{
"type": "string",
"maxLength": 100
},
{
"type": "null"
}
]
},
"end": {
"anyOf": [
{
"type": "string",
"maxLength": 100
},
{
"type": "null"
}
]
},
"timezone": {
"anyOf": [
{
"type": "string",
"maxLength": 100
},
{
"type": "null"
}
]
}
},
"required": [
"kind",
"period",
"start",
"end",
"timezone"
],
"additionalProperties": false
},
"sourcePath": {
"type": "string",
"minLength": 1,
"maxLength": 2000
}
},
"required": [
"key",
"definition",
"unit",
"grain",
"value",
"availability",
"reason",
"measurement",
"sourcePath"
],
"additionalProperties": false
}
}
},
"required": [
"accountId",
"platform",
"resourceKind",
"providerResourceId",
"requestId",
"status",
"reason",
"envelope",
"metrics"
],
"additionalProperties": false
}
},
"coverage": {
"type": "object",
"properties": {
"population": {
"type": "string",
"const": "discovered_posts"
},
"postsComplete": {
"type": "boolean"
},
"nextCursor": {
"anyOf": [
{
"type": "string",
"maxLength": 16384
},
{
"type": "null"
}
]
},
"postLimit": {
"type": "integer",
"minimum": 0,
"maximum": 1000
},
"postInsightsLimit": {
"type": "integer",
"minimum": 0,
"maximum": 20
},
"omittedPostInsights": {
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
},
"notes": {
"maxItems": 50,
"type": "array",
"items": {
"type": "string",
"maxLength": 2000
}
}
},
"required": [
"population",
"postsComplete",
"nextCursor",
"postLimit",
"postInsightsLimit",
"omittedPostInsights",
"notes"
],
"additionalProperties": false
},
"customMetrics": {
"maxItems": 50,
"type": "array",
"items": {
"type": "object",
"properties": {
"id": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
"name": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"version": {
"type": "integer",
"exclusiveMinimum": 0,
"maximum": 9007199254740991
},
"expression": {
"type": "string",
"minLength": 1,
"maxLength": 1000
},
"definition": {
"type": "string",
"maxLength": 1000
},
"unit": {
"type": "string",
"maxLength": 100
},
"grain": {
"type": "string",
"enum": [
"post",
"account",
"compatible_sum"
]
},
"rounding": {
"type": "object",
"properties": {
"decimalPlaces": {
"type": "integer",
"minimum": 0,
"maximum": 8
},
"mode": {
"type": "string",
"const": "half_away_from_zero"
}
},
"required": [
"decimalPlaces",
"mode"
],
"additionalProperties": false
},
"inputs": {
"maxItems": 5000,
"type": "array",
"items": {
"type": "object",
"properties": {
"requestId": {
"anyOf": [
{
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
{
"type": "null"
}
]
},
"sourcePath": {
"type": "string",
"maxLength": 2000
},
"value": {
"type": [
"number",
"null"
]
},
"availability": {
"type": "string",
"enum": [
"available",
"partial",
"not_returned",
"unsupported",
"permission_required",
"threshold_not_met",
"no_data",
"failed",
"pending",
"stale"
]
}
},
"required": [
"requestId",
"sourcePath",
"value",
"availability"
],
"additionalProperties": false
}
},
"value": {
"type": [
"number",
"null"
]
},
"availability": {
"type": "string",
"enum": [
"available",
"partial",
"not_returned",
"unsupported",
"permission_required",
"threshold_not_met",
"no_data",
"failed",
"pending",
"stale"
]
},
"reason": {
"anyOf": [
{
"type": "string",
"maxLength": 4000
},
{
"type": "null"
}
]
},
"formula": {
"type": "object",
"properties": {
"contractVersion": {
"type": "string",
"const": "analytics-metric/v1"
},
"id": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
"workspaceId": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
"name": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"version": {
"type": "integer",
"minimum": 1,
"maximum": 1000000
},
"expression": {
"type": "string",
"minLength": 1,
"maxLength": 1000
},
"fields": {
"maxItems": 32,
"type": "array",
"items": {
"type": "object",
"properties": {
"identifier": {
"type": "string",
"pattern": "^[a-z][a-z0-9_]{0,63}$"
},
"selector": {
"type": "object",
"properties": {
"platform": {
"type": "string",
"enum": [
"facebook",
"instagram",
"threads",
"youtube"
]
},
"key": {
"type": "string",
"pattern": "^[A-Za-z][A-Za-z0-9_]{0,100}$"
},
"definition": {
"type": "string",
"minLength": 1,
"maxLength": 500
},
"unit": {
"type": "string",
"enum": [
"count",
"seconds",
"minutes",
"percent",
"ratio"
]
},
"grain": {
"type": "string",
"enum": [
"post",
"account"
]
},
"measurementKind": {
"type": "string",
"enum": [
"lifetime",
"snapshot",
"period",
"unknown"
]
},
"nativePeriod": {
"anyOf": [
{
"type": "string",
"minLength": 1,
"maxLength": 64
},
{
"type": "null"
}
]
},
"timezone": {
"anyOf": [
{
"type": "string",
"minLength": 1,
"maxLength": 100
},
{
"type": "null"
}
]
}
},
"required": [
"platform",
"key",
"definition",
"unit",
"grain",
"measurementKind",
"nativePeriod",
"timezone"
],
"additionalProperties": false
},
"aggregation": {
"type": "string",
"enum": [
"single",
"sum"
]
}
},
"required": [
"identifier",
"selector",
"aggregation"
],
"additionalProperties": false
}
},
"rounding": {
"type": "object",
"properties": {
"decimalPlaces": {
"type": "integer",
"minimum": 0,
"maximum": 8
},
"mode": {
"type": "string",
"const": "half_away_from_zero"
}
},
"required": [
"decimalPlaces",
"mode"
],
"additionalProperties": false
}
},
"required": [
"contractVersion",
"id",
"workspaceId",
"name",
"version",
"expression",
"fields",
"rounding"
],
"additionalProperties": false
},
"calculation": {
"type": "object",
"properties": {
"contractVersion": {
"type": "string",
"const": "analytics-metric/v1"
},
"workspaceId": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
"datasetId": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"formulaId": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
"name": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"version": {
"type": "integer",
"exclusiveMinimum": 0,
"maximum": 9007199254740991
},
"expression": {
"type": "string",
"maxLength": 1000
},
"rounding": {
"type": "object",
"properties": {
"decimalPlaces": {
"type": "integer",
"minimum": 0,
"maximum": 8
},
"mode": {
"type": "string",
"const": "half_away_from_zero"
}
},
"required": [
"decimalPlaces",
"mode"
],
"additionalProperties": false
},
"value": {
"type": [
"number",
"null"
]
},
"unit": {
"type": "string",
"minLength": 1,
"maxLength": 200
},
"status": {
"type": "string",
"enum": [
"available",
"not_returned"
]
},
"code": {
"type": "string",
"enum": [
"ok",
"invalid_expression",
"missing_input",
"incompatible_input",
"zero_denominator",
"numeric_limit",
"workspace_mismatch",
"ambiguous_input",
"unknown_exclusion"
]
},
"reason": {
"anyOf": [
{
"type": "string",
"minLength": 1,
"maxLength": 500
},
{
"type": "null"
}
]
},
"excludedInputIds": {
"maxItems": 5000,
"type": "array",
"items": {
"type": "string",
"minLength": 1,
"maxLength": 1500
}
},
"inputs": {
"maxItems": 5000,
"type": "array",
"items": {
"type": "object",
"properties": {
"inputId": {
"type": "string",
"minLength": 1,
"maxLength": 1500
},
"selector": {
"type": "object",
"properties": {
"platform": {
"type": "string",
"enum": [
"facebook",
"instagram",
"threads",
"youtube"
]
},
"key": {
"type": "string",
"pattern": "^[A-Za-z][A-Za-z0-9_]{0,100}$"
},
"definition": {
"type": "string",
"minLength": 1,
"maxLength": 500
},
"unit": {
"type": "string",
"enum": [
"count",
"seconds",
"minutes",
"percent",
"ratio"
]
},
"grain": {
"type": "string",
"enum": [
"post",
"account"
]
},
"measurementKind": {
"type": "string",
"enum": [
"lifetime",
"snapshot",
"period",
"unknown"
]
},
"nativePeriod": {
"anyOf": [
{
"type": "string",
"minLength": 1,
"maxLength": 64
},
{
"type": "null"
}
]
},
"timezone": {
"anyOf": [
{
"type": "string",
"minLength": 1,
"maxLength": 100
},
{
"type": "null"
}
]
}
},
"required": [
"platform",
"key",
"definition",
"unit",
"grain",
"measurementKind",
"nativePeriod",
"timezone"
],
"additionalProperties": false
},
"value": {
"type": [
"number",
"null"
]
},
"availability": {
"type": "string",
"enum": [
"available",
"partial",
"not_returned",
"unsupported",
"permission_required",
"threshold_not_met",
"no_data",
"failed",
"pending",
"stale"
]
},
"reason": {
"anyOf": [
{
"type": "string",
"maxLength": 8000
},
{
"type": "null"
}
]
},
"measurement": {
"type": "object",
"properties": {
"kind": {
"type": "string",
"enum": [
"lifetime",
"snapshot",
"period",
"unknown"
]
},
"period": {
"anyOf": [
{
"type": "string",
"minLength": 1,
"maxLength": 64
},
{
"type": "null"
}
]
},
"start": {
"anyOf": [
{
"type": "string",
"minLength": 1,
"maxLength": 64
},
{
"type": "null"
}
]
},
"end": {
"anyOf": [
{
"type": "string",
"minLength": 1,
"maxLength": 64
},
{
"type": "null"
}
]
},
"timezone": {
"anyOf": [
{
"type": "string",
"minLength": 1,
"maxLength": 100
},
{
"type": "null"
}
]
}
},
"required": [
"kind",
"period",
"start",
"end",
"timezone"
],
"additionalProperties": false
},
"requestId": {
"anyOf": [
{
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
{
"type": "null"
}
]
},
"sourcePath": {
"type": "string",
"minLength": 1,
"maxLength": 1000
},
"accountId": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
"providerResourceId": {
"anyOf": [
{
"type": "string",
"minLength": 1,
"maxLength": 512
},
{
"type": "null"
}
]
},
"fetchedAt": {
"anyOf": [
{
"type": "string",
"pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z|([+-](?:[01]\\d|2[0-3]):[0-5]\\d)))$",
"format": "date-time"
},
{
"type": "null"
}
]
},
"identifier": {
"type": "string",
"pattern": "^[a-z][a-z0-9_]{0,63}$"
},
"included": {
"type": "boolean"
}
},
"required": [
"inputId",
"selector",
"value",
"availability",
"reason",
"measurement",
"requestId",
"sourcePath",
"accountId",
"providerResourceId",
"fetchedAt",
"identifier",
"included"
],
"additionalProperties": false
}
}
},
"required": [
"contractVersion",
"workspaceId",
"datasetId",
"formulaId",
"name",
"version",
"expression",
"rounding",
"value",
"unit",
"status",
"code",
"reason",
"excludedInputIds",
"inputs"
],
"additionalProperties": false
}
},
"required": [
"id",
"name",
"version",
"expression",
"definition",
"unit",
"grain",
"rounding",
"inputs",
"value",
"availability",
"reason"
],
"additionalProperties": false
}
}
},
"required": [
"contractVersion",
"id",
"reviewedAt",
"selection",
"accounts",
"posts",
"sources",
"coverage",
"customMetrics"
],
"additionalProperties": false
}
},
"required": [
"workspace_id",
"id",
"version",
"dataset"
],
"additionalProperties": false
}Response and completion
Success HTTP statuses: 200. When the operation is complete: synchronous_http_response.
A successful HTTP response can mean that a request was accepted rather than completed. For background work, save the returned ID and check the same operation until it finishes. A scheduled or accepted post is published only when the platform confirms it; a client timeout does not establish the result.
Required means required inside its parent object and selected branch. A required child does not make an optional parent required. Rules and field names below are copied from the contract.
| Field / branch | Type / required | Constraints |
|---|---|---|
$ | objectRequired in parent | — |
datasetId | stringRequired in parent |
|
sourceSha256 | stringRequired in parent |
|
fingerprint | stringRequired in parent |
|
values | arrayRequired in parent |
|
values[] | objectOptional / item | — |
values[].name | stringRequired in parent |
|
values[].required | booleanRequired in parent | — |
values[].kind | string | nullRequired in parent | — |
values[].kindanyOf 1 | stringRequired in parent |
|
values[].kindanyOf 2 | nullRequired in parent | — |
values[].text | stringRequired in parent | — |
values[].status | stringRequired in parent |
|
values[].reason | string | nullRequired in parent | — |
values[].rows | arrayOptional / item | — |
values[].rows[] | arrayOptional / item | — |
values[].rows[][] | stringOptional / item | — |
values[].chart | arrayOptional / item | — |
values[].chart[] | objectOptional / item | — |
values[].chart[].label | stringRequired in parent | — |
values[].chart[].value | numberRequired in parent | — |
blocking | arrayRequired in parent | — |
blocking[] | stringOptional / item | — |
warnings | arrayRequired in parent | — |
warnings[] | stringOptional / item | — |
Complete JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"type": "object",
"properties": {
"datasetId": {
"type": "string",
"format": "uuid",
"pattern": "^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$"
},
"sourceSha256": {
"type": "string",
"pattern": "^[a-f0-9]{64}$"
},
"fingerprint": {
"type": "string",
"pattern": "^[a-f0-9]{64}$"
},
"values": {
"maxItems": 100,
"type": "array",
"items": {
"type": "object",
"properties": {
"name": {
"type": "string",
"maxLength": 64
},
"required": {
"type": "boolean"
},
"kind": {
"anyOf": [
{
"type": "string",
"enum": [
"text",
"selection",
"metric",
"formula",
"table",
"chart"
]
},
{
"type": "null"
}
]
},
"text": {
"type": "string"
},
"status": {
"type": "string",
"enum": [
"resolved",
"missing",
"unavailable"
]
},
"reason": {
"type": [
"string",
"null"
]
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {
"type": "string"
}
}
},
"chart": {
"type": "array",
"items": {
"type": "object",
"properties": {
"label": {
"type": "string"
},
"value": {
"type": "number"
}
},
"required": [
"label",
"value"
]
}
}
},
"required": [
"name",
"required",
"kind",
"text",
"status",
"reason"
]
}
},
"blocking": {
"type": "array",
"items": {
"type": "string"
}
},
"warnings": {
"type": "array",
"items": {
"type": "string"
}
}
},
"required": [
"datasetId",
"sourceSha256",
"fingerprint",
"values",
"blocking",
"warnings"
]
}Errors and safe retries
Check the HTTP status and response body. A 400 validation error may contain a ZodError; handler errors use error, message and code fields. Keep request_id or x-request-id for diagnosis, without credentials. Fix 401/403 access errors before retrying, and follow Retry-After for 429. If a write is uncertain or returns 5xx, read the existing result first. Reuse an idempotency key only where supported; retry behaviour varies by operation and does not guarantee exactly-once delivery.
Troubleshooting guideExamples
These examples use fictional values checked against the schemas. Replace the IDs with ones you are authorized to use, the media with ready assets and the dates with your confirmed publishing time. Check the account’s eligibility before submitting a write. This page sends no API requests.
Set SOSOAPI_ACCESS_TOKEN on your server to a credential accepted by this operation, and keep it out of browser code. For an agent, use sosoapi auth login to sign in through the browser and let the CLI refresh its credentials.
request.json
{
"workspace_id": "11111111-1111-4111-8111-111111111111",
"id": "11111111-1111-4111-8111-111111111111",
"version": 1,
"dataset": {
"contractVersion": "analytics-report/v1",
"id": "11111111-1111-4111-8111-111111111111",
"reviewedAt": "2099-01-15T09:00:00Z",
"selection": {
"workspaceId": "11111111-1111-4111-8111-111111111111",
"accountIds": [
"11111111-1111-4111-8111-111111111111"
],
"platforms": [
"facebook"
],
"startDate": "2099-01-15",
"endDate": "2099-01-15",
"timezone": "UTC"
},
"accounts": [
{
"id": "11111111-1111-4111-8111-111111111111",
"workspaceId": "11111111-1111-4111-8111-111111111111",
"platform": "facebook",
"name": "Fictional report account"
}
],
"posts": [],
"sources": [],
"coverage": {
"population": "discovered_posts",
"postsComplete": false,
"nextCursor": null,
"postLimit": 0,
"postInsightsLimit": 0,
"omittedPostInsights": 0,
"notes": []
},
"customMetrics": []
}
}cURL
curl --request POST \
"https://gqeshlawtcexsapabaui.supabase.co/functions/v1/analytics-api/reporting/templates/preview" \
-H "Authorization: Bearer $SOSOAPI_ACCESS_TOKEN" \
-H "Content-Type: application/json" \
--data-binary @request.jsonJavaScript
// Server-side JavaScript. Do not print tokens or credential-bearing responses.
const token = process.env.SOSOAPI_ACCESS_TOKEN;
if (!token) throw new Error("Set an accepted credential for this operation");
const response = await fetch("https://gqeshlawtcexsapabaui.supabase.co/functions/v1/analytics-api/reporting/templates/preview", {
method: "POST",
headers: { "Content-Type": "application/json", Authorization: "Bearer " + token },
body: JSON.stringify({
"workspace_id": "11111111-1111-4111-8111-111111111111",
"id": "11111111-1111-4111-8111-111111111111",
"version": 1,
"dataset": {
"contractVersion": "analytics-report/v1",
"id": "11111111-1111-4111-8111-111111111111",
"reviewedAt": "2099-01-15T09:00:00Z",
"selection": {
"workspaceId": "11111111-1111-4111-8111-111111111111",
"accountIds": [
"11111111-1111-4111-8111-111111111111"
],
"platforms": [
"facebook"
],
"startDate": "2099-01-15",
"endDate": "2099-01-15",
"timezone": "UTC"
},
"accounts": [
{
"id": "11111111-1111-4111-8111-111111111111",
"workspaceId": "11111111-1111-4111-8111-111111111111",
"platform": "facebook",
"name": "Fictional report account"
}
],
"posts": [],
"sources": [],
"coverage": {
"population": "discovered_posts",
"postsComplete": false,
"nextCursor": null,
"postLimit": 0,
"postInsightsLimit": 0,
"omittedPostInsights": 0,
"notes": []
},
"customMetrics": []
}
})
});
const result = await response.json();
// Check response.ok, the operation-specific body and completion state before continuing.CLI
npx sosoapi api post /analytics-api/reporting/templates/preview < request.jsonSynthetic response example
{
"datasetId": "11111111-1111-4111-8111-111111111111",
"sourceSha256": "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa",
"fingerprint": "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa",
"values": [],
"blocking": [],
"warnings": []
}