JSON_MAP

Owned by Charles Bishop (Deactivated)
Jan 30, 2018
1 min read

Syntax

JSON_MAP(<string>; <string>)

Description

Creates a JSON map from two JSON arrays.

Example

=JSON_MAP(#Sheet1!keys;#Sheet1!values)

Keys

Values

JSON_MAP returns

["key1","key2"]

["value1","value2"]

{"key1":"value1","key2":"value2"}

["key1","key2","key3"]

["value1","value2"]

{"key1":"value1","key2":"value2"}