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.
 

Another ImportXML to google docs thread
Author
Previous Topic Next Topic
enterprisePSI
#1 - 2012-11-16 06:49:18 UTC
So basically i made a manufacturing spreadsheet.
I want it to import prices for minerals (max buy) from eve-central , and also to import prices for the items i make (sell/min) so i can tell if its worth building something or not.

I have absolutely no idea about the xml, api and stuff , how they work. However i managed to make the mineral prices to import nicely from my system of choice.

I cant make it work with the items i want to produce. I am using

Quote:
=ImportXML("http://api.eve-central.com/api/marketstat?usesystem=30002659&typeid=641")


and

Quote:
=ImportXML("http://api.eve-central.com/api/marketstat?usesystem=30002659&typeid=641,"/evec_api/marketstat/type/buy/max"")


and all i get is either #ERROR or #N/A. now i know the ids are correct because this seems to work

http://api.eve-central.com/api/marketstat?usesystem=30002659&typeid=641

So, please help me understand this Big smile

The tears of the many, outweigh the tears of the few. Or the one. enterprise-psi©
TheSkeptic
Federal Navy Academy
Gallente Federation
#2 - 2012-11-16 08:41:49 UTC
enterprisePSI wrote:

Quote:
=ImportXML("http://api.eve-central.com/api/marketstat?usesystem=30002659&typeid=641,"/evec_api/marketstat/type/buy/max"")


Close, Try this:

Quote:
=ImportXML("http://api.eve-central.com/api/marketstat?usesystem=30002659&typeid=641", "//type/buy/max")

...

enterprisePSI
#3 - 2012-11-16 09:40:13 UTC
Yeap, Protheroe pointed my syntax error earlier today in scc-lounge. Thank you very much though.

The tears of the many, outweigh the tears of the few. Or the one. enterprise-psi©