Skip to main content
Version: Streamsheets 3.0

BREAK

Premium

Immediately stops traversing a JSON object via JSON.PROCESS.

Syntax

=BREAK()

Arguments

None

Return

TypeDescription
Boolean or ErrorTRUE or an error value.

Examples

Traverse only first key-value pair of following JSON

A
1{"name": "foo", "age": 42 }
2=CONCAT(A2, A4, "-")
3=CONCAT(A3, B3, "-")
4=JSON.PROCESS(JSON(A1), B3, A2:A4)
FormulaResultComment
=BREAK()
TRUECells A2 and A3 contain only first key-value pair, namely -name- and -foo- respectively.