Lists rows in a data table with optional filtering, sorting, and pagination.
Changed onRequest
- Base URLhttps://api.reveldigital.com
- Auth
- OAuth 2Authorization codehttps://id.reveldigital.com/connect/authorizeToken URLhttps://id.reveldigital.com/connect/tokenScopeswebapi
- or API key in header X-RevelDigital-ApiKey
- or API key in query parameter api_key
- TypeScriptA function with typed inputs. Its response is checked against the schema.
Path parameters
The data table ID.
Query parameters
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.
Optional column key to sort by.
Sort direction: asc (default) or desc.
Maximum number of rows to return per page (default 50).
Opaque token from a prior response used to fetch the next page. Omit for the first page.
Optional comma-separated list of column keys to return; omit to return all columns.
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
Changes
- info
added the new optional
queryrequest parametertimeZone
- info