Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
BILLY-MAYS APPRECIATION STATION
Sniggerdly Pandemic Legion
0
|
Posted - 2015.05.18 01:13:46 -
[1] - Quote
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
16
|
Posted - 2015.05.18 01:56:10 -
[2] - Quote
If this work cool to add or create a function to integrate it whit google calendar that the info is posted there.
GÇ£If you win, you live. If you lose, you die. If you donGÇÖt fight, you canGÇÖt win!GÇ¥ GÇô Eren Jaeger
White Maul
|
Zad Murrard
Vicis Inter Astrum Triumvirate.
16
|
Posted - 2015.05.18 11:36:02 -
[3] - Quote
Seems to work if you have queuePosition, notice the capital P in the attribute name. |
BILLY-MAYS APPRECIATION STATION
Sniggerdly Pandemic Legion
0
|
Posted - 2015.05.18 12:33:12 -
[4] - Quote
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
Vicis Inter Astrum Triumvirate.
16
|
Posted - 2015.05.18 12:56:32 -
[5] - Quote
=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
Sniggerdly Pandemic Legion
0
|
Posted - 2015.05.18 13:05:59 -
[6] - Quote
Seems that way :(
rip |
Zad Murrard
Vicis Inter Astrum Triumvirate.
16
|
Posted - 2015.05.19 13:17:32 -
[7] - Quote
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. |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |