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