Docs

findTableRows

Enables the search and filtering of rows within a table based on specific criteria. This operation supports complex queries for advanced data manipulation and retrieval.

POST/v1/tables/{table}/rows/find

Authorization

AuthorizationBearerrequired
Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Header parameters

x-bot-idstringrequired
Bot id
x-integration-idstring
Integration id
x-integration-aliasstring
Integration alias
x-integration-namestring
Integration name
x-user-idstring
User Id
x-user-rolestring
User Role

Path parameters

tablestringrequired
The table's name or unique identifier for targeting specific table operations.

Request body

The search criteria and filters to apply when searching for rows. This includes conditions, search terms, and pagination options.

limitintegerdefault: 100
Limit for pagination, specifying the maximum number of rows to return.(>= 1, <= 1000)
offsetintegerdefault: 0
Offset for pagination, specifying where to start returning rows from.(>= 0)
filterobject
Provide a mongodb-like filter to apply to the query. Example: \{ "name": \{ "$eq": "John" \} \}
groupobject
Group the rows by a specific column and apply aggregations to them. Allowed values: key, avg, max, min, sum, count. Example: \{ "someId": "key", "orders": ["sum", "avg"] \}
searchstring
Search term to apply to the row search. When using this parameter, some rows which doesn't match the search term will be returned, use the similarity field to know how much the row matches the search term. (max length: 1024)
selectstring[]
Specify which columns to return in the response. Supports both top-level columns (e.g., "name") and nested attributes using dot notation (e.g., "attributes.price"). System columns (id, createdAt, updatedAt, etc.) are always included. If omitted, all columns are returned.
orderBystringdefault: "id"
Specifies the column by which to order the results. By default it is ordered by id. Build-in columns: id, createdAt, updatedAt
orderDirectionenum<string>default: "asc"
Specifies the direction of sorting, either ascending or descending.
Available options:"asc","desc"

Response

A collection of rows that match the search criteria, along with metadata such as total count and pagination details.

rowsobject[]required
hasMorebooleanrequired
Flag indicating if there are more rows to fetch.
offsetintegerrequired
limitintegerrequired
warningsstring[]
Alerts for minor issues that don't block the operation but suggest possible improvements.