Actions31
- Tabelle Actions
- View Actions
- Spalte Actions
- Share Actions
- Import Actions
- Zeile Actions
Overview
The "Zeile Erstellen (KI-Friendly)" operation in the Nextcloud Tables node allows users to create a new row in a specified table or view within Nextcloud Tables. This operation is designed to facilitate adding structured data entries programmatically, which can be particularly useful for automating data collection, integration with AI workflows, or batch data insertion.
Typical use cases include:
- Automatically appending new records from external sources into a Nextcloud Table.
- Integrating AI-generated data outputs directly into tables for further processing or reporting.
- Managing dynamic datasets where rows need to be created based on user input or other automated triggers.
For example, you might use this operation to add a new customer record with multiple fields such as name, email, and purchase details into a sales table.
Properties
| Name | Meaning |
|---|---|
| Datenquelle (AI-Friendly) | Configuration of the data source where the new row will be added. Choose between: - Quell-Typ: Select whether the source is a "table" or a "view". - Tabellen-ID: The ID of the table (required if type is "table"). - View-ID: The ID of the view (required if type is "view"). |
| Zeilen-Daten (AI-Friendly) | Configuration of the row data to insert. - Spalten-Daten: A list of columns and their corresponding values for the new row. Each entry requires: • Spalten-ID: The ID of the column. • Wert: The value to set in that column for the new row. |
Output
The output JSON contains the response from the Nextcloud Tables API after creating the row. It typically includes details about the newly created row, such as its unique identifier and the stored column values.
If the node supports binary data output (not indicated explicitly here), it would represent any file attachments or binary content related to the row, but this operation primarily deals with JSON data representing table rows.
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 to Nextcloud Tables.
- The node depends on internal handlers for rows, tables, views, and columns to perform operations.
Troubleshooting
Common issues:
- Providing incorrect or missing table/view IDs will cause the operation to fail.
- Mismatched column IDs or invalid data types for column values may result in errors.
- Network or authentication failures due to invalid API credentials.
Error messages:
"Unknown resource": Indicates an unsupported resource was selected; ensure "row" is chosen.- API errors related to permissions or invalid IDs usually return descriptive messages from Nextcloud.
Resolution tips:
- Verify that the table or view IDs are correct and accessible by the API user.
- Confirm that all required columns have valid IDs and appropriate values.
- Check API credentials and network connectivity.