JsonMergePatch function for IBM Planning Analytics (TM1)


JsonMergePatch function for IBM Planning Analytics (TM1)

Used to apply changes from a JSON document to another JSON document.

Where can the function be used?

TurboIntegrator

Which TM1 Server version is the function available for?

Version 12

What is the syntax?

JsonMergePatch(JSONString, Patch)

  • JSONString = string representation of the target JSON document
  • Patch = string representation of the source JSON document

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.