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 New in 14.1 Adds a value to an array. | All 14.1 |
JSON.AddValueToObject New in 14.1 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.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.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.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 |
97 functions shown.
These functions require a license (61%).
Release notes
- 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.
- Version 13.4
- Changed JSON.GetStringValue, JSON.GetBooleanValue, JSON.GetDoubleValue, JSON.GetIntegerValue and JSON.GetValue to return empty result if called with empty value.
- Improved JSON.Import to better handle arrays in arrays.
- Version 13.3
- Added JSON.FilterObjectArray function.
- Added JSON.GetArrayItemsAsQuickList and QuickList.JoinJSON functions.
- Improved JSON.Text function to output less commas.
- 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.
Blog Entries
- MBS @ FMTraining.TV - New examples for FileMaker MBS Plugin
- Can FileMaker do that?
- MBS @ FMTraining.TV - The Claris FileMaker MonkeyBread Plug-in 14.0 Release
- MBS FileMaker Plugin 14.0 for Claris FileMaker
- MBS Plugin Advent calendar: 20 - MapView
- MBS Plugin Advent calendar: 2 - Vision
- Data structures in MBS Plugin
- MBS Plugin 13.5 for Claris FileMaker
- Using JSONPath in FileMaker
- GraphicsMagick in FileMaker, part 19
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
- Ausgabe 6/2021, Seite 23
- Ausgabe 6/2020, Seite 26
- Ausgabe 5/2020, Seite 15 bis 20
- Ausgabe 5/2018, Seite 24 bis 25
- Ausgabe 3/2018, Seite 34