Caspio icon

Caspio

Interact with Caspio REST API.
Join our community

Actions21

Overview

This node interacts with Caspio's REST API to update records in a specified Caspio table. It supports two modes for selecting records to update: a basic mode where users can define filters using field conditions, and an advanced mode where users can provide a full SQL-like WHERE clause. Users specify the table, the selection criteria for records to update, and the fields with their new values to be set. This node is useful for automating updates to data stored in Caspio tables, such as modifying customer information, updating inventory records, or changing status flags based on dynamic conditions.

Use Case Examples

  1. Updating customer records in a Caspio table based on specific filter conditions like customer ID or status.
  2. Performing bulk updates on records using an advanced SQL WHERE clause to target records meeting complex criteria.
  3. Changing field values such as setting a status field to 'completed' or updating a date field to the current date.

Properties

Name Meaning
Table The Caspio table where records will be updated. It can be selected from a list or specified by name.
Mode Determines how records to update are selected: Basic mode uses filter conditions, Advanced mode uses a full WHERE clause.
Filters In Basic mode, a collection of filter conditions specifying fields, operators, and values to identify records to update.
Where Clause In Advanced mode, a SQL-like WHERE clause string to specify which records to update.
Update Fields A collection of fields and their new values to set on the selected records.

Output

JSON

  • success - Indicates whether the update operation was successful.
  • updatedRecordsCount - The number of records that were updated.
  • message - Additional information or error messages related to the update operation.

Dependencies

  • Requires Caspio OAuth2 API credentials for authentication to access Caspio REST API.

Troubleshooting

  • Ensure the Caspio OAuth2 API credentials are correctly configured and valid to avoid authentication errors.
  • Verify that the table name or selected table from the list exists and is accessible in the Caspio account.
  • In Basic mode, confirm that filter fields and operators are valid and supported by Caspio.
  • In Advanced mode, ensure the WHERE clause syntax is correct and compatible with Caspio's SQL-like syntax.
  • Check that the fields specified for update exist in the table and that the values provided are valid for those fields.

Links

Discussion