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.
 

Need help with import data via api from zkillboard to google docs
Author
Previous Topic Next Topic
Samuel Sachs
#1 - 2015-01-29 22:53:01 UTC
Hi,

just need a bit help to make it happen that i can import datas from zkillboard to google docs but i have some problems because the order i have is not working, for example i tried to import a kill with some datas but it gives me only an error back, no clue why.

=IMPORTXML("https://zkillboard.com/api/kills/killID/38382331/xml/","//victim/@characterName")


Maybe somebody else has an idea ? Would be nice to make it works to fetch some datas.

Regards

SheetMon_V2 a gdocs spreadsheet what pulls lots of stuff, feel free to make a copy :-)
Nolen Cadmar
Caldari Provisions
Caldari State
#2 - 2015-01-30 03:30:15 UTC  |  Edited by: Nolen Cadmar
Hmm...that's really strange. I used to pull from zkillboard all the time, but this doesn't seem to be cooperating. I've never pulled an individual kill ID.

To make sure I'm not crazy I found the victim's character id, and did this:
=importxml("https://zkillboard.com/api/losses/characterID/93592221/xml/","//victim/@charactername")


It worked perfectly fine. I'm not sure why it won't let you import with only the single kill ID. I tried a multitude of things:
"//victim/@characterName"
"//victim/characterName"
"/eveapi/result/rowset/row/victim/@characterName"

None of those or the other ones I tried worked. I'm not sure what you're trying to do with this data, but you would try to get the data by using a different URL.

Nolen's Spreadsheet Guru Services

Pre-made spreadsheets available covering market, manufacturing and more!

Custom requests welcome!

Sheet Screenshots