<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-NCX94J4" height="0" width="0" style="display:none;visibility:hidden"></iframe>

JsonToString function for IBM Planning Analytics (TM1)

    Converts a JSON document to a formatted JSON for
    further use or presentation purposes.

    Where can the function be used?

    TurboIntegrator

      Which TM1 Server version is the function available for?

      Version 12

        What is the syntax?

        JsonToString(JSONString, Reference, Indent, IndentChar)

        • JSONString = string representation of the JSON document
        • Reference = JSON path that points to the field that should be converted (optional)
        • Indent = Indent level when converting the JSON document (optional)
        • IndentChar = Character to be used for the indentation (optional)

        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.