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.
 

api imports for system cost index not working???

First post
Author
Previous Topic Next Topic
Celosia Radiant
Moonbeams and Butterfly Wings
#1 - 2016-02-17 14:56:04 UTC
Is anyone having an issue with this formula no longer returning the correct information?

=IMPORTXML("http://api.eve-industry.org/system-cost-index.xml?name=system name","//activity[@id='1']")

when I run it, it returns results that are more then a week old now. When I run it through a website, same issue.
I tried running it using system ID, and activity name, but always returns old results.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2016-02-19 15:01:26 UTC  |  Edited by: Steve Ronuken
Drop me a mail (as a reminder) and I'll see about writing a custom function which will load the data into another tab, so you can vlookup it. (direct from CREST)

(or look at http://eve-prosper.blogspot.is/2014/07/building-better-spreadsheets-crius.html for someone elses :D )

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#3 - 2016-02-19 22:12:20 UTC  |  Edited by: Zad Murrard
The method in the above link has worked quite well for me. Bit slow compared to importxml...but that's crest.
Celosia Radiant
Moonbeams and Butterfly Wings
#4 - 2016-02-21 04:13:34 UTC
Cheers! I will look into it.