Creates a JSON key from the given values or range to reference data from within a message. This function is normally used in the WRITE function. OUTBOXDATA references values from the Data section of a message.


=OUTBOXDATA(Message, ValuesOrRange)


Name Description
Message Message to reference data from.
ValuesOrRange A list of values or a range of cells describing the path to the element path within a JSON structure.

Return Value

A string key to provide a path within a message.


Function Result Comment
=OUTBOXDATA(“Message, “NewItem”) [Message][Newitem] Returns an identifier that can be used in other Streamsheet functions like WRITE.
=OUTBOXDATA(“Message”, B1:B2) [Message][Customer][Name] Here the values within the cell range B1:B2 (“Customer”, “Name”) will be used to concatenate the JSON path.
=WRITE(OUTBOXDATA(“Message”, “Customer”, “Name”), C7, “String”) Name The WRITE function returns the last part of the JSON Path. The value in C7 will be written into the Message at the given JSON Path.