Actions21
- Attachment Actions
- Directory Actions
- Data Import/Export Task Actions
- File Actions
- Record Actions
Overview
This node interacts with the Caspio REST API to delete users from a specified directory. It supports two modes for selecting users to delete: a basic mode where users can be filtered using multiple filter conditions on directory fields, and an advanced mode where a full SQL WHERE clause can be provided to specify which users to delete. This node is useful for automating user management tasks such as removing inactive or obsolete users from a directory.
Use Case Examples
- Deleting users from a directory who have not logged in since a certain date using the advanced WHERE clause mode.
- Deleting users based on specific field values using the basic filter conditions mode.
Properties
| Name | Meaning |
|---|---|
| Directory | The directory from which users will be deleted. It can be selected from a list or specified by ID. |
| Mode | Choose how to select users to delete: Basic mode uses filter conditions, Advanced mode uses a full WHERE clause. |
| Filters | In Basic mode, configure one or more filter conditions to specify which users to delete. Each filter includes a field name, an operator, and a value. |
| Where Clause | In Advanced mode, provide a SQL WHERE clause to select users to delete. Special attributes like _status, _sign_in_method, and _2fa_status cannot be used. |
Output
JSON
success- Indicates whether the delete operation was successful.deletedCount- The number of users deleted from the directory.
Dependencies
- Requires an API key credential for Caspio OAuth2 authentication to access the Caspio REST API.
Troubleshooting
- Ensure the directory exists and the provided directory ID or list selection is valid to avoid errors.
- In Basic mode, verify that filter fields and operators are valid and supported by the directory.
- In Advanced mode, ensure the WHERE clause syntax is correct and does not use restricted special attributes.
- Be aware that this operation permanently deletes users; accidental deletions cannot be undone.
Links
- Caspio n8n Integration Documentation - Official documentation for integrating Caspio with n8n, including usage of directory user deletion.