I’m currently testing streamsheets with the Rest-API.
I’m working with your tutorials and forum topics and use anapioficeandfire for sample REST REQUESTS.
Currently I’m run the sheet step by step via the step-Button, to see whats going on in every step.
Now I have a basic Question about the REST REQUEST Function.
In A1 I define which character number I want to request from the api
In B1 I create the API-URL with CONCAT
In C1 I have defined the Request itself.
And in C5 I want to show the Data.
But when I change the number in A1, I have to klick two steps forward to see the new data.
My expectation was, that I only have to do one click and get the new Data shown in the sheet.
Could you please answer me, why it needs two steps to show the data?