DataTables

Lists rows in a data table with optional filtering, sorting, and pagination.

Changed on
get/datatables/{tableId}/rows

Request

Path parameters

tableIdstring required

The data table ID.

Query parameters

filterstring

Optional JSON filter. Equality shortcut {"col":"value"} or operator form {"col":{"op":"gte","value":25}}. Operators: eq, neq, contains, notContains, gt, gte, lt, lte, inRange, outOfRange, in, notIn, isEmpty, isNotEmpty, positive, negative, beforeNow, afterNow, isToday. Use a top-level $or array for disjunction.

sortstring

Optional column key to sort by.

sortDirstring

Sort direction: asc (default) or desc.

pageSizeinteger

Maximum number of rows to return per page (default 50).

continuationTokenstring

Opaque token from a prior response used to fetch the next page. Omit for the first page.

fieldsstring

Optional comma-separated list of column keys to return; omit to return all columns.

timeZonestring

Optional Windows or IANA time zone id used to evaluate the relative date operators (isToday, beforeNow, afterNow). Defaults to the account's time zone.

Response

OK

totalCountinteger
continuationTokenstring nullable

Changes