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:
9.3
9.4
9.5
10.0
10.1
10.2
10.3
10.4
10.5
11.0
Statistic
FMM
Blog
Component: JSON
Parse or build JSON texts.
Item | Details |
---|---|
Dictionary.ToJSON Returns JSON representation of dictionary for data exchange. | All 6.1 |
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 |
80 functions.
Release notes
- 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.
- Version 10.3
- Added JSON.GetBooleanValue function.
- Added JSON.ToXML function.
- Fixed JSON.GetPathItem to not complain about out of bounds if option value 2 is used.
- Version 10.2
- Added JSON.AddArrayToArray function.
- Added JSON.SortWithEvaluate function to sort JSON objects or arrays with custom expression.
- Version 10.0
- Added JSON.EqualContent function.
- Added parameter to JSON.FindValueInArray and JSON.FindValueInObjectArray to compare by content.
- Changed JSON functions to pass through floating numbers as is without rounding, in JSON.CreateNumber, JSON.AddNumberToArray and others.
- Version 9.4
- Improved pretty formatting for JSON arrays in JSON.Format.
- Version 9.3
- Added JSON.Import.ErrorCount, JSON.Import.Errors, XML.Import.ErrorCount, XML.Import.Errors.
- Added JSON.Sort function.
- Changed JSON.GetValue to pass number via string to avoid double rounding.
- Fixed HTML tag for JSON.ToHTML.
- Version 9.2
- Changed JSON.SetPathItem to create objects if they are missing.
- Version 9.0
- Added JSON.CreateValue, JSON.Equals, JSON.FindValueInArray and JSON.FindValueInObjectArray functions.
- Version 8.4
- Fixed JSON.ToHTML to return text with CR as line ending.
- Version 8.3
- Changed JSON.ToHTML to use @attributes with lowercase a.
- Fixed crash in JSON.GetArrayItemsAsList for undefined values.
- Version 8.2
- Added JSON.Colorize and JSON.ToHTML functions.
- Improved JSON.AddNumberToArray and JSON.AddNumberToObject to handle large numbers better.
- Version 8.1
- Added ReturnValues parameter for JSON.GetArrayItemsAsList function.
- Fixed JSON.GetPathItem returning numbers with dot incorrectly for non-english localization. Broken in 7.5.
- Version 8.0
- Added JSON functions for LDAP: LDAP.AddJSON, LDAP.JSON and LDAP.ModifyJSON.
- Fixed JSON.CreateNumber to return 0 for empty string.
- Version 7.5
- Added flag for JSON.GetPathItem to avoid returning error for missing keys.
- Version 7.1
- Added JSON.GetArrayPathItems function.
Blog Entries
- New in MBS FileMaker Plugin 10.5
- 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
- What is new in the MBS FileMaker Plugin Version 10.3
- FileMaker records to XML or JSON
- News about the MBS FileMaker Plugin 10.2
- Sort with evaluate in FileMaker
- The new JSON.EqualContent function
Example Databases
- CURL/Email/IMAP Email List
- CURL/WebServices/CURL FMS Admin API v17
- CURL/WebServices/Google Maps API/Google Maps API
- CURL/WebServices/WeatherBit.io test
- DynaPDF/PDF JSON
- JavaScript/JavaScript
- JSON/JSON Import
- Mac and iOS/Machine Learning/Core Image Detection
- Mac and iOS/MapKit/MapView BeeExample
- Win Only/Windows Location
Feedback: Report problem or ask question.

Links
MBS FileMaker tutorial videos