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.
 

API finding some things tricky with few examples....
Author
Previous Topic Next Topic
Ophelia Voigt-Kampff
Jerome Industries
DISASTER Delivery Service
#1 - 2012-10-29 01:01:03 UTC  |  Edited by: Ophelia Voigt-Kampff
hi guys and gals

Using a Google spreadsheet i have managed to pull API data from eve-marketdata.com for prices and names from Item_ids.

i'm just getting into the API and i'm only dipping my little toe in, but i am struggling with getting shipKills into my spreadsheet using a solarSystemID.

atm i have:

=importxml("https://api.eveonline.com/map/Kills.xml.aspx ","//row[@solarSystemID='30000142']/attribute::shipKills")


i'm hoping to recieve the number of ships killed in the last hour in JITA, but it doesnt work :(
Please can you tell me where i am going wrong? or if there is a list of many examples of different API calls i can learn to understand by example? i can only find a few full api examples to "play" with... thanks loads :)
ItsmeHcK1
Immortalis Inc.
Shadow Cartel
#2 - 2012-10-30 15:57:14 UTC
I'm not familiar with using Google spreadsheets for this, but maybe some general knowledge will help... :P
After the ".aspx" you have a space before the closing doublequote, that might be messing you up?

I can manually find the system just fine, (ctrl + f in Firefox :P ) so it's definitely there...
Ophelia Voigt-Kampff
Jerome Industries
DISASTER Delivery Service
#3 - 2012-10-30 18:03:40 UTC  |  Edited by: Ophelia Voigt-Kampff
thank you for the reply i was wondering if anyone read this section :)

i spotted the space yesterday and i thought the same, unfortunately it still doesn't work... :(


The api link works

if i put htt#####online.com/map/Kills.xml.aspx into firefox i get an XML of lots of system data with shipkills etc,

I think my problem is with the XPATH part at the end of my link not pointing to the bit of data i want or something (like i say i'm no expert)

i'm learning as i go from very few working examples so any more help with this would be awesome :)
ItsmeHcK1
Immortalis Inc.
Shadow Cartel
#4 - 2012-10-31 00:26:38 UTC  |  Edited by: ItsmeHcK1
Well, XPath itself does not support selecting only a single attribute that way. (Documentation here.)
My guess is that's a Google addon?
Either way, I cannot confirm or deny that that statement will work.
Ophelia Voigt-Kampff
Jerome Industries
DISASTER Delivery Service
#5 - 2012-10-31 09:11:17 UTC
ahhhhh ok that i did not know,

i've looked through that w3schools xpath site before but i missed that.

thankyou loads i'll have another go at the weekend.