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.
 

Pulling through data from eve-central
Author
Previous Topic Next Topic
Ezeller
Kamoku Industrial
#1 - 2013-08-19 20:22:34 UTC
Hey,

I am just attempting to pull some data onto a spreadsheet from eve-central using the api, I am using the following formula but not getting the same info i get if I query the database on the website, what am i doing wrong?

=importXml("http://api.eve-central.com/api/marketstat?&typeid=11694&usestation=60008494","//sell/min")

I am trying to get the minimum sale price of EM Pulse generators in Amarr?

Cheers

Ez
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2013-08-19 21:21:11 UTC
Ezeller
Kamoku Industrial
#3 - 2013-08-19 21:51:32 UTC
Cheers thats helpful in many respects, but still does not solve the issue i am having :S
Fubar
Eagle Eye Inc.
#4 - 2013-08-19 23:03:42 UTC
Ezeller wrote:
Hey,

I am just attempting to pull some data onto a spreadsheet from eve-central using the api, I am using the following formula but not getting the same info i get if I query the database on the website, what am i doing wrong?

=importXml("http://api.eve-central.com/api/marketstat?&typeid=11694&usestation=60008494","//sell/min")

I am trying to get the minimum sale price of EM Pulse generators in Amarr?

Cheers

Ez
Marketstat does not have a usestation parameter. You will have to use the parameter usesystem=30002187 instead.