Caspio icon

Caspio

Interact with Caspio REST API.
Join our community

Actions21

Overview

This node interacts with the Caspio REST API to retrieve multiple records from either a table or a view within Caspio. It supports both a basic visual query builder mode and an advanced mode for direct API parameter input, allowing users to customize their queries extensively. Common use cases include fetching data for reporting, data synchronization, or integration workflows where bulk data retrieval from Caspio is needed.

Use Case Examples

  1. Retrieve all records from a specific Caspio table with filters and sorting applied.
  2. Query a Caspio view using advanced SQL-like syntax to get aggregated data.
  3. Fetch a limited number of records from a table with specific fields and aggregation functions configured.

Properties

Name Meaning
Data Source Type Choose whether to query a table or a view in Caspio.
Table Select the Caspio table to query (required if Data Source Type is Table). Supports selection from a list or by name.
View Select the Caspio view to query (required if Data Source Type is View). Supports selection from a list or by name.
Mode Choose the interface complexity level for query building: Basic (visual builder) or Advanced (direct API parameter input).
Configure Output Fields Whether to configure specific fields and aggregations for the output (only in Basic mode).
Fields Configure the fields to include in the query, including optional aggregation functions and aliases (only if Configure Output Fields is true).
Filter Records Whether to apply filters to limit which records are returned (only in Basic mode).
Filters Configure filters to limit which records are returned, specifying field, operator, and value (only if Filter Records is true).
Sort Records Whether to sort the returned records (only in Basic mode).
Sort Rules Configure how to sort the returned records by specifying fields and sort order (only if Sort Records is true).
Return All Whether to return all results or only up to a given limit (only in Basic mode).
Limit Maximum number of results to return if Return All is false (only in Basic mode).
Select Field selection and aggregation syntax for advanced queries (only in Advanced mode).
Where Filter conditions syntax (SQL-like WHERE clause) for advanced queries (only in Advanced mode).
Group By Grouping fields syntax (comma-separated field names) for advanced queries (only in Advanced mode).
Order By Sort order syntax (field names with ASC/DESC) for advanced queries (only in Advanced mode).
Limit (Advanced) Maximum records to return per request (max 1000) for advanced queries.
Page Number Page number for pagination (starts at 1) in advanced queries.
Page Size Records per page (min 5, max 1000) in advanced queries.

Output

JSON

  • records - Array of records retrieved from the specified Caspio table or view.

Dependencies

  • Caspio REST API
  • OAuth2 API credentials for authentication

Troubleshooting

  • Ensure the selected table or view exists and the name is valid according to Caspio naming conventions.
  • If using Basic mode, verify that fields, filters, and sort rules are correctly configured and compatible with the selected data source.
  • In Advanced mode, ensure the SQL-like syntax for Select, Where, Group By, Order By, and pagination parameters is correct to avoid API errors.
  • Check API credentials and permissions if authentication errors occur.

Links

Discussion