Connectors / Service / Filemaker Pro

Filemaker Pro

Filemaker Pro

FileMaker is a cross-platform relational database. An application that helps you build other smaller applications.

Overview

Filemaker Pro integrates a database engine with a graphical user interface and security features. Allowing users to modify the database by dragging new elements into layouts, screens, or forms.

API INFO: The Base URL used for the Filemaker Pro connector is <user-determined-hostname>/fmi/data/vLatest/databases/<user-determined-solution-name>/layouts. More information can be found on their main API documentation (v18) site. This is where users will also be able to find the API Limitations page.

Authentication

Within the workflow builder, highlight the Filemaker Pro connector.

In the Filemaker Pro connector properties panel to the right of the builder, click on the Authenticate tab and the 'Add new authentication' button.

This will result in a Tray.io authentication pop-up modal. The first page will ask you to name your authentication and select the type of authentication you wish to create ('Personal' or 'Organisational').

The next page asks you for your 'Host (URL)' and 'Username'.

Note that in order to get the host field, you will need either a 3rd party domain server URL or the computer IP address where the Filemaker Pro database is residing.

Once you have added these fields to your Tray.io authentication popup window, click the 'Create authentication' button.

Go back to your settings authentication field (within the workflow builder properties panel), and select the recently added authentication from the dropdown options now available.

Your connector authentication setup should now be complete.

Available Operations

The examples below show one or two of the available connector operations in use.

Please see the Full Operations Reference at the end of this page for details on all available operations for this connector.

Example Usage

TRAY POTENTIAL: Tray.io is extremely flexible. By design there is no fixed way of working with it - you can pull whatever data you need from other services and work with it using our core and helper connectors. This demo which follows shows only one possible way of working with Tray.io and the filemaker-pro connector. Once you've finished working through this example please see our Introduction to working with data and jsonpaths page and Data Guide for more details.

Below is an example of a way in which you could potentially use the Filemaker Pro connector, to check and update any records within an Addon. I.e: does this persons subscription exist within the Monthly Subscription Addon?. If yes, update the Addon associated, if none exist create a new one.

The steps will be as follows:

  1. Setup using a Webhook and send preexisting record data to the workflow. Search the record data for using the UUID and reference value.
  2. Create a boolean condition to check whether the record exist within the monthly subscription addon.
  3. If found, update the record data accordingly. If non exist, create a new Addon and add it to the record.

Your completed workflow should look similar to this:

1 - Setup Trigger & search records

Select the Webhook trigger from the trigger options available. Make sure your test data is working by enabling the workflow and sending a request. Check the Debug panel for the expected output before continuing.

From the connectors panel on the left, add a Filemaker Pro connector to your workflow. Set the operation to 'Search records'.

The 'Layout' field refers to a pre-made arrangement layout created by the user for said record type. in this case, it is known as 'Monthly_Add_Ons'. See your Filemaker Pro UI for more details, specifically the record type's Layout bar:

As these records have uuid fields, this is used for the 'Field name' as it is unique and easy to query. To specify the value, start by using the list mapping icon (found next to the list input field, within the properties panel) to generate the connector-snake.

While hovering over the trigger step (with the tail end of the connector-snake), select id from the list of output properties displayed. This will auto-populate a jsonpath within your list input field, and update the type selector to jsonpath.

JSONPATHS: For more information on what jsonpaths are and how to use jsonpaths with Tray.io, please see our Intro page and Data Guide for more details.
CONNECTOR-SNAKE: The simplest and easiest way to generate your jsonpaths is to use our feature called the Connector-snake. Please see the main page for more details.

For more clarification on the pathways you have available, open the Debug panel to view your step's Input and Output.

Below is an image of what the record data Input panel would look like once the search has run.

Feel free to re-name your steps as you go along to make things clearer for yourself and other users. The operation names themselves often suffice.

This step is essentially setup for the later query. The data has been sent and the record is searched through using the field name and value specified.

2 - Does record exist?

Next, search for the Boolean connector within your connector panel, and drag it into your workflow as your next step. Set your operation to 'Boolean condition'.

The conditions are set to register whether or not this persons subscription (or record) exists within the Monthly Subscription Addon or not. If it does then the record is updated. If not, then the Addon is created.

The first condition is set up to check for the returned string No records match the request. Since then statement presented in the Boolean condition is essentially 'Record does not exist', should this be true, then the true branch follows through.

The second condition naturally results in a false condition. See the properties panels below for more details.

The Debug panel shots below demonstrate what the Output looks like depending on the results:

3 - Update or create record

Once the outcome is determined, you can add as many 'Field data' inputs as you like.

These new fields and values will become part of the record data.

BEST PRACTICES: Whenever you do decide to create your own workflow, please make sure you take a look at our Managing data best practices guide.

All Operations

Latest version:

3.1