discover_tables
Discovers tables in the Caspio account along with their field schemas in a single call. Tables are the primary data storage objects in Caspio (similar to database tables); table names are customer-defined and reflect their specific use case (e.g., Patients, ParkingPermits, Inventory_Items). Returns each matching table's id (required by query_table, insert_table_record, update_table_records, delete_table_records, and get_attachment_metadata), name, and field definitions. Each field includes: name (the identifier used in all queries), dataType, label (optional friendly display name), unique, editable (false for auto-generated fields like Autonumber, Timestamp, GUID, Random ID, and Formula -- do not include these in insert or update payloads), and description. Caspio API data types: STRING (short text, max 255 chars), TEXT (long text, max 64K chars), NUMBER (decimal), INTEGER (whole number), CURRENCY, DATE/TIME, YES/NO (boolean -- use 1 for true and 0 for false in queries), FILE (legacy, referenced separate file object), ATTACHMENT, LIST-STRING / LIST-NUMBER / LIST-DATE/TIME, PASSWORD, TIMESTAMP, RANDOM ID, AUTONUMBER, PREFIXED AUTONUMBER, GUID. Use field name (never label) in SELECT, WHERE, ORDER BY, and GROUP BY clauses. Use nameFilter to search for a specific table, or omit it to list all tables.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| pageSize | No | Number of results per page (default = 25) | |
| nameFilter | No | Filter tables by name (case-insensitive, partial match). Omit to list all tables. | |
| pageNumber | No | Page number (default = 1) | |
| includeTriggeredActions | No | Include each table's triggered-action definitions in the response (default = false). Set to true to include this extra data when needed. |