DataTable

Query rows in a data table

Queries rows in this data table.

get/v1/projects/{project_id}/tables/{id}/rows

Request

  • Base URL: https://api.telerivet.com
  • URL: https://api.telerivet.com/v1/projects/{project_id}/tables/{id}/rows
  • Auth: one of:
    • HTTP basic
    • OAuth 2 (authorization code, authorization URL https://telerivet.com/oauth/authorize, token URL https://api.telerivet.com/oauth/token)

Path parameters

project_idstring required

ID of the Project

idstring required

ID of the DataTable

Query parameters

time_createdinteger

Unix timestamp in seconds

Filter data rows by the time they were created

contact_idstring

ID of Contact

Filter data rows associated with a particular contact

varsobject

Filter data rows by value of a custom variable (e.g. vars[q1], vars[foo], etc.)

sort'default'

Sort the results based on a field

sort_dir'asc' | 'desc'

Sort the results in ascending or descending order

page_sizeinteger

Number of results returned per page (max 500)

offsetinteger

Number of items to skip from beginning of result set

markerstring

'next_marker' property returned by a previous call to this API method, indicating where the next page of results should start.

countboolean

If true, the API will return the count of items matching the filter, instead of the items themselves

Response

Successful response. When count=1 parameter is provided, returns {"count": N} instead.

truncatedboolean

True if there are more results

next_markerstring

Marker for pagination

page_sizeinteger

Number of results per page

sort_dir'asc' | 'desc'

Sort direction

countinteger

Total count of matching items (only when count=1 parameter is provided)

Example response

{
  "data": [
    {
      "id": "DRd442e170d6133590",
      "contact_id": "CTa1299c3d0e371023",
      "from_number": "+16505550123",
      "time_created": 1395102559,
      "time_updated": 1395102578,
      "table_id": "DTf9f77c9ba69cce50",
      "project_id": "PJ2ad0100821a98bea"
    }
  ]
}

Changes

No recorded changes to this operation across all 1 revision of this API.