upsert_rows
Update-or-add by the table's unique column (key: that column's name, e.g. "Email"): a row whose key value is already in the table has the cells you give set (others stay); the rest are added. The safe way to keep a registry in step without making duplicates. All or nothing, up to 500 a call.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| key | Yes | the unique column's name | |
| rows | Yes | ||
| table | Yes | the data table's id or name (list_data_tables) | |
| workspace | No | Which Caddie: leave it out for the user's personal one, or give a team workspace's name or id (list_workspaces). Use the same one you found the item in. |