i want to make a REST.REQUEST but the API requires a authorization token in the header with the api version, which in normal Code would look something like this:
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.