工具 API

create_records_for_table

Creates new records in an Airtable table. To get baseId and tableId, use the search_bases and list_tables_for_base tools first. When writing to a linked-record (multipleRecordLinks) field through an interface page, get the record IDs from search_candidate_linked_records, passing a pageId that exposes the field for editing — it also applies the field's record-selection filters. It only works within interfaces; for base-level writes, use record IDs from the linked table. For singleSelect/multipleSelects fields, provide the option name as a plain string (e.g., "In progress") or array of strings, not the object format returned by list_records_for_table. By default the response includes only the fields you wrote. To also include fields you did not write (e.g. the primary field or formula results), pass their IDs in fieldIds. You can create up to 50 records per request. To create more than 50 records, make multiple requests. Example: create a record with singleLineText, number, singleSelect, and multipleSelects fields: {"baseId": "appZfrNIUEip5MazD", "tableId": "tblGlReoTNWfYnXIG", "records": [{"fields": {"fldGlRtkBNWfYnPOV": "Launch meeting", "fldulcCPDVz87Bmnw": 42, "fld8WsrpLHHevsnW8": "In progress", "fldgD18XtsueoiguT": ["Urgent", "Q1"]}}]}

productivityOAuth1 积分

调用信息

工具标识: airtable.create_records_for_table
服务提供方: Airtable
平均响应: 0 ms
近 7 天调用: 0

输入参数

baseId必填

The ID of the base containing the table. Must start with "app" and is 17 characters long. Example: "appZfrNIUEip5MazD". Do not substitute user-facing names for baseId. To get baseId, use the search_bases or list_bases tool.

tableId必填

The ID of the table to create a record in. Must start with "tbl" and is 17 characters long. Example: "tblGlReoTNWfYnXIG". Do not substitute user-facing names for tableId. To get tableId, use the list_tables_for_base tool.

records必填

An array of record objects to create. Each record must have a "fields" property containing the field values.

typecast

Whether or not to perform best-effort automatic data conversion from string values. Defaults to false to preserve data integrity.

fieldIds

The IDs of the fields to include in each returned record. If omitted, only the fields you wrote (the keys of records[].fields, unioned across all input records) are returned. Pass explicit IDs to include fields you did not write (e.g. the primary field or formula/rollup results). Field IDs must start with "fld" and is 17 characters long. Example: "fldGlRtkBNWfYnPOV". Do not substitute user-facing names for IDs. To get fieldId, use the list_tables_for_base tool.

interfaceContext

Set this only when the user lacks base access (which can be determined by the permission listed on list_bases) and is creating records through an interface they collaborate on. When provided, the creation is authorized against the user's collaborator permissions on the given interface instead of base-level permissions.