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.
Bearer authentication header of the form Bearer <token>
, where <token>
is your auth token.
Your bot ID.
The table's name or unique identifier for targeting specific table operations.
The search criteria and filters to apply when searching for rows. This includes conditions, search terms, and pagination options.
Limit for pagination, specifying the maximum number of rows to return.
1 <= x <= 1000
Offset for pagination, specifying where to start returning rows from.
x >= 0
Provide a mongodb-like filter to apply to the query. Example: { "name": { "$eq": "John" } }
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"] }
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.
1024
Specifies the column by which to order the results. By default it is ordered by id. Build-in columns: id, createdAt, updatedAt
Specifies the direction of sorting, either ascending or descending.
asc
, desc
A collection of rows that match the search criteria, along with metadata such as total count and pagination details.