Created attachment 167437 [details] screenshot of site log, showing webservice() accessing a URL three times. webservice() appears to access the specified URL three times. Normally this would not be an issue, but I am trying to get stock quotes from alphavantage.co. This service has a limit a five accesses per minute per key. I should be able to get 5 quotes in a minute, but I only get two. I confirmed this by using a single call to webservice() in localc to access my own website. Image of the site log is attached.
Created attachment 167686 [details] Calc file showing bug. Using stock quote API
Eike could you please look at it.
It accesses the URL 3 times, but with 3 different requests: 1. OPTIONS 2. HEAD 3. GET of which only the 3rd obtains data (or at least should and the server should not deliver the actual data for the others). If the site requested counts that as three data accesses there's nothing we can do. See also https://developer.mozilla.org/en-US/docs/Web/HTTP/Methods/OPTIONS https://developer.mozilla.org/en-US/docs/Web/HTTP/Methods/HEAD
Thank you, Eike! I really appreciate your looking into this. I have reported the issue to AlphaVantage. There is also another bug with webservice() that I gave up on after someone closed it erroneously. It was too subtle to get across, I guess?