Caspio icon

Caspio

Interact with Caspio REST API.
Join our community

Actions21

Overview

This node interacts with the Caspio REST API to retrieve multiple user records from a specified directory. It supports both a basic visual query builder mode and an advanced mode for direct API parameter input, allowing users to filter, sort, and limit the user data returned. This node is useful for scenarios where you need to fetch user information from Caspio directories for further processing or integration in workflows, such as syncing user data, reporting, or automation.

Use Case Examples

  1. Fetch all users from a specific directory with basic filtering and sorting applied.
  2. Retrieve a limited set of users using advanced SQL-like query parameters for complex filtering and grouping.

Properties

Name Meaning
Directory The Caspio directory from which to retrieve users, selectable by list or ID.
Mode Choose between Basic (visual query builder) and Advanced (direct API parameter input) modes.
Configure Output Fields Enable selection of specific fields and aggregations for the output (Basic mode only).
Field Names or IDs Select specific fields to include in the output (Basic mode with output configuration enabled).
Filter Records Enable filtering to limit which user records are returned (Basic mode).
Filters Define filter conditions with field, operator, and value (Basic mode with filtering enabled).
Sort Records Enable sorting of the returned user records (Basic mode).
Sort Rules Define sorting rules by field and order (Basic mode with sorting enabled).
Return All Choose whether to return all matching results or limit the number of results (Basic mode).
Limit Maximum number of user records to return if not returning all (Basic mode).
Select Comma-separated list of fields to select (Advanced mode).
Where SQL-like WHERE clause for filtering user records (Advanced mode).
Group By Comma-separated list of fields to group results by (Advanced mode).
Order By SQL-like ORDER BY clause to sort results (Advanced mode).
Limit Maximum number of records to return per request (Advanced mode).
Page Number Page number for pagination (Advanced mode).
Page Size Number of records per page for pagination (Advanced mode).

Output

JSON

  • users - Array of user records retrieved from the specified directory.

Dependencies

  • Caspio REST API
  • OAuth2 API credentials for authentication

Troubleshooting

  • Ensure the OAuth2 credentials are correctly configured and authorized to access the Caspio API.
  • Verify the directory ID or list selection is valid and accessible.
  • Check filter and sort field names for correctness and availability in the selected directory.
  • In advanced mode, ensure the SQL-like query syntax is correct to avoid API errors.
  • Limit the number of records requested to avoid exceeding API limits or timeouts.

Links

Discussion