This function can be used to efficiently add array items to a message. Creates a JSON array entry using the given keys and values. If the range has one row or column, one array entry for each cell is created. If there are two columns or rows, a nested array (array containing a subarray) will be created.
=ARRAY(Range, [Nest], [Flat])
|Range||Source Range to retrieve data from|
|Nest||Optional. Direction on how to nest items, if range has more than one row or column. FALSE to nest by column and TRUE to nest by row.|
|Flat||Optional. Specify ‘flat’ to create a flat list if range has more than one row or column. By default returned array is nested.|
Comma separated list of array items.
=WRITE(OUTBOXDATA(“Message”, “NewItem”),ARRAY(A2:B5, FALSE), “Array”)
with the following cell content:
Appending an array to a message. Since Nest is set to FALSE, the array items are created by columns leading to two array entries. The two entries contain the elements from the rows top to bottom. The message content will look as follows