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 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
- JSON Transactional Edits in FileMaker 16 – Using JSON to more easily allow a Browse and an Edit mode in FileMaker (free download available)
- Overview: better script parameters – Using JSON to send multiple script parameters
- FileMaker 16: Passing Multiple Parameters Natively Using JSON – Another look at passing multiple script parameters
- Google – Auto Complete using JSON in FIleMaker 16 – Look up contact from Google’s Auto Complete
- JSON + Virtual List – Using JSON to populate virtual lists (see part two, also, and download the free files at each link)
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.