FileMaker

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

FileMaker is in the process of moving away from the XML and PHP interfaces and replacing them with the FileMaker Data API. At the same time they’re also rebuilding the FileMaker Server admin console. One of the casualties of this process is there’s now no way to enable or disable XML or PHP from the […]

Continue Reading

Recently we inherited a new project where FileMaker was being used to manage the content for a website, with an ODBC connection updating the MySQL database behind the site. The previous developers were using numeric IDs to link from page to page and category to category to sub-category to company etc. While this was certainly […]

Continue Reading