Actions31
- Tabelle Actions
- View Actions
- Spalte Actions
- Share Actions
- Import Actions
- Zeile Actions
Overview
This node integrates with Nextcloud Tables, allowing users to manage table rows programmatically. Specifically, the "Zeile Aktualisieren (KI-Friendly)" operation updates a row in a specified table or view using AI-friendly input data. This is useful for automating data updates in collaborative spreadsheets or databases hosted on Nextcloud, such as updating inventory records, modifying user information, or adjusting project task statuses.
Practical examples:
- Automatically update a customer record when new information arrives from an external CRM.
- Modify a project task's status based on inputs from an AI processing step.
- Synchronize data changes from another system into a Nextcloud Table row.
Properties
| Name | Meaning |
|---|---|
| Datenquelle (AI-Friendly) | Configuration of the data source to work with. Choose whether to operate on a table or a view. Depending on the choice, provide either the Table ID or View ID. Options: "table" (Tabelle), "view" (View). |
| Update-Daten (AI-Friendly) | Configuration for the row update: - Zeilen-ID: The ID of the row to update. - Tabellen-ID: The ID of the table where the row exists (required for API path). - Spalten-Daten: One or more columns to update, each with: - Spalten-ID: The column ID. - Neuer Wert: The new value to set for that column. |
Output
The node outputs JSON data representing the result of the row update operation. This typically includes confirmation details about the updated row, such as its ID and the new values of the updated columns. There is no indication that binary data is output by this node.
Example output structure (conceptual):
{
"rowId": "123",
"updatedColumns": {
"1": "Neuer Wert...",
"2": "Anderer Wert"
},
"status": "success"
}
Dependencies
- Requires an API key credential for authenticating with the Nextcloud Tables API.
- The node depends on Nextcloud Tables being accessible via the configured API endpoint.
- No additional external services are required beyond Nextcloud itself.
Troubleshooting
- Common issues:
- Incorrect or missing Table ID or View ID will cause the update to fail.
- Providing an invalid Row ID or Column IDs that do not exist in the specified table/view will result in errors.
- Network connectivity problems or incorrect API credentials will prevent successful communication with Nextcloud.
- Error messages:
"Unbekannte Ressource": Indicates an unsupported resource was selected; ensure "Zeile" (row) is chosen.- API errors related to authorization or resource not found should be resolved by verifying credentials and IDs.
- To resolve errors, verify all IDs and credentials, and ensure the Nextcloud instance is reachable.