discover_views
Discovers views in the Caspio account along with their field schemas in a single call. Views are predefined data sources that can filter a single table or join multiple tables; view names are customer-defined. Tables are the primary data objects in Caspio; use views when the user's request aligns with an existing view or when the needed data spans multiple tables. Returns each matching view's id (required by query_view, insert_view_record, update_view_records, and delete_view_records), name, and field definitions. Each field includes: name (the identifier to use in queries), tableFieldName (the source table and field in Table.Field format, revealing which underlying table each field comes from), dataType, label, unique, editable (false for auto-generated fields and for fields from non-primary joined tables in multi-table views), and description. Data types are the same as table fields: STRING, TEXT, NUMBER, INTEGER, CURRENCY, DATE/TIME, YES/NO (boolean -- use 1 for true and 0 for false in queries), FILE (legacy), ATTACHMENT, LIST-STRING / LIST-NUMBER / LIST-DATE/TIME, PASSWORD, TIMESTAMP, RANDOM ID, AUTONUMBER, PREFIXED AUTONUMBER, GUID. Use field name (never label or tableFieldName) in SELECT, WHERE, ORDER BY, and GROUP BY clauses. Use nameFilter to search for a specific view, or omit it to list all views.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| pageSize | No | Number of results per page (default = 25) | |
| nameFilter | No | Filter views by name (case-insensitive, partial match). Omit to list all views. | |
| pageNumber | No | Page number (default = 1) | |
| includeTriggeredActions | No | Include each view's triggered-action (workflow) definitions in the response (default = false). Set to true to include this extra data when needed. |