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.
 

Issues pulling data from Eve-Central with XML in Google docs
Author
Previous Topic Next Topic
Ethan Zoromir
Tempest Theory
#1 - 2016-04-03 06:16:04 UTC
I'm trying to pull data into Eve-central to Google docs.

I'm using the following as an example:

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

It seems to work sometimes. But we're pulling in data for only 8 items at the moment (all the minerals) and generally for about 50% of them it's coming up saying "#N/A"

The weird thing is, sometimes it will work, sometimes it won't, that's despite no modifications to the code.

Any ideas on what I'm doing wrong?

Voxis Accord | Mixed sov null alliance with a strong focus on building a great community
Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#2 - 2016-04-04 06:48:54 UTC
You are not doing anything wrong unless we think that relying on native importxml in gdocs is doing wrong.

Solutions:

ImportXML2 (one of many versions available, all should work better than default importxml)
Custom script replacement such as those from fuzzysteve.
Jeremy Kamira
#3 - 2016-04-11 04:00:45 UTC
Here is a script i am currently using that works amazingly. I don't know who created it since a buddy linked it. All the info you need is in there.

http://pastebin.com/raw/GJgPa9vi