OData unsupported features

These OData features from the intermediate conformance level are not supported:

• $search query option

• lambda operators any and all

• built-in canonical functions and operators:

  • fractionalseconds()

  • isof()

  • geo.distance()

  • geo.length()

  • geo.intersects()

The following FileMaker features aren't supported directly by standard OData API calls:

• Access to data in external ODBC data sources

• Calculation functions in table schema (for example, calculation fields) if they depend on any of the following:

  • FileMaker plug-ins

  • Information about the host's file system (for example Get(TemporaryPath)), about FileMaker plug-ins, or about script triggers

• Script trigger activation

However, these FileMaker features are supported in scripts run by OData API calls. These are server-side scripts and behave the same as those run by the Perform Script on Server script step—which run in separate processes from those of standard OData API calls (See About running scripts on FileMaker Server and FileMaker Cloud in FileMaker Pro Help.)

Tip  If your database requires any of these FileMaker features (such as calculated fields that depend on plug-ins), implement the logic for such operations in scripts that OData API calls can execute. See Run scripts.