get_record
Retrieve a specific Airtable record by providing its base, table, and record IDs to access structured data through authenticated API calls.
Instructions
Get a specific record by ID
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| base_id | Yes | The Airtable base ID | |
| table_id | Yes | The table ID or name | |
| record_id | Yes | The record ID |
Implementation Reference
- src/airtable_mcp/mcp/server.py:286-300 (handler)MCP tool handler function for 'get_record' that authenticates, calls AirtableClient.get_record, and formats the response.@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 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 performs the actual HTTP GET request to retrieve a specific record from 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
- src/airtable_mcp/mcp/server.py:286-286 (registration)FastMCP tool registration decorator for the get_record handler.@self.mcp.tool(description="Get a specific record by ID")