See the supported connectors for Application Integration.
MERGE function
MERGE
function
Function Name | Description | Usage | Input parameter | Return value |
---|---|---|---|---|
MERGE |
Merges two JSON variables (objects or arrays). If same value is present in both the variables, the function removes the duplicate value. | MERGE(value) |
JSON value to merge. | A JSON object or an array. |
Supported data type
The MERGE
function supports the following data type:
- JSON
Example: Merge two JSON objects
Sample data: $var1$ = {"productId": 23}
Usage: $var1$.MERGE({"productName":"radio"})
{"productName":"radio"}
with var1.
Output: {"productId": 23,"productName": "radio"}
Example: Merge two JSON arrays
Sample data: $var1$ = ["first", "second", "third"]
Usage: $var1$.MERGE([4,5])
[4,5]
with var1.
Output: ["first", "second", "third",4,5]
Recommendation
- Learn how to add and configure a Data Mapping task