Actions71
- Asset Actions
- Attribute Actions
- Block Actions
- Database Actions
- Document Actions
- Markdown Table Actions
- Notebook Actions
- Search Actions
- System Actions
- Tag Actions
Database → Update Row
AI-generatedOverview
This node operation updates a specific row in a SiYuan database (AttributeView block) by setting values in one or more columns. It is useful for workflows that need to modify existing data entries in a SiYuan database, such as updating task statuses, changing inventory counts, or editing user information dynamically.
Use Case Examples
- Updating a task's status to 'Completed' in a project management database.
- Changing the quantity of a product in an inventory database.
- Modifying user profile details in a customer database.
Properties
| Name | Meaning |
|---|---|
| AV ID | The AttributeView ID of the database block to operate on, used to identify the specific database. |
| Row ID | The ID of the row to update in the database. |
| Fields Mode | Determines how the columns to update are identified and how the field values are provided. |
| Fields (By Column Name & Value) | A collection of column name and value pairs to set on the row, with values as plain strings allowing n8n expressions without JSON quoting. |
| Fields (By Column Key ID) | A collection of field and value pairs keyed by internal column IDs, with values coerced based on column type. |
| Fields (JSON) | A JSON string mapping column display names to values, requiring proper quoting for string columns. |
Output
JSON
success- Indicates whether the update operation was successful.
Dependencies
- SiYuan API URL and Token credentials required for authentication.
Troubleshooting
- Ensure the AV ID and Row ID are correct and exist in the SiYuan database.
- Verify that the API URL and Token credentials are properly set and valid.
- Check that the fields provided match the column names or IDs in the database and are formatted correctly according to the selected Fields Mode.
- Common error: 'SiYuan API URL and Token are required.' means credentials are missing or invalid; resolve by providing valid credentials.