DICTIONARY

Creates a JSON Object using the given keys and values.

Syntax

DICTIONARY(Range[, Horizontal])

Arguments

Name

Description

Range

Range providing the source data, that will be used for the JSON.
The left or top cells will feed the keys and the bottom or right the values.

Horizontal

Optional. FALSE, if keys are aligned vertical (Default), TRUE if horizontal.

Return Value

TRUE, if successful.

Example

Function

Result

=WRITE(OUTBOXDATA(“Message”, “NewItem”), DICTIONARY(A2:B5), “Dictionary”)

DICTIONARY1

Appending an object to a message. The message content will look as follows

DICTIONARY2