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.
 

Google Docs pulling skill queue "endTime" with importXML()

Author
Previous Topic Next Topic
BILLY-MAYS APPRECIATION STATION
Perkone
Caldari State
#1 - 2015-05-18 01:13:46 UTC
So I've gotten the XML file from an api call using keyid, vCode, and character ID. I can't get importXML to parse the xml properly.

This is where I'm at now:

=IMPORTXML(("https://api.eveonline.com/char/SkillQueue.xml.aspx?keyID=######&vCode=#%#%#%#%#%&characterID=######","eveapi/result/rowset/row[@queueposition='0']/@endTime"))

This is the part I'm stuck on:

"eveapi/result/rowset/row[@queueposition='0']/@endTime"

I can't get the file to pull the information, always getting a formula parsing error. I've tried various suggestions from other related questions on these forums but I have not been able to get it working. Can anyone with more knowledge on this subject perhaps do a query of your own and see which syntax is correct?
Leonis Perthshire
Dreddit
Test Alliance Please Ignore
#2 - 2015-05-18 01:56:10 UTC
If this work cool to add or create a function to integrate it whit google calendar that the info is posted there.

“If you win, you live. If you lose, you die. If you don’t fight, you can’t win!” – Eren Jaeger

White Maul
Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#3 - 2015-05-18 11:36:02 UTC
Seems to work if you have queuePosition, notice the capital P in the attribute name.
BILLY-MAYS APPRECIATION STATION
Perkone
Caldari State
#4 - 2015-05-18 12:33:12 UTC
Zad Murrard wrote:
Seems to work if you have queuePosition, notice the capital P in the attribute name.


Can you put in the exact query you used? (minus your api information of course)
Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#5 - 2015-05-18 12:56:32 UTC
=importxml("https://api.eveonline.com/char/SkillQueue.xml.aspx?keyID=1234&vCode=myCode&characterID=5678","eveapi/result/rowset/row[@queuePosition='0']/@endTime")

You may also have plain old importxml issues if that doesn't work for you.
BILLY-MAYS APPRECIATION STATION
Perkone
Caldari State
#6 - 2015-05-18 13:05:59 UTC
Seems that way :(

rip
Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#7 - 2015-05-19 13:17:32 UTC
Feel free to use http://pastebin.com/0Wcfzxdv

It may have bugs, doesn't do much error checking etc. Doesn't have all xpath features. Works for my purposes much better than normal importxml.