FileMaker JSON Functions

Using FileMaker JSON Functions

Have you tried the new FileMaker 16 JSON functions?  If not, you are in for a treat.  I hadn't taken the time to explore them depth, mainly because I did not have a client needing the work who had FileMaker 16.  That changed, so I started doing research, and found a wealth of information.

JSON basic usage includes the following:

  • Creating JSON files - we're interest in doing so from FileMaker data
  • Parsing JSON files - getting what we want from a JSON document
  • Modifying JSON data in files - adding and deleting information
  • Formatting JSON documents in order to improve readability
  • Listing values from a JSON document using a path, key or index
  • Listing the keys from a path, key or index

On top of that, I found ways to use the new JSON functions to do old things in new ways, and to do them easier.

The Basics

The most useful video and post I found for dealing with JSON basics is from Jeremiah Hammond at DB Services:

The accompanying post is well written and there is free download FileMaker file with the JSON examples available, too – DB Services free FM QuickStart solution.

FileMaker's JSON tools are powerful and easy to use once you get the hang of it.  And there are innovative ways to use JSON, too.

Using JSON in Innovative Ways

I'm thinking we've just scratched the surface in this area.  Keep on the lookout for new ways to use JSON in FileMaker.


You are always a student, never a master. You have to keep moving forward.

Conrad Hall

Thanks! You've already liked this