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
- GraphicsMagick in FileMaker, part 19
- Store containers in a MongoDB
- New in MBS FileMaker Plugin 11.4
- MBS FileMaker Plugin, June 2021 News
- MBS Plugin Quiz
- MBS FileMaker Plugin 11.1
- FileMaker Developers in Southern California
- New in MBS FileMaker Plugin 10.5
- MBS FileMaker Plugin 10.5 - More than 6400 Functions In One Plugin
- Embrace JSON
FileMaker Magazin
- Ausgabe 6/2022, Seite 26
- Ausgabe 5/2022, Seite 28
- Ausgabe 3/2022, Seite 26 bis 27
- Ausgabe 3/2022, Seite 24
- Ausgabe 2/2022, Seite 33, PDF
- Ausgabe 6/2021, Seite 23
- Ausgabe 6/2020, Seite 26, PDF
- Ausgabe 5/2020, Seite 15 bis 20, PDF
- Ausgabe 5/2018, Seite 24 bis 25, PDF
- Ausgabe 3/2018, Seite 34, PDF
Example Databases
- CURL/Email/IMAP Email List
- CURL/WebServices/CURL FMS Admin API v17
- CURL/WebServices/CURL FMS Admin API v18
- CURL/WebServices/Google Maps API/Google Maps API
- DynaPDF/PDF JSON
- JSON/JSON to HTML
- Mac and iOS/Machine Learning/Core ML Photos
- Mac only/ImageCapture/Camera Import
- Utility functions/Proj/PROJ Library
- XML/XML and JSON
