Search a data table’s rows
Reads a table’s rows — oldest first — narrowed by exact column values (filters) or by a substring over its text columns (query). Returns each row’s id, which is the handle tabelle_update_row and tabelle_delete_row take, together with its cells keyed by column key. Paged: continue with cursor from next_cursor rather than raising limit.
Examples
- Cerca Rossi tra i fornitori GET /api/v1/rest/tabelle/tables/fornitori/rows?query=rossi
- Which supplier has this VAT number? GET /api/v1/rest/tabelle/tables/fornitori/rows?filters=%7B%22piva%22%3A%22IT01234567890%22%7D
- List every supplier we have GET /api/v1/rest/tabelle/tables/fornitori/rows?limit=100
Request
- Base URL: https://api.custodo.ai
- URL: https://api.custodo.ai/api/v1/rest/tabelle/tables/{table}/rows
- Auth: HTTP bearer
Path parameters
The table: its key (e.g. fornitori) or its id. Both are returned by tabelle_list_tables. A retired table still resolves.
Query parameters
Exact match, column key → value, ANDed. Write every value as text whatever the column’s declared type is ("5000", "true", "2026-12-31"): it is coerced to that type before the query. A column the table does not declare is refused and the answer lists the ones it has.
Case-insensitive substring, matched against every text column of the table. Use it when you know part of a name; use filters when you know a value exactly.
Rows to return, 1–100. Default 20.
Opaque cursor from a previous call’s nextCursor, to continue.
concise (default) returns the fields you need to answer a question; detailed adds related records and costs more context.
Headers
The organisation to act in. An API key is bound to exactly one, so this is optional for a key and must match the one it was minted for.
Response
Done. data is the tool’s answer, as described here. Its objects may carry fields this description does not name yet: read the ones you need and ignore the rest.
Changes
No recorded changes to this operation across all 1 revision of this API.