[Beginner] What is a JSON-Range?

Streamsheets are using the JSON format to transfer and process data.

Not only incoming data is interpreted in the JSON format, but also outgoing data has to be defined as a JSON. Usually this is done automatically by the function wizard, who adds the JSON() function to every send cell range. This function automatically pairs value and key in the JSON format.
If you don´t know what JSON is, check out this post.

The JSON() function is missing one big feature. There is no way to implement hierarchy elements. That is why we need the JSON-Range.
Creating a JSON-Range in a Streamsheet helps you to easily structure your data keys in a hierarchical order. As usual enter your key value pairs in cells next to each other, but this time also add hierarchy layers. Select all cells, right click and select “Define JSON-Range” on the bottom of the menu.
Now you can start structuring your data using TAB and Shift+TAB to change the hierarchy of a key value pair.
A JSON-Range requires exactly two rows.


See an example below:

Using this JSON-Range to publish data, will now reflect the defined structure.
Open your function wizard and try it yourself :slight_smile:

The data from the example:

{“Interesting Data 1”:12,“Interesting Data 2”:15,“More Data”:{“Data from A”:17,“Data from B”:1234,“Data from C”:625,“Data from D”:892}}