FileMaker OData icon

FileMaker OData

Interact with FileMaker databases via OData API

Record → Get

AI-generated

Summary

Retrieve a single record by its primary key from a specified FileMaker table using the OData API.

Inputs

  • Table Name (required) — The name of the FileMaker table to query.
  • Record Key (required) — The primary key value (UUID or ROWID) identifying the record to retrieve.
  • Options — Optional parameters to refine the retrieval, including selecting specific fields to return and expanding related navigation properties.

Output shape

a single record object with the requested fields and optionally expanded related entities, wrapped in an array with one item per input record

If multiple input items are processed, each result is output as a separate item. The operation returns all fields by default if no select fields are specified. Expanded navigation properties are included when requested. Errors for individual items can be captured if continuation on failure is enabled.

Discussion