The TimeTonic API allows you to retrieve rows from a table by filtering them directly in the request. To do this, you use the getTableValues function with the filterRowIds parameter (also called filtered rows).
Visit the API documentation page here.

Method 1: Reuse an already filtered view

The simplest way is to point to an existing TimeTonic view whose filters are already configured. In filterRowIds, pass the view's ID as the value of applyViewFilters:

{ "applyViewFilters": 12345 }

• When I open a record in TimeTonic, the URL contains the view ID

Method 2: Define your own filter (filterGroup)

If you don't want to rely on a view, pass a filterGroup object in applyViewFilters.

A filterGroup contains an operator (and or or) and a list of filters. Each filter targets a column (field_id) with a predicate and a value (operand).

Example: retrieve rows where column 1735324 (of type date) is after May 1, 2020.

{
  "applyViewFilters": {
    "filterGroup": {
      "operator": "and",
      "filters": [
        {
          "id": "tmpId",
          "field_id": "1735324",
          "filter_type": "date",
          "json": { "predicate": "after", "operand": "2020-05-01" }
        }
      ]
    }
  }
}

Method 3: Combine AND and OR (nested groups)

A filter can itself be a filterGroup: give it filter_type: "filterGroup" and its own operator. This allows you to combine AND and OR conditions at multiple levels.

Example: retrieve rows where (column 5555 equals 3654) AND (column 12345 equals 789 OR 543) AND (column 3214 is on or after a date).

{
  "applyViewFilters": {
    "filterGroup": {
      "operator": "and",
      "filters": [
        {
          "id": "tmpId",
          "field_id": 5555,
          "filter_type": "int",
          "json": { "predicate": "equals", "operand": 3654 }
        },
        {
          "filter_type": "filterGroup",
          "operator": "or",
          "filters": [
            { "id": "tmpId", "field_id": 12345, "json": { "predicate": "is", "operand": "789" } },
            { "id": "tmpId", "field_id": 12345, "json": { "predicate": "is", "operand": "543" } }
          ]
        },
        {
          "id": "tmpId",
          "field_id": 3214,
          "filter_type": "date",
          "json": { "predicate": "on or after", "operand": "2026-01-01" }
        }
      ]
    }
  }
}

The root group applies the and operator to its three elements. The second element is itself a group with the or operator: its two conditions are alternatives. This nesting can be repeated to build more refined logic.

Reference: operators and predicates

An operator links the filters of a group. A predicate defines the condition applied to a column, according to its type.

Column type and filter_type

The filter_type to specify depends on the type of the targeted TimeTonic column:

Predicates by family

The applicable predicate depends on the filter_type of the targeted column. Click a predicate to copy it, then paste it into the predicate key of your filter.