Actions31
- Table Actions
- View Actions
- Column Actions
- Share Actions
- Import Actions
- Row Actions
Overview
This node enables managing views within Nextcloud Tables, specifically allowing the creation of new views with AI-friendly configurations. It is useful for users who want to programmatically create customized table views that include specific titles, descriptions, emojis, filters, and sorting rules. For example, a user can create a view named "My View" on a particular table, apply filters such as "Status equals Active," and sort rows by a date column in ascending order.
Properties
| Name | Meaning |
|---|---|
| View Configuration (AI-Friendly) | Basic settings for the new view: includes the title (name) of the view, the ID of the table it belongs to, an optional emoji to visually represent the view, and an optional description providing more context about the view. |
| - Title | The title or name of the new view (e.g., "My View"). |
| - Table ID | The identifier of the table where the view will be created. |
| - Emoji | An optional emoji symbol to associate with the view (e.g., 🔍). |
| - Description | An optional textual description explaining the purpose or details of the view. |
| Filter Configuration (AI-Friendly) | Defines filtering rules applied to the view's data. Multiple filter rules can be added, each specifying a column, an operator, and a value to filter by. |
| - Filters | One or more filter rules, each containing: |
| • Column ID | The ID of the column to which the filter applies. |
| • Operator | The comparison operator for filtering. Valid values: EQ (equals), NEQ (not equals), GT (greater than), GTE (greater or equal), LT (less than), LTE (less or equal), LIKE (contains). |
| • Value | The value to compare against in the filter. |
| Sorting Configuration (AI-Friendly) | Specifies sorting rules for the view. Multiple sorting criteria can be defined, each indicating a column and direction. |
| - Sorting | One or more sorting rules, each containing: |
| • Column ID | The ID of the column to sort by. |
| • Direction | Sort direction, either ASC (ascending, e.g., A-Z or 1-9) or DESC (descending, e.g., Z-A or 9-1). |
Output
The node outputs JSON objects representing the result of the view creation operation. This typically includes details of the newly created view such as its ID, title, associated table, applied filters, and sorting rules. The output does not include binary data.
Example output structure (simplified):
{
"id": "view-id",
"title": "My View",
"tableId": "123",
"emoji": "🔍",
"description": "Description of the view...",
"filters": [
{
"columnId": "1",
"operator": "EQ",
"value": "Active"
}
],
"sorting": [
{
"columnId": "2",
"direction": "ASC"
}
]
}
Dependencies
- Requires an API key credential for authenticating with the Nextcloud Tables service.
- The node depends on Nextcloud Tables API endpoints to manage tables, views, columns, rows, shares, and imports.
- No additional external services are required beyond the Nextcloud Tables backend.
- Proper configuration of the API authentication credential in n8n is necessary.
Troubleshooting
Common issues:
- Invalid or missing table ID: Ensure the table ID provided exists and is accessible with the given credentials.
- Incorrect column IDs in filters or sorting: Verify that column IDs correspond to actual columns in the specified table.
- Unsupported filter operators or invalid values: Use only the supported operators (
EQ,NEQ,GT,GTE,LT,LTE,LIKE) and provide appropriate values. - Permission errors: Confirm that the API key has sufficient permissions to create views on the target table.
Error messages:
"Unknown resource": Indicates an unsupported resource was selected; ensure "View" is chosen.- API errors related to authentication or authorization: Check API key validity and permissions.
- Validation errors on input parameters: Review the input properties for completeness and correctness.
To resolve errors, verify all input fields, confirm API credentials, and consult Nextcloud Tables API documentation for constraints.