Caspio icon

Caspio

Interact with Caspio REST API.
Join our community

Actions21

Overview

This node interacts with Caspio's REST API to retrieve properties of attachments stored in Caspio tables or views. It allows users to specify the source type (Table or View), select the specific table or view, and choose the attachment field to query. Users can also apply filters to limit the returned attachment records, either through a basic visual query builder or by providing advanced SQL-like WHERE clause conditions. This node is useful for scenarios where you need to programmatically access and manage attachment metadata from Caspio databases, such as integrating Caspio attachments into automated workflows or external systems.

Use Case Examples

  1. Retrieve attachment properties from a specific Caspio table to display in a dashboard.
  2. Filter attachments based on metadata fields to process only relevant files in an automation.
  3. Use advanced filtering to query attachments with complex conditions for reporting or data analysis.

Properties

Name Meaning
Data Source Type Choose between using Table or View as your attachment source.
Table Select the Caspio Table to query attachments from (required if Data Source Type is Table).
View Select the Caspio View to query attachments from (required if Data Source Type is View).
Attachment Field Name or ID The attachment field to query. Can be selected from a list or specified by ID using an expression.
Mode Choose the interface complexity level for filtering: Basic (visual query builder) or Advanced (direct API parameter input).
Enable Filtering Whether to apply filters to limit which attachment records are returned (only in Basic mode).
Filters Configure filters to limit which attachment records are returned, specifying field, operator, and value (only in Basic mode with filtering enabled).
Where Filter conditions syntax using SQL-like WHERE clause for advanced filtering (only in Advanced mode).

Output

JSON

  • attachments - Array of attachment properties retrieved from the specified Caspio table or view.

Dependencies

  • Caspio REST API

Troubleshooting

  • Ensure the correct Caspio OAuth2 API credentials are configured to authenticate requests.
  • Verify that the specified table or view names conform to Caspio naming conventions (alphanumeric and underscores only).
  • If filtering is enabled, ensure filter field names and operators are valid and supported by Caspio API.
  • For advanced mode, ensure the WHERE clause syntax is correct to avoid API errors.

Links

Discussion