update_record
Modify existing records in Airtable tables by specifying base ID, table name, record ID, and field updates to change stored data programmatically.
Instructions
Update an existing record in a table
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| base_id | Yes | ID of the base | |
| table_name | Yes | Name of the table | |
| record_id | Yes | ID of the record to update | |
| fields | Yes | Record fields to update as key-value pairs |
Implementation Reference
- src/index.ts:544-561 (handler)Handler implementation for the update_record tool. Extracts arguments from the request and performs a PATCH request to the Airtable API to update the specified record.case "update_record": { const { base_id, table_name, record_id, fields } = request.params.arguments as { base_id: string; table_name: string; record_id: string; fields: Record<string, any>; }; const response = await this.axiosInstance.patch( `/${base_id}/${table_name}/${record_id}`, { fields } ); return { content: [{ type: "text", text: JSON.stringify(response.data, null, 2), }], }; }
- src/index.ts:297-322 (registration)Registration of the update_record tool, including its name, description, and input schema definition.{ name: "update_record", description: "Update an existing record in a table", inputSchema: { type: "object", properties: { base_id: { type: "string", description: "ID of the base", }, table_name: { type: "string", description: "Name of the table", }, record_id: { type: "string", description: "ID of the record to update", }, fields: { type: "object", description: "Record fields to update as key-value pairs", }, }, required: ["base_id", "table_name", "record_id", "fields"], }, },
- src/index.ts:300-321 (schema)Input schema definition for the update_record tool, specifying parameters like base_id, table_name, record_id, and fields.inputSchema: { type: "object", properties: { base_id: { type: "string", description: "ID of the base", }, table_name: { type: "string", description: "Name of the table", }, record_id: { type: "string", description: "ID of the record to update", }, fields: { type: "object", description: "Record fields to update as key-value pairs", }, }, required: ["base_id", "table_name", "record_id", "fields"], },