get_record
Retrieve a specific record from an Airtable base using its unique ID. Specify the base ID, table ID, and record ID to access targeted data securely via OAuth 2.0 authentication.
Instructions
Get a specific record by ID
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| base_id | Yes | The Airtable base ID | |
| record_id | Yes | The record ID | |
| table_id | Yes | The table ID or name |
Implementation Reference
- src/airtable_mcp/mcp/server.py:286-300 (handler)MCP tool handler that gets a specific Airtable record by base_id, table_id, and record_id using the authenticated AirtableClient.@self.mcp.tool(description="Get a specific record by ID") async def get_record( base_id: Annotated[str, Field(description="The Airtable base ID")], table_id: Annotated[str, Field(description="The table ID or name")], record_id: Annotated[str, Field(description="The record ID")], ) -> dict[str, Any]: """Get a specific record by ID.""" client = await self._get_authenticated_client() record = await client.get_record(base_id, table_id, record_id) return { "id": record.id, "fields": record.fields, "createdTime": record.created_time, }
- Pydantic schema defining the input arguments for the get_record tool.class GetRecordArgs(BaseArgs): """Arguments for get_record tool.""" base_id: str = Field(description="The Airtable base ID") table_id: str = Field(description="The table ID or name") record_id: str = Field(description="The record ID")
- AirtableClient helper method that makes the HTTP GET request to retrieve the specific record from the Airtable API.async def get_record( self, base_id: str, table_id: str, record_id: str, ) -> AirtableRecord: """Get a specific record by ID. Args: base_id: The Airtable base ID table_id: The table ID or name record_id: The record ID Returns: The requested record """ logger.info(f"Getting record {record_id} from {base_id}/{table_id}") response = await self._make_request( "GET", f"/v0/{base_id}/{table_id}/{record_id}", response_model=AirtableRecord, ) return response