Actions31
- Table Actions
- View Actions
- Column Actions
- Share Actions
- Import Actions
- Row Actions
Overview
This node enables managing views within Nextcloud Tables, specifically allowing users to create new views on existing tables. A "view" in this context is a customized way to display or filter table data, often including filters and sorting rules.
Common scenarios where this node is beneficial include:
- Creating tailored perspectives of large datasets by filtering rows based on specific criteria.
- Sorting data in ascending or descending order for easier analysis.
- Adding descriptive metadata (title, emoji, description) to views for better organization and identification.
Practical example: Suppose you have a large project management table and want to create a view that only shows tasks assigned to a particular team member, sorted by due date ascending. This node can automate creating such a filtered and sorted view programmatically.
Properties
| Name | Meaning |
|---|---|
| Table | Select the target table for which the view will be created. You can choose from a list of tables or enter the table ID directly (must be a number). |
| Title | The name/title of the new view. This is required and identifies the view. |
| Emoji | An optional emoji to visually represent the view. |
| Description | An optional textual description providing more details about the view's purpose or contents. |
| Filter | One or more filter rules to limit which rows appear in the view. Each rule includes: • Column: the column to apply the filter on. • Operator: comparison operator (e.g., EQ for equals). • Value: the value to compare against. |
| Sorting | One or more sorting rules to order the rows in the view. Each rule includes: • Column: the column to sort by. • Direction: Ascending (ASC) or Descending (DESC). |
Output
The node outputs JSON data representing the newly created view object as returned by the Nextcloud Tables API. This typically includes details such as the view ID, title, associated table ID, applied filters, sorting rules, and any metadata like emoji or description.
No binary data output is produced by this node.
Dependencies
- Requires an active connection to a Nextcloud instance with the Tables app enabled.
- Needs an API authentication token or API key credential configured in n8n to authorize requests.
- Relies on Nextcloud Tables API endpoints to create views and fetch related metadata (tables, columns).
Troubleshooting
- Invalid Table ID: If the table ID is incorrect or does not exist, the node will fail. Ensure the table exists and the ID is numeric.
- Filter or Sort Column Not Found: Filters or sorting rules referencing non-existent columns will cause errors. Verify column selections are valid for the chosen table.
- API Authentication Errors: Missing or invalid API credentials will prevent communication with Nextcloud. Confirm credentials are correctly set up.
- Permission Issues: The authenticated user must have permission to create views on the specified table.
- Malformed Filter Rules: Operators or values that do not conform to expected formats may cause failures. Use supported operators and valid values.
If the node throws an error, check the error message for clues and verify all input parameters carefully. Enabling "Continue On Fail" allows processing subsequent items even if one fails.