FileMaker Data API

Director Steve Winter presented his session title ‘Explore cURL for FileMaker’ at the Scandanavia FileMaker Developer Conference in Helsingør, Denmark. Summary Accessing data through REST is the current best-practice for data sharing. That’s not always been easy with FileMaker. Until now! In version 16 FileMaker introduced the FileMaker REST API which allows far easier integration […]

Continue Reading

Uploading files Dropzone is already enabled for the file upload, it just needs something to do with the files which it receives. The Postman example File upload gives us a good starting point because it shows us the name the file needs to be given when it’s uploaded, but it masks one very important aspect […]

Continue Reading

Populate ‘latest clients’ table We want to populate the table at the base of the page with the five most recently added contacts from the database. This means setting the _limit and _sort query parameters appropriately. If you look closely at the Postman Get multiple records, limit, offset, sort example you’ll see that this pretty […]

Continue Reading

Logging users in Now that we’ve got the unauthenticated components of the site done we need to work on getting users logged in. To do that we need to make some changes: Create a logUserIn() method which will accept user input and call your fetchToken() method. You may need to adjust that depending on how […]

Continue Reading

Connecting from the backend Our backend application, in the Backend resources folder, is a Symfony 4 web app. You can find out more about Symfony from the project website, but in short it’s a modern PHP development framework, on which several of the leading PHP projects, like Laravel, Drupal and Concrete (to name a few) are […]

Continue Reading

Connecting from the frontend JavaScript running in a browser is able to perform an XMLHttpRequest from the browser to a web server. The simplest way to implement that is using an AJAX (asynchronous JavaScript and XML) request. You could connect directly to the XMLHttpRequest API yourself, but that makes things way more complicated than they […]

Continue Reading

In this activity we’re going to work in FileMaker to replicate the queries made in the previous exercise with Postman. This provides an opportunity to interact with the FileMaker Data API in a programming environment I hope you’re familiar with. It may also provide an opportunity to learn about interacting with external APIs in FileMaker […]

Continue Reading

Now that we’ve got our interface file in place it’s time to start interacting with it using the FileMaker Data API. Initially we’re going to use Postman, an API development and testing tool to try out the various options that are available to us. If you don’t have Postman installed, grab it form their downloads […]

Continue Reading

To get started we need an interface file on our FileMaker server which we can use for all of the following activities. From the session resources locate the file InterfaceTemplate.fmp12 in the Databases folder. Make a copy and rename it – my advice is to never use spaces in files which are going to be accessed […]

Continue Reading

If you’re reading this post it’s probably because you’re preparing for FileMaker DevCon 2019, are signed up to attend the FileMaker Data API Training Day session, and are looking to ensure you have everything you need set up on your laptop. If so, you’re in the right place! If not, feel free to have a […]

Continue Reading