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), FALSE), "Dictionary") with the following cell content: | Appending an object to a message. The message content will look as follows |
=WRITE(OUTBOXDATA(“Message”,”NewItem”), DICTIONARY(A2:A5,FALSE),"DICTIONARY") =WRITE(OUTBOXDATA(“Message”,”NewItem2”), DICTIONARY(B2:B5,FALSE,TRUE),"Dictionary") |