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.
 

api imports for system cost index not working???
Author
Previous Topic Next Topic
Celosia Radiant
Moonbeams and Butterfly Wings
#1 - 2016-02-12 13:28:24 UTC  |  Edited by: Celosia Radiant
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 about a week old now.
Professor Humbert
Project Fruit House
#2 - 2016-02-16 11:44:18 UTC
Enter the API call into a browser address bar and see if yo get the same xml result as calling from your spreadsheet.
I read somewhere Google sheets sometimes serve cached results..
Zifrian
The Frog Pond
Ribbit.
#3 - 2016-02-16 12:43:45 UTC
Professor Humbert wrote:
Enter the API call into a browser address bar and see if yo get the same xml result as calling from your spreadsheet.
I read somewhere Google sheets sometimes serve cached results..

I'd email eve-industry.org with your question or check the tech forums. Not going to get much help here.

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder
Celosia Radiant
Moonbeams and Butterfly Wings
#4 - 2016-02-17 14:53:36 UTC
Professor Humbert wrote:
Enter the API call into a browser address bar and see if yo get the same xml result as calling from your spreadsheet.
I read somewhere Google sheets sometimes serve cached results..

Yes it returns the same old results.

Zifrian wrote:
Professor Humbert wrote:
Enter the API call into a browser address bar and see if yo get the same xml result as calling from your spreadsheet.
I read somewhere Google sheets sometimes serve cached results..

I'd email eve-industry.org with your question or check the tech forums. Not going to get much help here.

Thanks, TIL. will post there.