JsonGet function for IBM Planning Analytics (TM1)

Where can the function be used?

TurboIntegrator

Which TM1 Server version is the function available for?

Version 12

What is the syntax?

JsonGet(JSONString, Reference)

• JSONString = string representation of the JSON document
• Reference = field of the value to be retrieved

Relevant Functions

• JsonAdd: Adds a new field or updates an existing field with a specified value in a JSON document.
• JsonCopy: Copies a value from a specified field to another within the same JSON document.
• JsonDiff: Compares two JSON documents and generates a JSON merge patch that captures the differences between them.
• JsonGet: Retrieves a value from a specific field within a JSON file.
• JsonGetKey: Retrieves a field name of an index within a JSON file.
• JsonMergePatch: Used to copy changes from a JSON document to another JSON document.
• JsonMove: Moves a value from a field to another field within the same JSON document.
• JsonPatch: Applies a JSON patch to a JSON document.
• JsonRemove: Removes a field from a JSON document.
• JsonReplace: Replaces an existing value at a given reference.
• JsonSize: Returns the number of fields within a specified JSON path within a JSON document.
• JsonTest: Tests if two JSON documents are equivalent.
• JsonToString: Converts a JSON document into a formatted JSON document for further use or presentation purposes.
• JsonType: Returns the data type of a value in a specified field of a JSON document.
• JwtCreate – Generates a JWT (JSON Web Token) which is used to transmit data securely between two parties as a JSON object.
• JwtDecode – Decodes a JWT (JSON Web Token) and retrieves the contents in JSON format.
• JwtVerify – Verifies a JWT (JSON Web Token) and retrieves the contents in JSON format when successfully verified.
• StringToJson: Converts a string value to a JSON string.