Update Analytics Data Source

A name for the source. Left out, one is written from what it fetches.

What the data holds, in a sentence. Left out, one is written from the data.

The app to fetch from, by id or slug, from List Universal Apps.

The app's read action, by id or slug, from List Universal Actions.

The connection to fetch with, from List Connections.

The action's arguments, { argumentKey: value }, as Get Universal Action lists them. Values may use date expressions such as {{now-2y}}.

The action's options, such as { "pagination": { "mode": "all" } }.

A filter and sort the app applies before the rows are stored. The action must support them exactly, or the request is refused.

• filterany

  The filter the app applies, as Get Universal Action describes it. Values must be literals.

• sortany

  The sort the app applies.

For a merge source: the sources it combines.

• dataSourceIdstringrequired

  The input source, a sync or fixed source of yours, from List Analytics Data Sources.

• aliasstringrequired

  The name the merge SQL and code read this input by.

• querystring

  SQL that shapes this input before the merge, reading it as `src`. Leave it out to use the input as is.

For a merge source: JavaScript that receives each input by its alias and returns the combined rows. Required when there is more than one input.

For a fixed source: the rows, as objects with the same keys, up to 1000. They replace the source's data.

Which columns hold dates, for page date filters. Left out (or null on update), they are worked out from the data after each refresh.

• primaryDateKeystring

  The column page date filters use.

• primaryDateKeyGrainstring

  That column's grain, such as day or month.

• createdDateKeystring

  The column holding when each record was created.

• updatedDateKeystring

  The column holding when each record last changed.

• hasNoDatesboolean

  True when the source has no date column.

For a fixed source made from a spreadsheet file: the sheet to read.

For a fixed source made from a spreadsheet file: whether its first row holds the column names.

For a fixed source made from a spreadsheet file: how many rows above the header to skip.

How often a sync or merge source refreshes in full, in seconds, up to 604800. A source that takes long to fetch may be held to a longer interval; the answer says what was set.

For a sync source: switch incremental refreshes on or off. On needs incremental details whose status is active, saved now or before.

For a sync source: how often incremental refreshes run, in seconds. Held between the shortest and longest the app allows, and shorter than the full refresh.

How this sync source fetches only changed records. Setting status active checks the dedupKey and sinceArguments against the stored rows and the app first, and saves nothing if they fail.

• statusstring

  Whether this source can fetch only changed records: active or unavailable.

  • activeThis source can fetch only changed records.
  • unavailableIt cannot.
• dedupKeyarray of strings

  The field paths that identify a record, such as ["id"].

• sinceArgumentsobject

  The extra action arguments that ask the app for records changed since the last check, keyed like the source's arguments, such as { "updatedAfter": "{{since}}" }.

• catchesstring

  What the change check finds: newAndChanged or newOnly. Left out, it is measured.

  • newAndChangedThe check finds new and edited records.
  • newOnlyIt finds new records only.
• overlapSecondsnumber

  How far back before the last check each check looks, in seconds: one of 300, 900, 1800, 3600, 7200, 21600.

Only after a 409 ANALYTICS_EMBED_CONFIRMATION_REQUIRED for the same request: the confirmationReceipt from its error.details, confirming the change to the published embeds it lists.