JSON_MAP

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"}

Further Documentation

Find more documentation on working with JSON here.