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

Blog Entries

FileMaker Magazin

Example Databases

💬 Ask a question or report a problem


Start Chat