Actions31
- Table Actions
- View Actions
- Column Actions
- Share Actions
- Import Actions
- Row Actions
Overview
The "Update Row" operation in the Nextcloud Tables node allows users to modify data within a specific row of a table stored in Nextcloud Tables. This operation is useful when you need to update existing records programmatically, such as changing user information, updating inventory counts, or modifying any tabular data managed in Nextcloud.
Practical examples include:
- Updating a customer's contact details in a CRM table.
- Changing the status of a task in a project management table.
- Correcting or appending data entries in an inventory or asset tracking table.
This operation requires specifying the target table and the exact row to update, along with the new values for one or more columns.
Properties
| Name | Meaning |
|---|---|
| Row ID | The unique identifier of the row to update. |
| Table | The table containing the row. Can be selected from a list of tables or specified by ID. |
| Update Row Data | One or more columns to update, each defined by: |
| - Column ID: The identifier of the column to update (selectable from available columns). | |
| - Value: The new value to set for that column. |
Output
The output JSON contains the updated row data as returned by the Nextcloud Tables API after the update operation completes successfully. It typically includes the row's ID and the current values of its columns reflecting the changes made.
If the node supports binary data output (not indicated here), it would represent any file attachments or binary content related to the row, but this operation primarily deals with JSON data updates.
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 Nextcloud Tables API endpoints to fetch tables, columns, and perform row updates.
- Proper permissions on the Nextcloud Tables resource are necessary to read and write rows.
Troubleshooting
- Invalid Row ID: If the specified Row ID does not exist, the node will likely return an error indicating the row was not found. Verify the Row ID is correct.
- Table Not Found: Selecting or specifying a non-existent table ID will cause errors. Use the provided table selector or ensure the ID is valid.
- Column ID Issues: If a column ID used in the update data is invalid or does not belong to the selected table, the update will fail.
- Permission Denied: Insufficient permissions on the Nextcloud Tables resource can result in authorization errors.
- API Errors: Network issues or API rate limits may cause failures; check connectivity and API usage quotas.
- To resolve errors, verify all IDs, credentials, and permissions, and consult Nextcloud server logs if needed.