FileMaker ODataInstall

Summary

Retrieve multiple records from a specified FileMaker table with flexible OData query options to filter, select fields, expand relations, order results, paginate, and optionally include the total count.

Inputs

• Table Name (required) — The name of the FileMaker table to query.
• Options — Various query options including Filter (OData $filter expression), Select Fields (specific fields to return), Expand Relations (navigation properties to expand), Order By (field to sort by with direction), Limit (maximum number of records to return), Skip (number of records to skip for pagination), and Include Count (whether to include the total count of matching records).

Output shape

a list of record objects matching the query parameters, each as a JSON object; optionally includes a separate item with the total count under key '@odata.count' if requested.

The result array contains an item per returned record. If the Include Count option is enabled, an additional item with the total count of matched records is appended. Supports pagination and field selection to control data volume. Errors yield a failure unless 'Continue On Fail' is enabled, in which case error details are output per item.