Get Analytics Data Source Table

Read one of the creator's fixed sources as a table: its columns with their types, a window of its rows in order (each keyed by column; a row's index is offset plus its place), and the revision, also in the ETag header. Change some of it with Update Analytics Data Source Table, which counts rows by that index.

GET

Path

Path parameters

stringrequired

The fixed source's id, from List Analytics Data Sources.

Headers

Optional headers

string

Optional. The id of the organization to act in. Leave it out to act in the API key's own organization. Here a key acts in another organization only as one of its members: with "Use this key across all of your organizations" on, in an organization its creator belongs to with a role. Child organizations and MindCloud staff access do not reach this endpoint. Every response's X-Company-Id header names the organization it acted in. See Organizations.

Query

Arguments

number

How many rows to answer, 1-1000.

How many rows to answer, 1-1000. Defaults to 100.

Default: 100

number

How many rows to skip.

How many rows to skip. Defaults to 0.

Default: 0

Response fields

idstring

The data source's id.

revisionstring

The table as read, also in the ETag header. Send it in If-Match to Update Analytics Data Source Table; an update to a table changed since is refused.

columnTypesarray of objects

Every column, in order, with its stored type.

keystring
The column's key.
typestring
The column's stored type, such as VARCHAR, BIGINT or DATE.

columnsarray of string

The column names the rows carry, in order.

rowsarray of objects

The rows in this window, as objects keyed by column.

rowCountnumber

How many rows there are in all.

offsetnumber

Where this window starts.

nextOffsetnumber

The offset of the next window, or null when this is the last.