Integrating FileMaker with Zapier and Make

Intermediate

Connect FileMaker to no-code automation platforms via the Data API, building custom Zaps and Make scenarios that respond to FM record changes.

What you'll learn

  • How to trigger Zapier/Make from FileMaker using Insert from URL
  • How to call the FM Data API from a Zapier webhook action or Make HTTP module
  • How to authenticate FM API calls securely from within Zapier/Make
  • How to handle FM find errors (error 401) gracefully in automation workflows

Zapier and Make (formerly Integromat) can connect FileMaker to hundreds of other apps without custom code. The approach: a webhook trigger in FM pushes an event to Zapier/Make when a record changes, or a Zap/scenario polls a middleware endpoint. From there, standard Zap actions write back to FM via the Data API. Understanding the FM side of this connection is what differentiates robust integrations from fragile ones.

1/4
1

Triggering Zapier from a FileMaker script

Every Zap that starts with "Webhooks by Zapier" gets a unique URL. Post to it from Insert from URL when a record is committed. Include enough field data in the payload for the downstream Zap steps.

FileMaker Script
// Script: NotifyZapier (called by OnRecordCommit)
Set Variable [ $payload ; Value:
  JSONSetElement ( "{}" ;
    ["recordId" ; Get ( RecordID ) ; JSONString] ;
    ["Name" ; Orders::CustomerName ; JSONString] ;
    ["Amount" ; Orders::TotalAmount ; JSONNumber] ;
    ["Status" ; Orders::Status ; JSONString]
  )
]
Set Variable [ $opts ; Value:
  "--request POST --header "Content-Type: application/json"" &
  " --data " & Quote ( $payload ) &
  " --max-time 5"
]
Insert from URL [ Select ; With dialog: Off ; Target: $r ; "https://hooks.zapier.com/hooks/catch/XXXXX/YYYYY/" ; cURL options: $opts ]

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

Sign in to FM Dojo