Actions71
- Asset Actions
- Attribute Actions
- Block Actions
- Database Actions
- Document Actions
- Markdown Table Actions
- Notebook Actions
- Search Actions
- System Actions
- Tag Actions
Database → Set Cell
AI-generatedOverview
This node operation sets the value of a specific cell in a SiYuan database (AttributeView block). It is useful for workflows that need to update individual cell values within a database, such as modifying a status, updating a date, or changing a checkbox value in a database row. For example, it can be used to update a task status in a project management database or change a user's subscription status in a customer database.
Use Case Examples
- Updating the 'Status' cell of a task row to 'Completed' in a project management database.
- Setting a checkbox cell to true or false to indicate a feature toggle in a configuration database.
- Changing a date cell to a new ISO date string to reflect a deadline update.
Properties
| Name | Meaning |
|---|---|
| AV ID | The AttributeView ID of the database block to operate on. This identifies the specific database in SiYuan. |
| Row ID | The ID of the row within the database to update the cell value. |
| Column (Key) ID | The ID of the column (key) within the database to update the cell value. |
| Cell Value | The new value to set in the specified cell. Supports string values, true/false for checkboxes, comma-separated lists for multi-selects, and ISO strings or epoch milliseconds for dates. |
Output
JSON
success- Indicates whether the cell update operation was successful.
Dependencies
- Requires SiYuan API URL and API token credentials for authentication.
Troubleshooting
- Ensure the AV ID, Row ID, and Column ID are correct and correspond to existing database elements in SiYuan.
- Verify that the API URL and token credentials are correctly set and valid.
- If the cell value format is incorrect (e.g., invalid date string), the operation may fail. Use the correct format as described.
- Common error messages include missing credentials, unsupported resource or operation, and invalid IDs. Check the error details for guidance.