Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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

  • No labels