JSON_merge()

Overview

The JSON_merge() function merges two JSON-formatted strings into a new JSON-formatted string and returns the result. When there are conflicting keys between the two input strings, the values from the second string take precedence in the merged output.

Syntax

JSON_merge(str_1, str_2)

Return type: String

Example of Result

UQL
return JSON_merge('{"name":"Lisa","age":23}','{"name":"Lisa","age":30,"interest":"football"}')

Result: {"age":30,"interest":"football","name":"Lisa"}

NOTE

It's advisable to use distinct quotation marks (" or ') within JSON objects and to encapsulate the two input strings. The pairing of these quotation marks is essential for the correct parsing of the statement.

Example of Use

Consolidate information from different sources into a single JSON object, preserving unique keys and their corresponding values.

UQL
with '{
  "name": "John Doe",
  "age": 30,
  "city": "New York"
}' as s1
with '{
  "name": "John Doe",
  "age": 29,
  "email": "[email protected]"
}' as s2
return JSON_merge(s1, s2)

Result: {"age":29,"city":"New York","email":"[email protected]","name":"John Doe"}