fm_get_record
Retrieve a single FileMaker record by its primary key. Returns all fields for the matching record.
Instructions
Get a single FileMaker record by its primary key.
Use this when you know the specific record ID and want full details.
Args: table: Table name (use fm_list_tables for available tables). record_id: The primary key value to look up. id_field: The primary key field name (use fm_get_schema to find PKs).
Returns: Formatted text with all fields for the matching record.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| id_field | No | ||
| record_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |