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

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

Science & Industry

 
  • Topic is locked indefinitely.
 

Break in Google ImportXML from Eve API?
Author
Previous Topic Next Topic
Jakob Anedalle
The Scope
Gallente Federation
#1 - 2013-12-08 15:21:47 UTC
This morning I found that my google docs that pull from the EVE API have stopped working. The ones that pull from api.eve-marketdata.com are fine. Anyone else seeing this?

The calls that broke are the asset inquiry ones, such as:

=ImportXML("https://api.eveonline.com/char/AssetList.xml.aspx?keyID=REDACTED&characterID=REDACTED","sum(//row[@typeid='"&B2&"']/@quantity)")

If I put the URL direct into the browser I get the data, so it isn't that the API is down or that my key expired.

Jakob

Trying out all the things to do here in Eve - it's quite a checklist. So I made a blog Jakob's Eve Checklist
Jakob Anedalle
The Scope
Gallente Federation
#2 - 2013-12-08 15:42:02 UTC
Okay, nevermind, on the fourth time closing and reopening it worked... fun at Google I suppose.

Trying out all the things to do here in Eve - it's quite a checklist. So I made a blog Jakob's Eve Checklist
Nolen Cadmar
Caldari Provisions
Caldari State
#3 - 2013-12-09 14:20:34 UTC
Jakob Anedalle wrote:
This morning I found that my google docs that pull from the EVE API have stopped working. The ones that pull from api.eve-marketdata.com are fine. Anyone else seeing this?

The calls that broke are the asset inquiry ones, such as:

=ImportXML("https://api.eveonline.com/char/AssetList.xml.aspx?keyID=REDACTED&characterID=REDACTED","sum(//row[@typeid='"&B2&"']/@quantity)")

If I put the URL direct into the browser I get the data, so it isn't that the API is down or that my key expired.

Jakob


This happens all the time. I'm not sure if it's the API server or Google that has the error, but I'm inclined to believe that it's the API server. Reloading or waiting always solves it.

Nolen's Spreadsheet Guru Services

Pre-made spreadsheets available covering market, manufacturing and more!

Custom requests welcome!

Sheet Screenshots