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.
 

Noob API question - corp member list
Author
Previous Topic Next Topic
Lazarann
Ideal Machine
#1 - 2013-06-14 22:56:40 UTC
I'm trying to pull my corp member list into either a Google Docs or Excel spreadsheet, if that's at all possible.

I found some pretty old posts on the subject but nothing that seemed to work for me.

And yes, I have the required roles and a corp API key.

Also, if pulling wallet balances into a separate sheet or web page is possible, that would be a bonus.

Any help would be appreciated.

Thanks.
Louis Vitton
Viziam
Amarr Empire
#2 - 2013-06-17 11:25:36 UTC
Hi mate,

Here is a basic example to get you started it shows you the name of all the characters listed. Please note if you have more then 50 characters in corp then there may be an issue as the ImportXML only returns 50 lines

=ImportXML("https://api.eveonline.com/corp/MemberTracking.xml.aspx?KeyID=GOESHERE&vCode=GOESHERE&extended=1","//row/@name ")

Where i have "GOESHERE" is where you put your API details