Actions31
- Tabelle Actions
- View Actions
- Spalte Actions
- Share Actions
- Import Actions
- Zeile Actions
Overview
The node "Nextcloud Tables" allows managing Nextcloud Tables resources such as tables, views, columns, shares, imports, and rows. Specifically, the Spalte Aktualisieren (Update Column) operation updates properties of a column in a Nextcloud Table.
This operation is useful when you want to modify metadata of an existing column, for example:
- Renaming a column title to better reflect its content.
- Adding or updating a description to clarify the column's purpose.
- Setting whether the column is mandatory, enforcing data entry rules.
Practical examples include:
- Updating a column title from "Phone" to "Mobile Phone" after a schema change.
- Adding a description like "User's primary contact number" to improve clarity.
- Marking a column as mandatory to ensure data completeness.
Properties
| Name | Meaning |
|---|---|
| Spalte | Select a column either from a searchable list or by entering its numeric ID manually. |
| Titel | The new title/name of the column (optional). Can be set via expression. |
| Beschreibung | The new description text for the column (optional). Can be set via expression. |
| Pflichtfeld | Boolean flag indicating if the column should be mandatory (true) or optional (false). |
Output
The output JSON contains the updated column data returned from the API after the update operation. This typically includes the column's ID, updated title, description, mandatory status, and other metadata reflecting the current state of the column.
No binary data output is involved in this operation.
Dependencies
- Requires an API key credential for authenticating with the Nextcloud Tables API.
- The node depends on Nextcloud Tables API endpoints for columns.
- Proper configuration of the API credentials in n8n is necessary for successful execution.
Troubleshooting
- Invalid Column ID: If the column ID is not numeric or does not exist, the node will throw an error. Ensure the column ID is correct and exists in the target table.
- Authentication Errors: Missing or invalid API credentials will cause authentication failures. Verify that the API key credential is correctly configured.
- Permission Issues: Insufficient permissions on the Nextcloud Tables instance may prevent updating columns. Confirm that the API user has rights to modify columns.
- Empty Required Fields: If required fields are missing or invalid, the API may reject the request. Make sure to provide valid values especially for the column ID.
- Continue On Fail: If enabled, errors will be returned as part of the output JSON under an
errorproperty instead of stopping the workflow.
Links and References
- Nextcloud Tables API Documentation (general reference for API endpoints)
- n8n Documentation - Creating Custom Nodes (for understanding node development concepts)