Caspio icon

Caspio

Interact with Caspio REST API.
Join our community

Actions21

Overview

This node operation deletes attachments from a specified attachment field in a Caspio table. It allows users to select the table and attachment field, then specify which records to delete attachments from using either a basic visual filter builder or an advanced SQL-like WHERE clause. This is useful for managing and cleaning up attachments stored in Caspio databases, such as removing outdated or unwanted files from records.

Use Case Examples

  1. Deleting attachments from a specific field in a Caspio table where the status is 'Inactive'.
  2. Removing all attachments from a field in a Caspio table using an advanced WHERE clause to target specific records.

Properties

Name Meaning
Table The Caspio table from which attachments will be deleted. Can be selected from a list or specified by name.
Attachment Field Name or ID The attachment field within the selected table from which attachments will be deleted. Options are dynamically loaded based on the selected table.
Mode Determines how records are selected for attachment deletion: Basic mode uses a visual filter builder, Advanced mode allows a full SQL-like WHERE clause.
Filters In Basic mode, a collection of filter conditions to select which records' attachments will be deleted. Each filter includes a field, operator, and value.
Where In Advanced mode, a SQL-like WHERE clause string to select records for attachment deletion.

Output

JSON

  • success - Indicates whether the attachment deletion operation was successful.
  • deletedCount - The number of attachments deleted from the specified field.

Dependencies

  • Caspio REST API

Troubleshooting

  • Ensure the table name and attachment field are correctly specified and exist in Caspio.
  • Verify that the filters or WHERE clause syntax is correct to avoid no records being matched.
  • Check API credentials and permissions to ensure the node can perform delete operations on attachments.

Links

Discussion