Caspio icon

Caspio

Interact with Caspio REST API.
Join our community

Actions21

Overview

This node interacts with the Caspio REST API to create a new record in a specified Caspio table. It is useful for automating data entry into Caspio databases, such as adding new customer information, logging transactions, or storing form submissions. Users specify the target table and map the columns with the data to be inserted.

Use Case Examples

  1. Creating a new customer record in a Caspio table named 'Customers' by mapping input data fields to the table columns.
  2. Automating the insertion of form submission data into a Caspio table for further processing or reporting.

Properties

Name Meaning
Table Specifies the Caspio table where the new record will be created. It can be selected from a list or entered by name.
Columns Defines the mapping of input data to the columns of the selected Caspio table for the new record. Supports adding all fields or selecting specific columns.

Output

JSON

  • id - The unique identifier of the newly created record in the Caspio table.
  • createdAt - Timestamp indicating when the record was created.
  • columns - An object containing the values of the columns that were set during record creation.

Dependencies

  • Requires Caspio API credentials, typically an OAuth2 API key, to authenticate requests to the Caspio REST API.

Troubleshooting

  • Ensure the table name is valid and exists in Caspio; invalid or non-existent table names will cause errors.
  • Verify that all required columns are mapped with valid data; missing or incorrect column mappings can lead to failed record creation.
  • Check that the API credentials are correctly configured and have sufficient permissions to create records in the specified table.
  • Common error messages include authentication failures, invalid table names, and data validation errors. Resolving these involves verifying credentials, table existence, and data formats.

Links

Discussion