Caspio icon

Caspio

Interact with Caspio REST API.
Join our community

Actions21

Overview

This node interacts with the Caspio REST API to update user records in a specified directory. It supports two modes for selecting users to update: a basic mode using filter conditions on user fields, and an advanced mode using a full SQL WHERE clause. Users can specify which directory to target, define filters or a WHERE clause to select users, and configure which user fields to update with new values. This node is useful for automating user data management tasks such as bulk updating user attributes based on specific criteria.

Use Case Examples

  1. Updating user email addresses in a directory based on a filter condition like department or role.
  2. Performing advanced updates on users matching complex criteria using a custom WHERE clause.
  3. Automating user attribute updates in bulk for a specified directory.

Properties

Name Meaning
Directory The target directory where users are located. It can be selected from a list or specified by ID.
Mode Determines how users are selected for update. 'Basic' mode uses simple filter conditions, while 'Advanced' mode allows a full WHERE clause.
Filters In Basic mode, a collection of filter conditions to specify which users to update. Each filter includes a field name, an operator, and a value to compare against.
Where Clause In Advanced mode, a SQL WHERE clause string to select users to update. Cannot use special attributes like _status, _sign_in_method, or _2fa_status.
Update Fields A collection of user fields to update and their new values. Each update specifies the field name and the value to set. Leaving the value empty sets the field to NULL.

Output

JSON

  • updatedUserCount - The number of users successfully updated.
  • updateStatus - Status message or details about the update operation.

Dependencies

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

Troubleshooting

  • Ensure the directory ID or selection is valid and accessible with the provided credentials.
  • In Basic mode, verify that filter fields and operators are correctly specified and supported by the directory.
  • In Advanced mode, ensure the WHERE clause syntax is correct and does not include restricted attributes (_status, _sign_in_method, _2fa_status).
  • Check that the fields specified for update exist and are updateable in the target directory.
  • Common errors may include authentication failures, invalid directory or user selection criteria, and syntax errors in the WHERE clause.

Links

Discussion