Token in header, REST REQUEST, any given format?

Hi,

The REST.REQUEST header usage works like this:

image

Use the Range over these 4 cells in the Header input field.
The function wizard will automatically interpret your Range within a JSON() function.
This way the Data Range is transformed to a JSON.

Tip:
If you need to create JSON Ranges with a hierarchy use the “right click” option “Create JSON-Range”
on your sheet. You will be able to use TAB and Shift TAB to structure your message.

1 Like