Need help with your APIs? I offer API discovery, governance & evangelism services. Explore services →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Caspio Tables API

Table schema and record operations

Caspio Tables API is one of 8 APIs that Caspio publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

Tagged areas include Tables. The published artifact set on APIs.io includes an OpenAPI specification.

This API exposes 7 operations across 4 paths, and defines 1 schema. It is described by OpenAPI 3.1.0, at version 3.0.0.

Requests are made against a single base URL, https://{account}.caspio.com/rest/v3.

7 operations 4 paths 1 schemas 1 DELETE4 GET1 POST1 PUT

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.1.0
API Version
3.0.0
Base URL
https://{account}.caspio.com/rest/v3
Authentication
HTTP Bearer
Contact
Resource Areas
1

Authentication & Security 1

Caspio Tables API declares 1 security scheme for authenticating requests. It accepts HTTP bearer tokens (JWT) (bearerAuth). By default, every request must be authenticated.

Paths & Operations 7

Across 4 paths, the API surfaces 7 operations — 1 DELETE, 4 GET, 1 POST, 1 PUT. Each is listed below with its method, path, parameters, and response codes.

Tables 7

Table schema and record operations

GET
/tables
List all tables in the account
listTables → 200
GET
/tables/{tableName}
Get a table's metadata
getTable 1 param → 200
GET
/tables/{tableName}/fields
List fields (columns) for a table
listTableFields 1 param → 200
GET
/tables/{tableName}/records
Query table records
queryTableRecords 8 params → 200
POST
/tables/{tableName}/records
Insert one record into a table
insertTableRecord 2 params body → 201
PUT
/tables/{tableName}/records
Update table records matching a where clause
updateTableRecords 2 params body → 200
DELETE
/tables/{tableName}/records
Delete table records matching a where clause
deleteTableRecords 2 params → 200

Schemas 1

The contract defines 1 schema that model the data the API accepts and returns. The most detailed is RecordsPage (1 property). Each schema is shown below with its type and property counts.

RecordsPage
object
1 property

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

caspio-tables-api-openapi.yml Raw ↑

Other APIs Caspio publishes across the network.

Caspio REST API
Caspio Applications API
Caspio Authentication API
Caspio Files API
Caspio Tasks API
Caspio Users API
Caspio Views API