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

  • $search query option

  • $expand (supported only as part of a $crossjoin operation)

  • lambda operators any and all

  • $filter on expanded entities

  • built-in canonical functions and operators:

    • indexof()

    • fractionalseconds()

    • isof()

    • geo.distance()

    • geo.length()

    • geo.intersects()

In addition, the following actions are not supported:

  • access to data in external ODBC data sources

  • use of FileMaker plug-ins

  • script trigger activation through user interaction; OData activates script triggers only by running a FileMaker script

  • access to the server machine’s file system within a script; for example, OData does not support the Get (TemporaryPath) function