This returns a simple JSON object with one name/value pair. Therefore, I will provide some basic information on JSON syntax here. There is a ton of information and material on learning about JSON, but very little on how it pertains to using it as a FileMaker developer. Quick JSON Reference for FileMaker Developers

Using JSON to pass multiple parameters is easier and less error prone than previous methods (like return- or pipe-delimited lists) because FileMaker’s built-in JSON functions auto-encode and auto-decode potentially problematical characters (such as quotation marks, hard returns, tabs and backslashes).

It is a convenient and popular way to store structured data as a simple text string.

JSON is THE standard used by many APIs and web services, including the FileMaker API.

It’s native: JSON specific functions have been included in FileMaker since version 16.

JSON is easy to use and offers a simple structure of organization that helps provide standardization and cleaner code.

Why should all FileMaker developers learn JSON? Despite your experience (or comfort) level with JavaScript, JSON is nothing more than a great way to store and pass structured data (even related data) as a single text string that is easy for both humans and computers to understand.

Regardless of whether you are an experienced FileMaker developer or if you have only the barest inkling of what JSON is, not to worry, this article is designed for FileMaker developers of all skill levels.Īs I mentioned in a related article Jotform to FileMaker, JSON is simply a type of structured text formatting and stands for “JavaScript Object Notation”.

Today we are going to look at a way to use JSON for passing multiple parameters to a FileMaker script.

Filemaker 18 send mail