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: 12.0 12.1 12.2 12.3 12.4 12.5 13.0 13.1 13.2 13.3 Statistic FMM Blog

Component: JSON

Parse or build JSON texts.

Version	macOS	Windows	Linux	Server	iOS SDK
2.7 / 13.3	✅ 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.FilterObjectArray New in 13.3 Filters JSON object array to find matching entries.	All 13.3
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.GetArrayItemsAsQuickList New in 13.3 Queries array values as QuickList.	All 13.3
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.List Lists all IDs of current JSON objects.	All 12.5
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.Text Queries JSON as text.	All 13.0
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

85 functions shown.

These functions require a paid license (56%).

Release notes

Version 13.1
- Fixed a crash in JSON.ToHTML function.
Version 13.0
- Added JSON.Text function.
- Changed JSON.SetPathItem to do nothing if value is empty (like v12.4 and before).
- Fixed a crash in JSON function when parsing invalid JSON code, broken in 12.5 while fixing another bug.
Version 12.5
- Added FM.SQL.List, JSON.List, Matrix.List, MongoDB.List and XML.List functions.
- Fixed a problem with JSON.IsValid accepting garbage characters behind parsing.
- Fixed a regression in JSON.GetPathItem and JSON.SetPathItem to restore functionality, where you just grab an array item with just an index.
- Fixed JSON.Colorize to work better with color for keys in nested objects.
- Fixed problem in JSON.GetStringValue crashing for invalid JSON.
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.

Blog Entries

FileMaker Magazin

Example Databases

💬 Ask a question or report a problem