Reads the full OData $metadata document of the FileMaker database (EDMX/XML). Contains all tables, fields, types, and relationships.

Lists all available EntitySets (tables/layouts) of the FileMaker database.

Query records from a FileMaker table. Supports OData $filter, $select, $top, $skip, $orderby, $expand, $count. Default limit: 100 records (override with $top).

Read a single FileMaker record by ROWID.

Create a new record in a FileMaker table.

Update an existing FileMaker record by ROWID (PATCH).

Delete a FileMaker record by ROWID.

Run a FileMaker script. Returns scriptResult with code and resultParameter.

Create a new table in the FileMaker database (schema modification via OData).

Add a new field to an existing FileMaker table. SQL-style field types: VARCHAR(n), INT, NUMERIC, DATE, TIME, TIMESTAMP, BLOB.

Execute multiple OData GET requests in a single HTTP call (batch). Use individual tools for write operations.

Creates a test record with a test tag. tagField must be an existing text field in the FM table. Returns ROWID for later validation and cleanup.

Deletes all test records marked with a specific tag. tagField must be an existing text field in the FM table.

Validates that a FileMaker record contains the expected field values. Returns PASS/FAIL with diff.

Checks whether a query returns the expected number of records. Useful for validating script results.

Runs a FileMaker script and checks whether the result code matches the expected value.

Analyzes the database structure: lists tables or shows all fields of a table with native FM field types from $metadata.

Sets global fields via FileMaker Data API (not OData). Opens a Data API session, sets the globals, then closes the session. Keys must be fully qualified: 'Table::FieldName_g'.

Sets global fields and runs a script in the SAME Data API session. This makes scripts that depend on global fields for context work (e.g. SESSIONS::UUID_g). Flow: Login → Set Globals → Run Script → Logout.