Update multiple records (PUT)

TOOL

Slug

AIRTABLE_UPDATE_MULTIPLE_RECORDS_PUT

Version

20261013_00

Toolkit

airtable

Tool to destructively update multiple records in Airtable using PUT, clearing unspecified fields. Use when you need to fully replace record data or perform upsert operations. Supports up to 10 records per request.

baseIdrequired

STRING

The ID of the Airtable base containing the table.

recordsrequired

ARRAY<OBJECT>

Array of up to 10 record objects to update. PUT destructively updates records, clearing unspecified fields.

id

STRING

The unique identifier of the record to update. Required when performUpsert is not used.

fieldsrequired

OBJECT

Cell values by field name or field ID. PUT destructively updates, clearing any unspecified fields. Supported field types and their expected value formats: - singleLineText/multilineText/richText: string - number/currency/percent/rating: numeric value - checkbox: boolean (true/false) - singleSelect: exact option name string from field choices - multipleSelects: array of option name strings - date: ISO 8601 format 'YYYY-MM-DD' - dateTime: ISO 8601 format with timezone (e.g., '2024-01-15T14:30:00.000Z') - email/url/phoneNumber: string in appropriate format - multipleAttachments: array of objects with 'url' field - singleCollaborator: object with 'id' or 'email' - multipleRecordLinks: array of record IDs (e.g., ['recXXX', 'recYYY']) - duration: number representing total seconds

typecast

BOOLEAN

If true, Airtable will attempt to convert string values into appropriate cell values.

performUpsert

OBJECT

Configuration for upsert behavior.

fieldsToMergeOnrequired

ARRAY<STRING>

Array of 1-3 field names or field IDs to identify matching records for updates.

tableIdOrNamerequired

STRING

The ID or name of the table within the base where records will be updated.

returnFieldsByFieldId

BOOLEAN

If true, returns fields object keyed by field ID instead of field name.