Caspio

Retrieve all tables in a Caspio application so the agent knows exactly what data structures are available before querying.

Fetch the field definitions for a specific Caspio table, returning names, data types, and constraints the agent needs before writing or validating data.

Add a new record to any Caspio table, letting the agent populate your cloud database from any upstream event without opening the Caspio GUI.

Modify an existing record in a Caspio table by its primary key, allowing the agent to keep data current as real-world events unfold downstream.

Permanently remove a record from a Caspio table by its key, useful for purging test data, enforcing retention policies, or responding to GDPR deletion requests.

Query rows from a Caspio table with optional WHERE filters, pagination, and field selection — the core read the agent uses to extract data for reports, decisions, and downstream writes.

Fetch a single Caspio table record by its primary key for fast point lookups when the agent already knows the exact record to retrieve.

Execute a pre-built Caspio saved query by name and return its result set, giving the agent access to complex multi-table SQL logic without rewriting it from scratch.

Return all views defined in a Caspio application, letting the agent discover pre-joined or filtered data perspectives without touching raw tables.

Query rows from a Caspio view with filter and pagination support, letting the agent work with pre-joined, denormalised data without constructing complex table joins.

Enumerate all Caspio web forms in an application so the agent can discover available data-entry surfaces and route submissions to the correct downstream workflow.

Programmatically submit a Caspio web form with field values, triggering all server-side actions, workflows, and validation rules the form defines — not a raw table insert.

Download or retrieve metadata for a file stored in Caspio's managed file storage using its path, giving the agent access to uploaded attachments for processing or forwarding.

Store a file in Caspio's managed file library and receive its path reference, so the agent can persist attachments from any source directly into the platform's storage.

Return the list of users registered to a Caspio application, including their roles and status, so the agent can enforce access policies or personalise outreach.

Create a new user account in a Caspio application with a specified role, so the agent can provision access automatically as part of onboarding or permission workflows.

Programmatically create a new table in a Caspio application with specified fields and data types, letting the agent extend the database schema as part of a provisioning workflow.

Retrieve usage and performance statistics for a Caspio application — page views, form submissions, record counts — so the agent can surface health metrics without logging into the Caspio GUI.

Fires when a new row is added to a specified Caspio table, whether via form submission, API call, or direct import.

Fires when any field on an existing Caspio table row changes, scoped to a specific table; can be filtered to watch a target column like status or stage.

Fires when a record is removed from a Caspio table, enabling the agent to cascade deletions or audit removals in downstream systems immediately.

Fires each time a Caspio web form is submitted, carrying the field values so the agent can act on the structured data before it even touches the underlying table.

Fires when a file is uploaded to Caspio's managed file library, delivering the file path and metadata so the agent can process, route, or archive the attachment immediately.

Fires when a new user account is created in a Caspio application, letting the agent trigger onboarding sequences, access provisioning, or welcome communications immediately.

Fires when a Caspio application is published or redeployed, so the agent can announce releases, run smoke tests, or update linked documentation automatically.