JSON Functions

Use these functions to manipulate JSON documents in TurboIntegrator processes. JSON is supported in processes running on TM1 Database 12 version 12.4 and later.

JsonAdd
This function adds a value at a specified location within a JSON document.
JsonCopy
This function copies a specified value from one location to another in a JSON document.
JsonDiff
This function generates the JSON-Patch document required to change an initial specified JSON document to a second specified JSON document.
JsonGet
This function returns the name of a specified key in a JSON document.
JsonGetKey
This function returns the name of a specified key in a JSON document.
JsonMergePatch
This function applies a JSON Merge Patch to a JSON document.
JsonMove
This function moves a specified value from one location to another in a JSON document.
JsonPatch
This function applies the operations described in a JSON-Patch to a JSON document.
JsonRemove
This function removes a specified value from a JSON document.
JsonReplace
This function replaces a value at a specified location within a JSON document.
JsonSize
This function returns a numeric value representing the number of elements in the JSON value that is identified by the function parameters.
JsonTest
This function compares a JSON document against a specified value.
JsonToString
This function returns a string value from a specified location in a JSON document.
JsonType
This function returns a string identifying the type of the JSON value that is identified by the function parameters.
JsonValidate
This function compares a JSON document against a JSON schema.
StringToJson
This function converts a string value to a JSON string.

Parent topic: TurboIntegrator Functions