I use the Fuzzworks API. Here’s the link for his Excel use …
Somewhere on the site is a script for using Google sheets but I can’t quickly find it. I use a modified version of Steve’s script for my prices spreadsheet which feeds all my stock, industry & trading sheets. I’ve used this method for quite a while and it just works … mostly
Recently I’ve had more and more scheduled script failures to the point where I’m considering switching to CCP’s ESI, I have some knowledge of this but need to put in some work to properly research it.
I don’t know why the requests to Steve’s API keep failing, could be the load on his system(s), could be Google’s fault, could be the size of my API requests.
Ok ta for the answer. My scripts were running fine, roughly for over a year, with only the very seldom fail, up to about 2 or 3 months ago. I hadn’t changed the number of IDs I was querying, in fact to try and sort it I’ve trimmed a few off.
I run 5 scripts, once per day, about 900 IDs in each web query, don’t know what that totals as in terms of web calls tho.
Is each field a “web call” ? If so u may be right, but it had been working and some days I don’t see any problems. Usually the error(s) I get back is a timeout.