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.
 

Ship location API call?
Author
Previous Topic Next Topic
Luke Spacerunner
Federal Navy Academy
Gallente Federation
#1 - 2013-05-02 23:07:23 UTC
I am trying to figure out how to determine if a character has a specific ship and if so, what system(s) it is in. For example: I have a scimitar in Jita, Amarr, and Dodixie, so I would like it to return those three system ids.

Is there a call that will do this or would I have to cache the data into a database and query it for the data? If you know of some tool that is already out there that will do this, I would appreciate a point in that direction. I want to make an app that will show which of our corp members have doctrine ships. Maybe at some point even go as far as checking the fits for correctness, but for now just being able to show that they have a ship will be fine.

I am somewhat of a novice tinkering with the API, so any help would be greatly appreciated. Pirate
Tonto Auri
Vhero' Multipurpose Corp
#2 - 2013-05-02 23:55:46 UTC
There's no "querying" API available. you have to cache all data you want to work with.
In particular, you'd need assets API.

Two most common elements in the universe are hydrogen and stupidity. -- Harlan Ellison
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2013-05-03 00:00:33 UTC
You're wanting the assets api.

http://wiki.eveonline.com/en/wiki/EVE_API_Character_Asset_List

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Luke Spacerunner
Federal Navy Academy
Gallente Federation
#4 - 2013-05-03 00:09:09 UTC  |  Edited by: Luke Spacerunner
i did an api call with that one, but I could not get the syntax right apparently. This is what I did in Google Docs. (I am trying to get a proof of concept up in a spreadsheet)

=ImportXML("https://api.eveonline.com/char/AssetList.xml.aspx?vcode=?????&keyID=???????", "sum(//row[@typeid=24483]/@quantity)")

It returns a 0, but I know that I have a nidhoggur (typeid=24483), so it should return a 1, right?

I am testing this with my char key right now
Tonto Auri
Vhero' Multipurpose Corp
#5 - 2013-05-03 00:14:37 UTC
No. You should not try to pull multiple megabytes long document in a spreadsheet in first place.

Two most common elements in the universe are hydrogen and stupidity. -- Harlan Ellison
Luke Spacerunner
Federal Navy Academy
Gallente Federation
#6 - 2013-05-03 00:19:53 UTC  |  Edited by: Luke Spacerunner
Ok, I got to where I need to be, thanks for the help guys!Big smile