Building a custom Tableau® Connector for Claris® FileMaker® enables faster, more reliable and more flexible connections between Tableau and FileMaker datasources, compared with the legacy Web Data Connector.
For a number of Beezwax client projects, we’ve installed and deployed a Tableau Connector (aka “TACO”) for FileMaker. The TACO was built using the Tableau Connector SDK (provided by Tableau) to connect to datasources on FileMaker Server. The TACO method uses JDBC rather than the FileMaker Data API for the connection between FileMaker and Tableau, and in our testing the performance of data extracts was up to 10 times faster.
Continue reading “A fast, flexible Tableau Connector for FileMaker”
This blog post is the second of a three-part series about the FileMaker OData API, introducing a demo file with more than 40 examples plus helpful tips, along with Q&A. Part one of the series highlighted some of the key features of the API which make it an exciting addition to the FileMaker platform. As a follow-up, this post will cover the basics and dig into the nuances of using OData with Claris FileMaker.
Continue reading “OData for FileMaker – Examples, Tips and Nuances”
We often work on projects that intersect two technologies near and dear to us: FileMaker and Ruby. This allows us to build robust web applications in Ruby on Rails, integrated with data sources from FileMaker solutions. When Claris introduced the FileMaker Data API we were naturally curious to try it out. At the time there was no off-the-shelf Ruby library for us to simply
gem install, so we decided to roll up our sleeves and build one. Thus, fmrest-ruby was born.
This article will walk you through setting up and using fmrest-ruby in a Ruby on Rails project. Some level of familiarity with Ruby/Rails and FileMaker’s Data API is advised, although much of the content covered here is applicable to any Ruby project, Rails or not.
Continue reading “Integrating FileMaker’s Data API and Ruby with the fmrest-ruby gem”
This blog post is the first in a three-part series about the FileMaker OData API, highlighting key features that make it an exciting addition to the Claris FileMaker platform.
Continue reading “OData for FileMaker – New Player in an Old Game”
FileMaker 19 introduced a couple of important new features related to using the FileMaker Data API. Here, we’ll cover an overview of the new authorization endpoint,
Validate Session, API versioning updates, as well as a new script step,
Execute FileMaker Data API.
At the end of this article, you’ll find the demo file for learning more and trying out various REST and cURL functionality with FileMaker’s Data API. Enjoy!
Continue reading “Using REST and cURL with FileMaker 19’s Data API”
Well, here we are again! With the release of FileMaker 18 we get the third version of the FileMaker Data API. This version brings an iterative advancement in features while maintaining the core functionality that was introduced with V1 of the API in FileMaker Server 17.
I’m following suit with an iterative advancement of my previous blog posts about the Data API (here and here).
Continue reading “Using REST and cURL with FileMaker Server 18’s Data API”
“Hey Siri…Ask FileMaker…”
This story started when we explored iOS Shortcuts to the FileMaker Data API. As we continue to automate tasks by mixing together iOS apps, content on mobile devices and web APIs plus FileMaker, let’s add to our workflow using one of the most powerful functions available to iPhone and iPad users: Siri.
Continue reading “Using Siri with FileMaker, via iOS Shortcuts”
Shortcuts, on iOS, are a new way to automate tasks by mixing together apps, content on your iOS device and web APIs into custom workflows. Now, via the FileMaker Data API, you can use shortcuts as a way to interact with your FileMaker solutions.
Here’s an example of automatically uploading a photo from your iPhone into a FileMaker container field, via iOS shortcuts to the FileMaker Data API.
Continue reading “iOS Shortcuts to the FileMaker Data API”
I’m always excited each time the FileMaker Platform gets new capabilities. It isn’t just the new features on their own that make things interesting, but what happens to the platform as a whole which provides for some interesting and inspiring innovations. In this case, it is a new way to do transactional record editing in FileMaker. This is the first in a multi-part series on this topic.
Continue reading “How Transactional is the FileMaker Data API?”
As y’all probably know by now, FileMaker 17 has been released, including the first production edition of FileMaker Server’s Data API. This API was originally released with FileMaker 16, but only as a “beta”, expiring September 2018. As you might expect, the FileMaker 17 Data API introduces significant changes. This means that any applications written against the FM 16 Data API need to be refactored for compatibility with FileMaker 17. And that’s the work we’re here to do!
Continue reading “Using REST and cURL with FileMaker 17’s Data API”
If you are FileMaker developer, but new to the notion of web APIs and web development in general, then you might take on a kind of deer-in-the-headlights look when confronted with FileMaker Server 16’s new Data API, aka “REST API”. Fear Not! It really is simpler and more straightforward than you might expect. I like to take the attitude that no skill is difficult, only unfamiliar. With study and repetitive exposure and practice, any skill can be mastered.
Continue reading “Getting Started with REST and cURL using FileMaker 16’s Data API”