Caspio icon

Caspio

Interact with Caspio REST API.
Join our community

Actions21

Overview

This node interacts with the Caspio REST API to delete records from a specified Caspio table. It supports two modes for selecting records to delete: a basic visual filter builder and an advanced mode where a full SQL-like WHERE clause can be provided. This node is useful for automating the removal of data entries based on dynamic conditions, such as deleting inactive users, outdated records, or entries matching specific criteria.

Use Case Examples

  1. Delete records from a Caspio table using a visual filter to remove all entries where status is 'inactive'.
  2. Use an advanced SQL-like WHERE clause to delete records from a table where the 'expiry_date' is before the current date.

Properties

Name Meaning
Table The Caspio table from which records will be deleted. It can be selected from a list or specified by name.
Mode Determines how records are selected for deletion. 'Basic' uses a visual filter builder, while 'Advanced' allows a full SQL-like WHERE clause.
Filters A collection of filter conditions used in 'Basic' mode to select which records to delete. Each filter includes a field name, an operator, and a value to compare against.
Where An SQL-like WHERE clause string used in 'Advanced' mode to specify which records to delete.

Output

JSON

  • success - Indicates whether the delete operation was successful.
  • deletedCount - The number of records deleted as a result of the operation.

Dependencies

  • Caspio REST API

Troubleshooting

  • Ensure the table name is valid and exists in Caspio to avoid errors.
  • Verify that the filter conditions or WHERE clause syntax are correct to prevent query failures.
  • Check API authentication credentials if the node fails to connect or perform operations.

Links

Discussion