Running FileMaker Scripts via OData

Beginner

Use OData stored procedures to trigger FileMaker scripts from an external system.

What you'll learn

  • What OData stored procedures are in FileMaker context
  • How to call a FileMaker script via OData function import
  • Passing parameters to scripts via OData
  • Reading script results from the OData response

FileMaker OData 4.0 supports stored procedures -- a mechanism to call FileMaker scripts from OData using function import requests. This is a FileMaker-specific OData extension that bridges the generic OData world with FileMaker's scripting engine. It is listed in the $metadata document under FunctionImport elements.

1/4
1

Finding scripts in $metadata

FileMaker scripts exposed as OData function imports appear in the $metadata document under FunctionImport elements inside an ActionImport or FunctionImport section:

JSON
<FunctionImport Name="CalculateShipping"
  Function="MyDB.CalculateShipping"
  EntitySet="Contacts">
  <Parameter Name="ContactID" Type="Edm.String"/>
  <Parameter Name="ShipMethod" Type="Edm.String"/>
</FunctionImport>
Real-Time Data Patterns with FileMaker ODataOData Error Handling and Debugging

Sign in to track your progress and pick up where you left off.

Sign in to FM Dojo