Caspio icon

Caspio

Caspio API
Join our community

Actions10

Overview

The Caspio Row Create operation node allows you to insert a new record into a specified Caspio Table or View. This is useful for automating data entry workflows, such as adding new leads, orders, or any structured data into your Caspio applications directly from n8n. For example, you could use this node to automatically add form submissions, CRM entries, or processed results into your Caspio database.

Properties

Name Type Meaning
Table/View Name String The name of the Caspio Table or View where the new row will be inserted.
Is View Boolean If enabled, the operation targets a View instead of a Table.
Data to Send Options Determines how the data for the new row is provided. For "Create", only "Define Below..." is supported, meaning you specify each column's value manually.
Fields to Send Fixed Collection Allows you to define one or more fields (columns) and their values for the new row. Each field requires:
- Field Name: The destination column in Caspio.
- Field Value: The value to insert into that column.

Output

  • The output is a JSON object representing the newly created row in Caspio.
  • Example structure:
    {
  "FIELD1": "value1",
  "FIELD2": "value2",
  ...
}
  • No binary data is produced by this operation.

Dependencies

  • External Service: Requires access to the Caspio API.
  • Credentials: You must configure Caspio credentials in n8n (API key, client ID/secret, etc.).
  • Environment: No special environment variables are required beyond standard n8n credential setup.

Troubleshooting

  • Missing Required Fields: If you do not provide all required fields for the table/view, Caspio may return an error indicating missing data.
  • Invalid Table/View Name: If the specified Table/View does not exist, you will receive an error from the Caspio API.
  • Authentication Errors: Invalid or expired Caspio credentials will result in authentication failures.
  • Field Mapping Issues: If a field name does not match any column in the target Table/View, the API will reject the request.
  • Error Handling: If an error occurs and "Continue On Fail" is enabled, the node outputs an error message in the json.error property.

Links and References

Discussion