Sign up for free
Functions

JOIN

Join two data sources. The function will use values from the root of the JSON.

Parameter List

Syntax
JOIN(data1, data2, key1, key2, 
[key3, key4]
)
data1

The original JSON {data}.

data2

The JSON {data} to be joined with data1.

key1

The name of the key property of data1 to join data with data2.

key2

The name of the key property of data2 to join data with data1.

[optional] key3

The name of the key property of data1 to join data with data2.

Examples

JOIN('{"email": "john@acme.com","name": "John"}', '{"e-mail": "john@acme.com","salary": 1000}', "email", "e-mail") returns {"name": "John","email": "john@acme.com","salary": 1000}