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 / 14.2 ✅ 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.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   New in 14.2
Queries JSON for current match in JSON.ReplaceEvaluate function.
All
14.2
JSON.CurrentMatchPath   New in 14.2
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.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   New in 14.2
Sets the names of the base fields per record.
All
14.2
JSON.Import.SetExtraField   New in 14.2
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.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   New in 14.2
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   New in 14.2
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.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
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

102 functions shown.

These functions require a license (58%).

Release notes

Blog Entries

FileMaker Magazin

Example Databases