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 Character ID Issue
Author
Previous Topic Next Topic
jsmb
The Deuoi
Brute Force Solutions
#1 - 2014-05-24 22:23:47 UTC  |  Edited by: jsmb
Alright so I am trying to filter out my characters so i can eventually pull how many of X item i have.

What i have so far,

the sheet uses the API information and name of character i gave it, pulls out my access mask to make sure i have access to the right sections.

if access mask is correct then the set up is suppose to pull the character id for the character that i set.


so i made a url that looks like this:

=IMPORTXML("https://api.eveonline.com/account/ApiKeyInfo.xml.aspx?keyID=XXX&&vCode=XXX","//row[@charactername=XXX]/@characterid")

and it throws erros i can get all my characters ids using this:

=IMPORTXML("https://api.eveonline.com/account/ApiKeyInfo.xml.aspx?keyID=XXX&&vCode=XXX","//row/@characterid")

but that is not what i am looking for. any help would be great. (yes i tryed caps and lower case for this)
Louis Vitton
Viziam
Amarr Empire
#2 - 2014-05-26 08:12:42 UTC
I am not sue of the solution in Google docs for you but why don't you just punch this query into your web browser it will make the xml pretty (at least in chrome) and then you can grab the character ID from there as they are static values and will not change over the live of your character.
jsmb
The Deuoi
Brute Force Solutions
#3 - 2014-05-26 14:01:01 UTC
Louis Vitton wrote:
I am not sue of the solution in Google docs for you but why don't you just punch this query into your web browser it will make the xml pretty (at least in chrome) and then you can grab the character ID from there as they are static values and will not change over the live of your character.


Because than i would have to do that for every single persons in my corp and that would take forever.