Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
10.5
11.0
11.1
11.2
11.3
11.4
11.5
12.0
12.1
12.2
Statistic
FMM
Blog
Component: JSON
Parse or build JSON texts.
Version | macOS | Windows | Linux | Server | iOS SDK | License |
2.7 / 10.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ 96% | Paid |
Item | Details |
---|---|
Dictionary.ToJSON Returns JSON representation of dictionary for data exchange. | All 6.1 |
FM.SQL.JSONColumn Returns a column as JSON array. | All 10.5 |
FM.SQL.JSONRecord Returns a row as JSON object. | All 8.1 |
FM.SQL.JSONRecords Returns rows as JSON array. | All 8.1 |
JSON.AddArrayToArray Adds an array to an existing array. | All 10.2 |
JSON.AddBooleanToObject Adds a boolean value to an array. | All 6.0 |
JSON.AddFalseToObject Adds a new entry to the object with the given name and a boolean false value. | All 2.7 |
JSON.AddItemToArray Adds an item to an array. | All 2.7 |
JSON.AddItemToObject Adds a new entry to the object with the given name and value. | All 2.7 |
JSON.AddNullToObject Adds a new entry to the object with the given name and a null value. | All 2.7 |
JSON.AddNumberToArray Adds a number to an array. | All 4.3 |
JSON.AddNumberToObject Adds a new entry to the object with the given name and value. | All 2.7 |
JSON.AddStringToArray Adds a string to an array. | All 4.3 |
JSON.AddStringToObject Adds a new entry to the object with the given name and value. | All 2.7 |
JSON.AddTrueToObject Adds a new entry to the object with the given name and a boolean true value. | All 2.7 |
JSON.Clone Creates a clone of the json. | All 6.1 |
JSON.Colorize Formats a JSON string with color. | All 8.2 |
JSON.Compact Returns compact unformatted JSON for the given JSON text. | All 2.7 |
JSON.CreateArray Creates new array. | All 2.7 |
JSON.CreateArrayRef Creates empty array reference. | All 6.0 |
JSON.CreateBool Creates boolean JSON node. | All 2.7 |
JSON.CreateBoolean Creates a boolean node with given value. | All 6.0 |
JSON.CreateDoubleArray Creates a new JSON with a double array with given values. | All 2.7 |
JSON.CreateFalse Creates a boolean node with false value. | All 2.7 |
JSON.CreateIntegerArray Creates a new JSON with an integer array with given values. | All 4.3 |
JSON.CreateNull Creates a new NULL entry. | All 2.7 |
JSON.CreateNumber Creates a new JSON encoded number. | All 2.7 |
JSON.CreateObject Creates a new empty object node. | All 2.7 |
JSON.CreateObjectRef Creates empty object reference. | All 6.0 |
JSON.CreateString Creates a string node with given text. | All 2.7 |
JSON.CreateStringArray Creates a new JSON with a string array with given values. | All 2.7 |
JSON.CreateStringArrayWithList Creates a new JSON with a string array with given values. | All 4.1 |
JSON.CreateTrue Creates a boolean node with true value. | All 2.7 |
JSON.CreateValue Creates a new value. | All 9.0 |
JSON.DeleteItemFromArray Deletes an item from an array. | All 2.7 |
JSON.DeleteItemFromObject Deletes item from an object. | All 2.7 |
JSON.EqualContent Checks if two JSON are equal in content. | All 10.0 |
JSON.Equals Checks if two JSON are equal. | All 9.0 |
JSON.FindValueInArray Queries index of value in array. | All 9.0 |
JSON.FindValueInObjectArray Queries index of value in object array. | All 9.0 |
JSON.Format Returns pretty printed JSON for the given JSON text. | All 4.4 |
JSON.GetArrayItem Queries entry from array with given index. | All 2.7 |
JSON.GetArrayItems Queries entries from JSON array. | All 10.4 |
JSON.GetArrayItemsAsList Queries a list of all array entries. | All 4.2 |
JSON.GetArrayPathItems Queries value from JSON path in array of objects. | All 7.1 |
JSON.GetArraySize Queries the number of array entries. | All 2.7 |
JSON.GetBooleanValue Queries boolean value for JSON. | All 10.3 |
JSON.GetDoubleValue Queries a floating point value of the JSON node. | All 2.7 |
JSON.GetIntegerValue Queries integer value of the JSON node. | All 2.7 |
JSON.GetObjectItem Queries named item from an object. | All 2.7 |
JSON.GetObjectItemTree Queries named item from an object tree. | All 3.2 |
JSON.GetObjectItemTreeRef Queries named item from an object tree. | All 6.0 |
JSON.GetObjectName Queries name of item in an object. | All 4.0 |
JSON.GetObjectNameList Queries names of items in an object. | All 4.0 |
JSON.GetObjectSize Queries the number of object items. | All 4.0 |
JSON.GetPathItem Queries value from JSON path. | All 6.1 |
JSON.GetStringValue Queries string value of the JSON node. | All 2.7 |
JSON.GetType Queries type of json object. | All 2.7 |
JSON.GetValue Queries the value of the json. | All 6.1 |
JSON.Import Imports JSON and creates tables, fields and records. | All 5.4 |
JSON.Import.Cancel Cancels current import. | All 5.4 |
JSON.Import.ErrorCount Queries error counter. | All 9.3 |
JSON.Import.Errors Queries list of error messages. | All 9.3 |
JSON.Import.Status Queries status of xml import. | All 5.4 |
JSON.Import.Todo Queries how many items are to be done for XML import. | All 5.4 |
JSON.Import.Total Queries total items to be imported. | All 5.4 |
JSON.Import.Work Performs import. | All 5.4 |
JSON.IsValid Checks if JSON text is valid. | All 6.3 |
JSON.Parse Parses JSON text and return reference number. | All 6.0 |
JSON.Release Frees a json reference number. | All 6.0 |
JSON.ReleaseAll Releases all JSON objects. | All 6.0 |
JSON.ReplaceItemInArray Replaces an item in an array with new item. | All 4.3 |
JSON.ReplaceItemInObject Replaces an item in an object with new item. | All 4.3 |
JSON.SetPathItem Sets a value in a JSON hierarchy. | All 6.1 |
JSON.Sort Sorts the JSON array/object. | All 9.3 |
JSON.SortWithEvaluate Sorts the JSON array/object using an expression to evaluate. | All 10.2 |
JSON.ToHTML Converts JSON to HTML. | All 8.2 |
JSON.ToXML Converts JSON to XML. | All 10.3 |
LDAP.AddJSON Adds an entry to a tree. | Mac/Win/Linux 8.0 |
LDAP.JSON Queries JSON structure of LDAP data. | Mac/Win/Linux 8.0 |
LDAP.ModifyJSON Changes an existing entry. | Mac/Win/Linux 8.0 |
81 functions shown.
Release notes
- Version 12.2
- Added new optional RootTableName parameter for JSON.Import function.
- Version 12.1
- Added darkMode parameter for XML.Colorize and JSON.Colorize function.
- Fixed an issue with JSON.GetDoubleValue and related functions not passing number back with comma (and used dot) where comma would be appropriated. Broken in 12.0.
- Version 12.0
- Fixed JSON functions to return NULL for numbers with no content, e.g. empty text. This affects JSON.CreateNumber, Dictionary.ToJSON, FM.SQL.JSONColumn, FM.SQL.JSONRecord and FM.SQL.JSONRecords functions.
- Version 11.5
- Added StartIndex parameter to JSON.FindValueInArray and JSON.FindValueInObjectArray functions, so you can repeat search until nothing more is found.
- Fixed a bug in JSON.ToHTML function.
- Fixed a problem in JSON.Colorize function with coloring arrays.
- Version 11.4
- Fixed a crash in JSON.GetObjectItem with big JSON arrays.
- Version 11.3
- Changed JSON.GetObjectItemTree, JSON.GetObjectItemTreeRef, JSON.AddArrayToArray and JSON.AddItemToArray to ignore empty parameters.
- Changed JSON.Import and XML.Import to be per thread, so they work better on server with multiple parallel scripts.
- Version 11.2
- Changed JSON.Parse to be accept leading zeros on numbers.
- Fixed JSON.Format to not return reference number for JSON reference numbers as input, broken in 11.1.
- Version 10.5
- Added flags for JSON.GetArrayItem, so result can be JSON, reference or now value.
- Changed JSON.ToXML to unpack attributes with just @ in front.
- Version 10.4
- Added JSON.GetArrayItems function to work with huge JSON arrays.
- Changed JSON.ToXML to recreate attributes stored as @attributes entry by XML.ToJSON function.
Blog Entries
- MBS FileMaker Plugin, version 11.6pr3
- FileMaker Developers in Southern California
- Neues MBS FileMaker Plugin 10.5 - Über 6400 Funktionen in einem Plugin
- MBS FileMaker Plugin 10.5 - More than 6400 Functions In One Plugin
- Embrace JSON
- Playing with Machine Learning on Windows
- FileMaker records to XML or JSON
- Sort with evaluate in FileMaker
- The new JSON.EqualContent function
- Core Location Geocoder with JSON
FileMaker Magazin
- Ausgabe 2/2022, Seite 33
- Ausgabe 6/2021, Seite 23
- Ausgabe 6/2020, Seite 26, PDF
- Ausgabe 5/2020, Seite 20, PDF
- Ausgabe 5/2020, Seite 19, PDF
- Ausgabe 5/2020, Seite 18, PDF
- Ausgabe 5/2020, Seite 17, PDF
- Ausgabe 5/2020, Seite 16, PDF
- Ausgabe 5/2020, Seite 15, PDF
- Ausgabe 5/2018, Seite 25, PDF
Example Databases
- Barcode/Swiss QR-Code for invoices/Swiss QR-Code for invoices ISO 20022
- CURL/Email/IMAP Email List
- CURL/Email/IMAP Email
- CURL/WebServices/CURL FMS Admin API v17
- CURL/WebServices/CURL FMS Admin API v18
- CURL/WebServices/Query IP and Country
- Mac and iOS/Machine Learning/Core Image Detection
- Mac only/ImageCapture/Camera Import
- Network/Bonjour
- XML/XML to JSON
Videos
- Presentation from June 2020
- MBS FileMaker Plugin, June 2021 News
- MBS Plugin Präsentation von der FileMaker Konferenz 2019
- FileMaker Developers in Southern California
- Communication with an API with help of JSON
- Kommunikation mit einer API mit Hilfe von JSON
- FileMaker Developer Conference 2019 Presentation
- FileMaker Developer Conference 2018 Presentation
Feedback: Report problem or ask question.
