Overview
The Caspio node for n8n allows you to interact with the Caspio API, specifically to manage files within Caspio's platform.
For the File → Update operation, this node updates metadata or properties of files stored in a specified Caspio folder. It does not upload new file content but rather modifies existing file records based on provided criteria.
Common scenarios:
- Updating file metadata (such as name, description, or custom fields) in bulk.
- Automating file management workflows where file attributes need to be changed programmatically.
- Integrating Caspio file updates into larger automation pipelines.
Practical example:
Suppose you have a set of files in a Caspio folder and want to update their status field or tag them differently based on certain conditions. This node can automate that process by specifying which files to update and what new values to assign.
Properties
| Name | Type | Meaning |
|---|---|---|
| Folder Id | String | Id of the Caspio folder containing the files to update. |
| Binary Property | String | Name of the binary property for file data (not used in "Update" operation, relevant for uploads only). |
Note: For the "Update" operation, additional fields such as the fields to update and filter conditions ("where") are also required, but these are not part of your provided property definition.
Output
- The output is a JSON object representing the result of the update operation from the Caspio API.
- Example structure:
{ "json": { // Response from Caspio API after updating the file(s) } } - No binary data is produced by the "Update" operation.
Dependencies
- External Service: Requires access to the Caspio API.
- Authentication: Needs valid Caspio credentials configured in n8n (credential type:
caspio). - Environment: No special environment variables beyond n8n credential configuration.
Troubleshooting
Common issues:
- Missing or incorrect Folder Id: If the Folder Id is empty or invalid, the node will not be able to locate the files to update.
- No matching files: If the filter condition ("where" clause) does not match any files, no updates will occur.
- API errors: Errors from Caspio (e.g., authentication failure, permission denied) will be returned in the output or throw an error if "Continue On Fail" is not enabled.
Error messages:
"No binary data exists on item!"– Only relevant for create/upload operations, not for update."No binary data property ... does not exist on item!"– Also only relevant for create/upload.- Other errors will typically reflect issues with parameters or Caspio API responses.
How to resolve:
- Double-check Folder Id and filter conditions.
- Ensure Caspio credentials are correct and have sufficient permissions.
- Review the error message in the output for guidance.