Caspio

Return all table names in the Caspio account (GET /tables)

Get a table's definition / metadata (GET /tables/{tableName})

Update (design) the table structure (PUT /tables/{tableName})

List field definitions for a table (GET /tables/{tableName}/fields)

Get a single field's properties (GET /tables/{tableName}/fields/{fieldName})

Add a field to a table (POST /tables/{tableName}/fields)

Update a field definition (PUT /tables/{tableName}/fields/{fieldName})

Remove a field from a table (DELETE /tables/{tableName}/fields/{fieldName})

Password-typed field helper read (GET /tables/{tableName}/passwordFields/{fieldName})

Set/reset a password field value (PUT /tables/{tableName}/passwordFields/{fieldName})

Query records from a table with filtering and pagination (GET /tables/{tableName}/records)

Insert one record into a table (POST /tables/{tableName}/records)

Update records matching a WHERE clause; returns RecordsAffected (PUT /tables/{tableName}/records)

Delete records matching a WHERE clause; returns RecordsAffected (DELETE /tables/{tableName}/records)

List directories (user-authentication containers) (GET /directories)

Create a directory (POST /directories)

Get a directory (GET /directories/{dirId})

Update a directory (PUT /directories/{dirId})

Delete a directory (DELETE /directories/{dirId})

List users in a directory (GET /directories/{dirId}/users)

Create a user in a directory (POST /directories/{dirId}/users)

Get a user (GET /directories/{dirId}/users/{userId})

Update a user (PUT /directories/{dirId}/users/{userId})

Delete a user (DELETE /directories/{dirId}/users/{userId})

List configured outgoing webhooks (GET /outgoingWebhooks)

Create an outgoing webhook (destination URL, payload template) (POST /outgoingWebhooks)

Get a webhook (GET /outgoingWebhooks/{webhookId})

Update a webhook; single Enabled property toggles status + events (PUT /outgoingWebhooks/{webhookId})

Delete a webhook (DELETE /outgoingWebhooks/{webhookId})

List events bound to a webhook (GET /outgoingWebhooks/{webhookId}/events)

Bind an event (_table.recordInsert / recordUpdate / recordDelete) to a webhook (POST /outgoingWebhooks/{webhookId}/events)

Get an event (GET /outgoingWebhooks/{webhookId}/events/{eventId})

Update an event (PUT /outgoingWebhooks/{webhookId}/events/{eventId})

Delete an event (DELETE /outgoingWebhooks/{webhookId}/events/{eventId})

List files; pass externalKey to scope to a folder (GET /files)

List folders (GET /files/folders)

Download a file by its ExternalKey (GET /files/{externalKey})

Upload a file via multipart/form-data; pass externalKey for destination folder (POST /files)

Replace/update an existing file (PUT /files/{externalKey})

Delete a file by ExternalKey (DELETE /files/{externalKey})

List all view names (GET /views)

List fields exposed by a view (GET /views/{viewName}/fields)

Query view records (same query params as table records) (GET /views/{viewName}/records)

Insert through a view (writes to underlying table) (POST /views/{viewName}/records)

Update view records matching a WHERE clause (PUT /views/{viewName}/records)

Delete view records matching a WHERE clause (DELETE /views/{viewName}/records)

List bridge applications (GET /bridgeApplications)

Get a single app's metadata (GET /bridgeApplications/{externalKey})

List DataPages in an app (GET /bridgeApplications/{externalKey}/datapages)

Get DataPage metadata + deploy status (GET /bridgeApplications/{externalKey}/datapages/{dpKey})

Deploy or undeploy a DataPage (PUT /bridgeApplications/{externalKey}/datapages/{dpKey}/deployment)

List scheduled import/export tasks (GET /dataImportExportTasks)

Get a task's metadata/status (GET /dataImportExportTasks/{externalKey})

Run a data import/export task on demand (POST /dataImportExportTasks/{externalKey}/run)

Update task configuration (PUT /dataImportExportTasks/{externalKey})

Delete a task (DELETE /dataImportExportTasks/{externalKey})