Upsert record(s)

Upsert records in a table in Airtable.

Application

• Airtable

Inputs (what you have)

Name	Description	Data Type	Required?
Base ID	Unique identifier of the base. Example: app1234567890	Text	Yes
Table ID or name	Table ID or table name. Table names and table IDs can be used interchangeably, but table IDs are recommended so requests do not need to change when a table is renamed. Example: tbl1234567890	Text	Yes
Perform upsert	Field names or IDs used to match existing records. Must contain at least one and at most three fields that uniquely identify a record	JSON	No
Records	Unique identifier of the record to update. Required when Perform upsert is not enabled	List	Yes
Return fields by field ID?	When enabled, returned field objects are keyed by field ID instead of field name	True/False	No
Enable automatic type conversion?	Enables best-effort automatic data conversion from string values	True/False	No
Fields to merge on	Field names or IDs used to match existing records. Must contain at least one and at most three fields that uniquely identify a record	List	Yes
Fields		JSON	Yes
Record ID	Unique identifier of the record to update. Required when Perform upsert is not enabled	Text	No

Outputs (what you get)

Name	Description	Data Type
Response status code	The HTTP status code returned by the API.	Number
Response headers	The response headers returned by the API.	JSON
Response body	The response body returned by the API.	JSON

Requirements

• N/A