upsert
Insert new records or update existing ones in Airtable by matching specified fields, ensuring data consistency without duplicates.
Instructions
Upsert Airtable records using performUpsert.fieldsToMergeOn.
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": {
"baseId": "<baseId>",
"table": "<table>",
"records": "<records>",
"performUpsert": "<performUpsert>"
},
"name": "upsert"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| baseId | Yes | ||
| table | Yes | ||
| records | Yes | ||
| performUpsert | Yes | ||
| typecast | No | ||
| idempotencyKey | No | ||
| dryRun | No | ||
| conflictStrategy | No | fail_on_conflict |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| diff | Yes | ||
| dryRun | Yes | ||
| records | No | ||
| conflicts | No |