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.
 

getting eve api info with google docs
Author
Previous Topic Next Topic
Omega Flames
Caldari Provisions
Caldari State
#1 - 2013-07-13 00:54:47 UTC
Does anyone know how to get google docs to access the "cacheduntil" part of an api xml (or just get the entire xml instead of one little peice at a time)? I'm currently using the command:

Quote:
=ImportXML(ʺhttps://api.eveonline.com/corp/AssetList.xml.aspx?keyID=#####&vcode=#####ʺ,ʺ//row/@quantityʺ)
to get the quantity info (or typeid or itemid as needed) but i can't see to figure out how to make that pull the cacheduntil value from the xml.
Kid Delicious
Caldari Provisions
Caldari State
#2 - 2013-07-13 23:09:01 UTC
Not familiar with google docs import but that second parameter looks like xpath. So /eveapi/cachedUntil might work.
Omega Flames
Caldari Provisions
Caldari State
#3 - 2013-07-13 23:20:47 UTC
wow...apparently there is a big difference between eveapi/cachedUntil and eveapi/cacheduntil as it was the lower case version i had tried before. ty for your help.