Actions31
- Tabelle Actions
- View Actions
- Spalte Actions
- Share Actions
- Import Actions
- Zeile Actions
Overview
The "Zeile Erstellen" (Create Row) operation in the Nextcloud Tables node allows users to add new rows of data into a specified table or view within Nextcloud Tables. This is useful for automating data entry, integrating external data sources, or dynamically updating tables based on workflow logic.
Typical use cases include:
- Adding new records to a project management table when a task is created elsewhere.
- Inserting form submission data directly into a Nextcloud Table.
- Populating views with filtered or aggregated data by creating rows programmatically.
Properties
| Name | Meaning |
|---|---|
| Quelle | Choose whether to work with a Table ("Tabelle") or a View ("View") as the source for the row creation. |
| Tabelle | Select the target Table either from a searchable list or by entering its numeric ID. Required if "Quelle" is set to "Tabelle". |
| View | Select the target View either from a searchable list or by entering its numeric ID. Required if "Quelle" is set to "View". |
| Zeilen-Daten | Define one or more columns and their corresponding values to populate the new row. Each entry requires: - Spalten-ID: The column identifier (selectable from available columns). - Wert: The value to insert into that column. Supports expressions. |
Output
The node outputs JSON objects representing the newly created row(s). Each output item contains the data returned from the Nextcloud Tables API after row creation, typically including identifiers and the stored values for each column.
If binary data were involved (not indicated here), it would be summarized accordingly, but this operation deals solely with JSON data representing table rows.
Dependencies
- Requires an active connection to a Nextcloud instance with the Tables app enabled.
- Needs an API authentication credential configured in n8n to authorize requests to Nextcloud Tables.
- The node relies on internal handlers for rows, tables, views, and columns to perform operations.
Troubleshooting
- Invalid Table or View ID: Ensure the selected table or view exists and the ID is correct (numeric). Validation regex enforces numeric IDs.
- Missing Required Fields: The "Zeilen-Daten" property must have at least one column-value pair; otherwise, the API call will fail.
- Permission Issues: The API key used must have write permissions for the target table or view.
- API Errors: If the Nextcloud server returns errors, check network connectivity, API credentials, and that the Tables app is properly configured.
- Expression Errors: When using expressions in column values, verify syntax correctness to avoid runtime failures.
Common error messages will indicate the nature of the failure, such as unknown resource, invalid input, or authorization errors. Enabling "Continue On Fail" can help workflows proceed despite individual row creation errors.