Caspio icon

Caspio

Interact with Caspio REST API.
Join our community

Actions21

Overview

This node interacts with the Caspio REST API to retrieve file properties. Specifically, the 'Get File Properties' operation under the 'File' resource allows users to list files within a specified folder, with options for sorting, pagination, and including subfolders. It supports both a basic visual interface for folder selection and sorting, as well as an advanced mode for direct API parameter input, making it suitable for both simple and complex file queries. Practical use cases include automating file management tasks, retrieving metadata for files stored in Caspio, and integrating file data into workflows.

Use Case Examples

  1. Listing all files in a specific folder sorted by name in ascending order.
  2. Retrieving files from a folder and all its subfolders to aggregate file metadata.
  3. Using advanced mode to specify exact API parameters for complex file queries with pagination.

Properties

Name Meaning
Mode Choose the interface complexity level, either 'Basic' for visual folder selection and sorting or 'Advanced' for direct API parameter input.
Folder Select the folder to get files from, either by path or external key (basic mode only). Leave empty for root folder.
Include Subfolders Whether to also get files from all subfolders (requires multiple API calls). Sorting is disabled when including subfolders.
Sort By Field to sort files by (basic mode only).
Sort Order Sort order ascending or descending (basic mode only).
Folder External Key External key of the folder to get files from (advanced mode only).
Sort Field Field to sort files by (advanced mode only). Leave empty for default.
Sort Descending Whether to sort in descending order (advanced mode only).
Page Number Page number for pagination, starting at 1 (advanced mode only).
Page Size Number of records per page, minimum 5 and maximum 1000 (advanced mode only).

Output

JSON

  • files - Array of file objects with their properties such as name, size, content type, creation date, and last modified date.

Dependencies

  • Requires Caspio REST API credentials (OAuth2) for authentication.

Troubleshooting

  • Ensure the Caspio OAuth2 credentials are correctly configured and authorized to access the API.
  • If using the basic mode, verify the folder path or external key is correct and accessible.
  • When including subfolders, be aware that sorting is disabled and multiple API calls are made, which may affect performance.
  • In advanced mode, ensure API parameters such as external key, sort field, and pagination values are valid to avoid API errors.

Links

Discussion