Monkeybread Software - MBS FileMaker Plugin: Component: JSON

Components	All	New	MacOS		Windows		Linux		iOS
Examples	Mac & Win		Server	Client	Guides	Statistic	FMM	Blog	Deprecated	Old

Component: JSON

Parse or build JSON texts.

Version	macOS	Windows	Linux	Server	iOS SDK
2.7 / 15.0	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ 97%

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.AddValueToArray Adds a value to an array.	All 14.1
JSON.AddValueToObject Adds a new entry to the object with the given name and value.	All 14.1
JSON.ArraySlice New in 15.0 Slices a JSON array.	All 15.0
JSON.ClearVariables New in 15.0 Clears the variables.	All 15.0
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.CurrentMatch Queries JSON for current match in JSON.ReplaceEvaluate function.	All 14.2
JSON.CurrentMatchPath Queries JSON for current match path in JSON.ReplaceEvaluate function.	All 14.2
JSON.DeleteItemFromArray Deletes an item from an array.	All 2.7
JSON.DeleteItemFromObject Deletes item from an object.	All 2.7
JSON.DeleteRecord Deletes an existing record in a table in one line using JSON.	All 14.4
JSON.DeleteRecords Deletes existing records in a table in one line using JSON.	All 14.4
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 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.Flatten Flattens a json object or array to a single depth object of key-value pairs.	All 13.5
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 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.SetBaseFields Sets the names of the base fields per record.	All 14.2
JSON.Import.SetExtraField Sets the extra field to add to all tables.	All 14.2
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.InsertOrUpdateRecord Inserts or updates a record in a table in one line using JSON.	All 14.4
JSON.InsertRecord Inserts a new record in a table in one line using JSON.	All 14.4
JSON.InsertRecords Inserts multiple records in a table in one line using JSON.	All 14.5
JSON.IsValid Checks if JSON text is valid.	All 6.3
JSON.JSONPatch.ApplyPatch Applies a patch to a json document.	All 14.0
JSON.JSONPatch.FromDiff Create a JSON Patch from a diff of two json documents.	All 14.0
JSON.List Lists all IDs of current JSON objects.	All 12.5
JSON.Merge Merges multiple JSON objects or arrays.	All 14.2
JSON.MergePatch.ApplyPatch Applies a merge patch to a json document.	All 14.0
JSON.MergePatch.FromDiff Create a JSON Merge Patch from a diff of two json documents.	All 14.0
JSON.Parse Parses JSON text and return reference number.	All 6.0
JSON.Query Performs a JSON Path query.	All 13.5
JSON.Release Frees a json reference number.	All 6.0
JSON.ReleaseAll Releases all JSON objects.	All 6.0
JSON.Replace Searches for all values that match the JSONPath expression and replaces them with the specified value.	All 13.5
JSON.ReplaceEvaluate Searches for all values that match the JSONPath expression and replaces them with the result of the evaluation.	All 14.2
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.Search Performs a JMESPath query.	All 13.5
JSON.SetPathItem Sets a value in a JSON hierarchy.	All 6.1
JSON.SetVariables New in 15.0 Creates local variables in script for JSON.	All 15.0
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
JSON.Unflatten Unflattens that object back to the original json.	All 13.5
JSON.UpdateRecord Update an existing record in a table in one line using JSON.	All 14.4
JSON.UpdateRecords Updates existing records in a table in one line using JSON.	All 14.4
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

112 functions shown.

These functions require a license (60%).

Release notes

Version 15.1
- Added flag 2048 for JSON.Import and XML.Import functions to check field types and convert number, time, date and timestamp if needed.
Version 15.0
- Added JSON.SetVariables and JSON.ClearVariables.
- Fixed an insufficient escaping for JSON.SortWithEvaluate function, which sometimes caused an internal error and prevented sorting.
- Improved JSON.SetVariables and XML.SetVariables functions to work better with multi line texts.
Version 14.5
- Added JSON.InsertRecords function to insert array of records in JSON.
- Improved JSON.InsertRecord to be a bit faster and data type conversion to do numbers and texts, too.
Version 14.4
- Added JSON.InsertRecord and JSON.InsertOrUpdateRecord functions.
- Added JSON.UpdateRecord and JSON.UpdateRecords functions.
- Added JSON.DeleteRecord and JSON.DeleteRecords functions.
- Changed JSON.GetArrayItemsAsList to return empty result if JSON is empty.
- Improved JSON functions to return error if you pass non JSON parameters to JSON.AddItemToArray, JSON.AddItemToObject, JSON.Replace and related functions.
Version 14.3
- Fixed JSON.GetArraySize to return no error for empty JSON and just return zero.
- Fixed JSON.GetPathItem to not return error for invalid JSON if flag 2 is used.
- Improved JSON.Import to report SQL statements in the error list for JSON.Import.Errors alongside the error messages.
- Improved JSON.SetPathItem to take the given value as text if it doesn't parse as JSON.
- Reimplemented JSON.IsValid using newer JSON functions internally, so it catches more errors.
Version 14.2
- Added JSON.Merge function.
- Added JSON.ReplaceEvaluate function and related JSON.CurrentMatch and JSON.CurrentMatchPath functions.
- Added flag value 2 for JSON.ToHTML function to process embedded JSON.
- Added JSON.Import.SetExtraField and JSON.Import.SetBaseFields functions.
- Improved Matrix.HTML and JSON.ToHTML to use CSS for right alignment.
Version 14.1
- Added JSON.AddValueToArray and JSON.AddValueToObject functions.
- Added KeyToCopy parameter to JSON.JSONPatch.FromDiff to copy primary keys.
- Changed JSON.Replace to accept text or number as replacement and convert it to JSON internally automatically instead of returning a parsing error.
- Fixed an edge case with JSON.Replace where it didn't catch all spots.
Version 14.0
- Added JSON.JSONPatch.ApplyPatch, JSON.JSONPatch.FromDiff, JSON.MergePatch.ApplyPatch and JSON.MergePatch.FromDiff functions.
- Fixed an endless loop in JSON.Search function with a bad query. Now propergates the error properly.
- Improved handling of arrays for our JSON to HTML conversion in JSON.ToHTML function.
- Improved performance for newer JSON functions.
Version 13.5
- Added JSON.Query function for JSON Path queries.
- Added JSON.Replace to replace within a JSON.
- Added JSON.Search to perform JMESPath queries in FileMaker.
- Added new flags 512 to ignore duplicates (with FileMaker's validation) and 1024 to not create UUID fields to XML.Import and JSON.Import functions.

Blog Entries

FileMaker Magazin

Example Databases

💬 Ask a question or report a problem