Add or update rows by a key
rows_upsertSync rows from anywhere without reading the table first: each row whose key column matches a row in the table updates it (only the columns given change; a null value clears a cell), the rest are added. The key is a text, email, url, phone, select or number column whose values are unique (text matches in any case). Up to 500 rows, checked first: if one is wrong, nothing changes. Costs $0.001 per row added or updated; nothing if none are found.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"table": "<table>",
"key": "<key>",
"rows": "<rows>"
},
"name": "rows_upsert"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| key | Yes | The column that identifies a row, e.g. "Email" or "SKU". | |
| rows | Yes | ||
| table | Yes | The table's name (or its table_id). |