Caspio REST API

Name: Caspio REST API
Brand: Caspio REST API
Availability: InStock

★ Only Publicly Available OpenAPI DocumentStorageDatabaseoauth221 EndpointsREST

For Agents

Read and write records in Caspio cloud database tables, query views, manage table schema fields, and upload files into a Caspio account.

Install Jentic One Beta

Connect the Caspio REST API to your agent

Jentic One is a self-hosted execution layer for AI agents. It lets your agent call the Caspio REST API, or any other public or private API you need. You set the rules, the agent never sees your credentials, and every call is logged.

Two steps, two machines. Install the instance in a safe environment, then register your agent from wherever it runs.

Step 1: Jentic One Host machine

# On the machine that will host your Jentic One instance:
curl -fsSL https://raw.githubusercontent.com/jentic/jentic-one/main/tools/install.sh | sh

Step 2: Agent machine

# On the machine where your agent runs (keep this separate from the instance):
curl -fsSL https://raw.githubusercontent.com/jentic/jentic-one/main/tools/install.sh | sh
jentic register       # connects your agent to your Jentic One instance

Jentic One is in public beta. The setup above keeps your agent separate from the instance, which is what you want before using real credentials: an agent running as the same OS user as Jentic One can read its stored keys directly. Just evaluating? A single local install is fine to start. See the secure deployment guide for the tiers.

Capabilities

What an agent can do with Caspio REST API.

List Caspio tables and inspect their column definitions

Insert, query, update, and delete records inside a named Caspio table

Add, modify, and remove individual fields on a Caspio table schema

GET STARTED

Start building with Caspio REST API

Explore with Jentic

View OpenAPI Document

Jentic publishes the only available OpenAPI specification for Caspio REST API, keeping it validated and agent-ready. Caspio is a low-code cloud database platform and the REST API exposes the underlying tables, views, files, and applications so that external systems can read and write data programmatically. The API supports listing and editing table schemas, inserting and querying records with WHERE-style filters, browsing read-only views, uploading and managing files in the Caspio file space, and discovering DataPages inside Caspio applications. It is used to embed Caspio data into custom apps, agents, and integration pipelines that sit alongside a Caspio-built portal.

Use Cases

Patterns agents use Caspio REST API for, with concrete tasks.

★ Sync external system data into Caspio

Use POST /tables/{tableName}/records to push rows from a CRM, ERP, or spreadsheet into a Caspio table that already powers an internal portal. The schema endpoints let you confirm the table exists with the expected columns before inserting, avoiding silent type mismatches at write time.

POST a JSON record body with Name, Email, and Status fields to /tables/Customers/records and confirm the response contains the new row count.

Query Caspio data for a custom dashboard

Frontends or BI dashboards can call GET /tables/{tableName}/records or GET /views/{viewName}/records with filter and pagination parameters to retrieve current Caspio data without going through a DataPage. This is useful when teams want native React or mobile UIs on top of a Caspio-managed dataset.

GET /views/OpenTickets/records with a where filter on assigned_to equal to the current agent id and return the first 50 rows.

Schema management for low-code apps

Operations teams can extend a Caspio table by adding fields via POST /tables/{tableName}/fields or relax a field type with PUT /tables/{tableName}/fields/{fieldName}. This supports controlled schema evolution from CI scripts rather than ad-hoc edits in the Caspio UI.

POST a new field definition named 'priority' with type Number to /tables/Tickets/fields and verify it appears in the field list.

AI agent low-code data integration via Jentic

An AI agent embedded in a Caspio-driven business app can fetch records, insert new ones, and upload supporting files using Jentic's intent search. The Caspio OAuth2 client credentials live in the Jentic vault, so the agent never holds the long-lived token.

Search Jentic for 'insert a record into a Caspio table', load POST /tables/{tableName}/records, and execute it with the table name and the agent's structured payload.

Key Endpoints

21 endpoints — jentic publishes the only available openapi specification for caspio rest api, keeping it validated and agent-ready.

METHOD

PATH

DESCRIPTION

GET

/tables

List all tables in the account

GET

/tables/{tableName}/records

Query records from a table

POST

/tables/{tableName}/records

Insert one or more records

PUT

/tables/{tableName}/records

Update records matching a filter

GET

/views/{viewName}/records

Query records from a view

PUT

/files/{path}

Upload a file to a Caspio folder

GET

/applications

List Caspio applications

GET

/tables

List all tables in the account

GET

/tables/{tableName}/records

Query records from a table

POST

/tables/{tableName}/records

Insert one or more records

PUT

/tables/{tableName}/records

Update records matching a filter

GET

/views/{viewName}/records

Query records from a view

Why Jentic?

Three things that make agents converge on Jentic-routed access.

Credential isolation

Caspio OAuth 2.0 client credentials are stored encrypted in the Jentic vault (MAXsystem). Jentic runs the token exchange server-side and injects the resulting bearer token at execution time, so the client secret never enters the agent's prompt or logs.

Intent-based discovery

Agents search by intent (e.g., 'insert a Caspio record' or 'query a Caspio view') and Jentic returns the matching operation along with its parameter and body schema, so the agent does not need to learn the {accountId} URL pattern manually.

Time to first call

Direct Caspio integration with OAuth client credentials, token caching, and per-account base URL handling: 2-3 days. Through Jentic: under 1 hour — search, load, execute.

FAQs

Specific to using Caspio REST API through Jentic.

Why is there no official OpenAPI spec for Caspio REST API?

Caspio publishes documentation but no machine-readable OpenAPI specification. Jentic generates and maintains this spec so that AI agents and developers can call Caspio REST API via structured tooling. It is validated against the live API and kept up to date. Get started at https://app.jentic.com/sign-up.

What authentication does the Caspio REST API use?

The Caspio REST API uses OAuth 2.0 with the client credentials flow. You exchange a client id and secret at https://{accountId}.caspio.com/oauth/token for a bearer access token, then send it as Authorization: Bearer in subsequent requests. Through Jentic, the client credentials are held in the MAXsystem vault and the token exchange happens server-side.

Can I update existing records with the Caspio REST API?

Yes. PUT /tables/{tableName}/records updates records that match the supplied where filter, and DELETE /tables/{tableName}/records deletes records that match a filter. Both operations apply to all matching rows, so include a precise filter to avoid bulk updates.

What are the rate limits for the Caspio REST API?

Caspio limits API calls based on your plan; the OpenAPI spec does not encode hard numeric limits. Check your account's API quota in the Caspio console at howto.caspio.com and batch record operations into a single insert or update payload where possible.

How do I query a Caspio view through Jentic?

Run pip install jentic, search Jentic with the query 'get records from a Caspio view', load the GET /views/{viewName}/records schema, and execute it with the view name and any where, select, or limit parameters. Jentic injects the Caspio OAuth token at execution time.

Can I upload files to Caspio through this API?

Yes. PUT /files/{path} uploads a file to the specified folder path within your Caspio file space, and GET /files lists files and folders. This is useful for storing attachments referenced by table records.

Caspio REST API

Connect the Caspio REST API to your agent

Capabilities

Start building with Caspio REST API

Use Cases

Key Endpoints

Why Jentic?

Related APIs

FAQs