tables_db_upsert_row
Insert new data or modify existing records in Appwrite database tables using a single API operation to maintain data integrity.
Instructions
Create or update a Row. Before using this route, you should create a new table resource using either a server integration API or directly from your database console.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_id | Yes | Database ID. | |
| table_id | Yes | Table ID. | |
| row_id | Yes | Row ID. | |
| data | No | Row data as JSON object. Include all required columns of the row to be created or updated. | |
| permissions | No | An array of permissions strings. By default, the current permissions are inherited. [Learn more about permissions](https://appwrite.io/docs/permissions). | |
| transaction_id | No | Transaction ID for staging the operation. |