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.
 

How to get each character name from a full api key?

Author
Previous Topic Next Topic
Astrid Farnsworth
Broke and Famous
#1 - 2017-01-02 04:24:30 UTC
I have in one Google sheet the full api key for one account. I want in other sheet that it show all the Character in another sheet. Theres way to do this?

"Amateurs talk about tactics, but professionals study logistics." - Gen. Robert H. Barrow, USMC (Commandant of the Marine Corps) noted in 1980**strong text**
Blacksmoke16
Resilience.
#2 - 2017-01-02 04:47:14 UTC
Use the apikeyinfo endpoint. It will return data such as characters on that account. What corp/alliance they are in and what type/accessMask the api is as well as when it expires.

https://api.eveonline.com/account/apikeyinfo.xml.aspx?keyID=KEY_ID&vCode=V_CODE
Es Thiesant
The Scope
Gallente Federation
#3 - 2017-01-02 09:23:38 UTC  |  Edited by: Es Thiesant
In Google Sheets do this in two separate columns:
=IMPORTXML("https://api.eveonline.com/account/APIKeyInfo.xml.aspx?keyID=KEY&vCode=CODE","//row/@characterName")
=IMPORTXML("https://api.eveonline.com/account/APIKeyInfo.xml.aspx?keyID=KEY&vCode=CODE","//row/@characterID")

Then just use whatever formula you want to copy the data to another sheet/tab.

Feel free to have a look at my Automatic Google Sheet for Character Stats, Storage, Wallet, Skills, Skill Queue and Orders.
Astrid Farnsworth
Broke and Famous
#4 - 2017-01-04 00:20:48 UTC
Yes this ones worked

=IMPORTXML("https://api.eveonline.com/account/APIKeyInfo.xml.aspx?keyID=KEY&vCode=CODE","//row/@characterName")

know traying to figure out how to show the info in line instead of colums.

"Amateurs talk about tactics, but professionals study logistics." - Gen. Robert H. Barrow, USMC (Commandant of the Marine Corps) noted in 1980**strong text**
Blacksmoke16
Resilience.
#5 - 2017-01-04 00:36:20 UTC
Wrap the whole function in transpose( ). Will make each name be a diff column vs diff row.