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

« Previous Version 2 Current »

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.

  • No labels