faucet_update
Update records in a database table by matching a filter expression and setting new column values. A filter is required to prevent full-table updates.
Instructions
Update records in a database table that match a filter expression. The record object contains the column values to set. A filter is required to prevent accidental full-table updates. Requires PATCH permission on the table.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Name of the table to update | |
| filter | Yes | Filter expression to select records to update (e.g. "id = 42") | |
| record | Yes | Object with column names and new values (e.g. {"status": "archived"}) | |
| service | Yes | Name of the database service |