Monkeybread Software - MBS FileMaker Plugin: Component: JSON

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: 11.2 11.3 11.4 11.5 12.0 12.1 12.2 12.3 12.4 12.5 Statistic FMM Blog

Component: JSON

Parse or build JSON texts.

Version	macOS	Windows	Linux	Server	iOS SDK
2.7 / 10.5	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ 96%

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.4
- Added flags for JSON.Import and XML.Import functions to skip table and field creation.
- Changed JSON.ToXML to better convert arrays.
- Changed JSON.ToXML to unpack the text nodes made by XML.ToJSON.
- Improved JSON.SetPathItem and JSON.GetPathItem functions to accept FileMaker's style for object/array accessing.
- Improved XML.Import and JSON.Import to better report progress on slow connections.
Version 12.3
- You can now use english spelling JSON.Colourise and XML.Colourise if you prefer to call JSON.Colorize or XML.Colorize.
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.

Component: JSON

Release notes

Blog Entries

FileMaker Magazin

Example Databases

Videos