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.
 

strange importxml result in googledoc
Author
Previous Topic Next Topic
Sun Ying
Sun Ltd.
#1 - 2012-10-10 10:42:03 UTC
why does this query in googledoc returns 0 ? :

=ImportXML("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid=23049", "//sell/min")

if you check the value returned through :
http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid=23049

it's clearly not 0 , so what is happening here ? anyone got an idea ?

there's a few ID like that return 0 while the value in the string is clearly not 0
23019
232
235

i'm a bit puzzled.
Sun Ying
Sun Ltd.
#2 - 2012-10-10 10:45:21 UTC  |  Edited by: Sun Ying
super strange

if i left click on the link it redirect me to :
http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid=23049

notice the &amp that got added ? wtf
if i left click it and open in new tab it works fine...

but that's probably an eveforum quirk and nothing to do with googledoc
Kivorno
Myanapa Corsica
#3 - 2012-10-10 11:19:41 UTC
Try:

=ImportXML("http://api.eve-central.com/api/marketstat?typeid=23049&usesystem=30000142","/evec_api/marketstat/type/sell/min")

I'm not a pro at this sort of thing but that works for me.

Proud creator and developer of Eve-Merchant / Eve-Merchant Sprint