What is a request?
The function counts a request when it manages to fetch a JSON from the target url. For instance, if fetching the content fails or if there is no element in the JSON that matches the filters, no request will be counted.The JSON is cached by default for 24 hours. Therefore, until the cache expires, using the same […]
Control when data updates
First of all, it is important to note that sometimes, you enter your spreadsheet and see the =IMPORTFROMWEB() functions recalculating and your data loading. The reason is that Google Sheets may control how the functions recalculate according to different behaviours (modifying cells, opening the spreadsheet, …). To avoid that IMPORTFROMWEB fetches the data source constantly, […]