Actions31
- Table Actions
- View Actions
- Column Actions
- Share Actions
- Import Actions
- Row Actions
Overview
The "Update Row (AI-Friendly)" operation in the Nextcloud Tables node allows users to update a specific row within a table by specifying the row ID and providing new values for one or more columns. This operation is useful when you need to modify existing data entries programmatically, such as correcting information, updating statuses, or enriching records with additional details.
Practical examples include:
- Updating a customer's contact information in a CRM table.
- Changing the status of a task in a project management table.
- Modifying inventory quantities in a stock management table.
This operation supports specifying the data source either as a table or a view, enabling flexible targeting of data structures within Nextcloud Tables.
Properties
| Name | Meaning |
|---|---|
| Data Source (AI-Friendly) | Configuration of the data source for the operation. Choose between using a table or a view. If "table" is selected, provide the Table ID; if "view" is selected, provide the View ID. Valid values for Source Type: "table", "view". |
| Update Data (AI-Friendly) | Configuration for the row update. Includes: - Row ID: The unique identifier of the row to update. - Table ID: The ID of the table where the row exists (required for API path). - Column Data: One or more columns to update, each specified by: - Column ID: Identifier of the column. - New Value: The new value to set for that column. |
Output
The output of this operation is a JSON object representing the updated row data as returned by the Nextcloud Tables API. It typically includes the row's identifiers and the updated column values reflecting the changes made.
If the node supports binary data output (not indicated here), it would represent any associated file or media content related to the row, but this operation focuses on JSON data updates only.
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.
- The node depends on the Nextcloud Tables API endpoints for rows, tables, and views.
- Proper permissions on the target table/view and rows are necessary to perform updates.
Troubleshooting
Common Issues:
- Providing incorrect or missing Table ID or Row ID will cause the update to fail.
- Attempting to update columns that do not exist or are read-only may result in errors.
- Insufficient permissions on the Nextcloud Tables instance can block updates.
- Network connectivity issues or invalid API credentials will prevent successful API calls.
Error Messages:
"Unknown resource": Indicates the resource parameter is invalid or unsupported.- API errors from Nextcloud may include messages about invalid IDs, permission denied, or malformed requests.
Resolutions:
- Verify that the Table ID and Row ID are correct and correspond to existing entities.
- Ensure the API credentials have sufficient rights to update rows.
- Confirm that the column IDs used in the update exist in the specified table.
- Check network connectivity and API endpoint accessibility.