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: 10.1 10.2 10.3 10.4 10.5 11.0 11.1 11.2 11.3 11.4 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 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.
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.

Blog Entries

FileMaker Magazin

Example Databases

Videos

Feedback: Report problem or ask question.