These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Googledocs and API
Author
Previous Topic Next Topic
Barrak
The Painted Ones
#1 - 2015-06-17 18:24:14 UTC
Hey,

I'm using a rather crude method (the only one I know right now) to pull data from the API into a googlespreadsheet to then compare systems.

There is a lot of concatenate, join, etc going on.

My problem is that one minute the sheet works fine then it tells me that it has a problem "Could not fetch URL".

If I change stations (using dropdown) and then load another station it normally works.

However what i'm experiencing now is that my Jita and Amarr stations are not working. But if i make a copy of the complete file it works again for a while and then starts to fail.

Is it just a timing issue and are there problems with Jita/Amaar (also Hek) queries or is it googledocs?

Regards

Barrak
Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#2 - 2015-06-18 07:32:58 UTC
Issue with gdocs & importXML. Both are unreliable. You can alleviate the situation by using some replacement for importXML, either custom scripts for your needs or importXML2.