Caspio

Caspio is a low-code cloud platform for building online database applications without writing code, enabling business users and developers to create multi-user data-driven web apps through a point-and-click visual builder. The platform includes automated workflows, AI integration, identity management, and compliance tooling, and exposes a REST API for managing tables, views, records, files, users, and tasks in a Caspio account.

1 APIs 0 Features

Low CodeNo CodeDatabaseApplication PlatformCloud DatabaseOnline FormsWorkflow Automation

APIs

Caspio REST API

REST API for Caspio Bridge accounts providing programmatic access to tables, views, records, files, users, applications, and tasks. Uses OAuth 2.0 client credentials flow to obt...

Collections

Caspio REST API

OPEN

Resources

Sources

opencollection: 1.0.0
info:
  name: Caspio REST API
  version: 3.0.0
request:
  auth:
    type: bearer
    token: '{{bearerToken}}'
items:
- info:
    name: Authentication
    type: folder
  items:
  - info:
      name: Obtain an OAuth 2.0 access token (client credentials)
      type: http
    http:
      method: POST
      url: https://{account}.caspio.com/rest/v3/oauth/token
      body:
        type: form-urlencoded
        data:
        - name: grant_type
          value: ''
        - name: client_id
          value: ''
        - name: client_secret
          value: ''
    docs: Obtain an OAuth 2.0 access token (client credentials)
- info:
    name: Tables
    type: folder
  items:
  - info:
      name: List all tables in the account
      type: http
    http:
      method: GET
      url: https://{account}.caspio.com/rest/v3/tables
    docs: List all tables in the account
  - info:
      name: Get a table's metadata
      type: http
    http:
      method: GET
      url: https://{account}.caspio.com/rest/v3/tables/:tableName
      params:
      - name: tableName
        value: ''
        type: path
    docs: Get a table's metadata
  - info:
      name: List fields (columns) for a table
      type: http
    http:
      method: GET
      url: https://{account}.caspio.com/rest/v3/tables/:tableName/fields
      params:
      - name: tableName
        value: ''
        type: path
    docs: List fields (columns) for a table
  - info:
      name: Query table records
      type: http
    http:
      method: GET
      url: https://{account}.caspio.com/rest/v3/tables/:tableName/records
      params:
      - name: tableName
        value: ''
        type: path
      - name: q.select
        value: ''
        type: query
      - name: q.where
        value: ''
        type: query
      - name: q.orderBy
        value: ''
        type: query
      - name: q.groupBy
        value: ''
        type: query
      - name: q.limit
        value: ''
        type: query
      - name: q.pageNumber
        value: ''
        type: query
      - name: q.pageSize
        value: ''
        type: query
    docs: Query table records
  - info:
      name: Insert one record into a table
      type: http
    http:
      method: POST
      url: https://{account}.caspio.com/rest/v3/tables/:tableName/records
      params:
      - name: tableName
        value: ''
        type: path
      - name: response
        value: ''
        type: query
      body:
        type: json
        data: '{}'
    docs: Insert one record into a table
  - info:
      name: Update table records matching a where clause
      type: http
    http:
      method: PUT
      url: https://{account}.caspio.com/rest/v3/tables/:tableName/records
      params:
      - name: tableName
        value: ''
        type: path
      - name: q.where
        value: ''
        type: query
      body:
        type: json
        data: '{}'
    docs: Update table records matching a where clause
  - info:
      name: Delete table records matching a where clause
      type: http
    http:
      method: DELETE
      url: https://{account}.caspio.com/rest/v3/tables/:tableName/records
      params:
      - name: tableName
        value: ''
        type: path
      - name: q.where
        value: ''
        type: query
    docs: Delete table records matching a where clause
- info:
    name: Views
    type: folder
  items:
  - info:
      name: List all views in the account
      type: http
    http:
      method: GET
      url: https://{account}.caspio.com/rest/v3/views
    docs: List all views in the account
  - info:
      name: Query view records
      type: http
    http:
      method: GET
      url: https://{account}.caspio.com/rest/v3/views/:viewName/records
      params:
      - name: viewName
        value: ''
        type: path
      - name: q.where
        value: ''
        type: query
      - name: q.limit
        value: ''
        type: query
    docs: Query view records
- info:
    name: Files
    type: folder
  items:
  - info:
      name: List files in the account file structure
      type: http
    http:
      method: GET
      url: https://{account}.caspio.com/rest/v3/files
      params:
      - name: filePath
        value: ''
        type: query
    docs: List files in the account file structure
  - info:
      name: Upload a file to the account file structure
      type: http
    http:
      method: PUT
      url: https://{account}.caspio.com/rest/v3/files
      body:
        type: multipart-form
        data:
        - name: File
          type: text
          value: ''
    docs: Upload a file to the account file structure
  - info:
      name: Download a file by its external key
      type: http
    http:
      method: GET
      url: https://{account}.caspio.com/rest/v3/files/:externalKey
      params:
      - name: externalKey
        value: ''
        type: path
    docs: Download a file by its external key
  - info:
      name: Delete a file
      type: http
    http:
      method: DELETE
      url: https://{account}.caspio.com/rest/v3/files/:externalKey
      params:
      - name: externalKey
        value: ''
        type: path
    docs: Delete a file
- info:
    name: Users
    type: folder
  items:
  - info:
      name: List application users
      type: http
    http:
      method: GET
      url: https://{account}.caspio.com/rest/v3/users
    docs: List application users
  - info:
      name: Create a new application user
      type: http
    http:
      method: POST
      url: https://{account}.caspio.com/rest/v3/users
      body:
        type: json
        data: '{}'
    docs: Create a new application user
  - info:
      name: Get a single application user
      type: http
    http:
      method: GET
      url: https://{account}.caspio.com/rest/v3/users/:username
      params:
      - name: username
        value: ''
        type: path
    docs: Get a single application user
  - info:
      name: Update a user
      type: http
    http:
      method: PUT
      url: https://{account}.caspio.com/rest/v3/users/:username
      params:
      - name: username
        value: ''
        type: path
      body:
        type: json
        data: '{}'
    docs: Update a user
  - info:
      name: Delete a user
      type: http
    http:
      method: DELETE
      url: https://{account}.caspio.com/rest/v3/users/:username
      params:
      - name: username
        value: ''
        type: path
    docs: Delete a user
- info:
    name: Applications
    type: folder
  items:
  - info:
      name: List Caspio applications
      type: http
    http:
      method: GET
      url: https://{account}.caspio.com/rest/v3/applications
    docs: List Caspio applications
- info:
    name: Tasks
    type: folder
  items:
  - info:
      name: List scheduled tasks
      type: http
    http:
      method: GET
      url: https://{account}.caspio.com/rest/v3/tasks
    docs: List scheduled tasks
  - info:
      name: Run a scheduled task on demand
      type: http
    http:
      method: POST
      url: https://{account}.caspio.com/rest/v3/tasks/:taskName/run
      params:
      - name: taskName
        value: ''
        type: path
    docs: Run a scheduled task on demand
bundled: true