EVE Technology Lab

Forum Index

EVE Forums » EVE Technology and Research Center » EVE Technology Lab » Importing Corp Member List to Google Docs - Help please...

Topic is locked indefinitely.

Importing Corp Member List to Google Docs - Help please :)
Author

Previous Topic Next Topic

Troyd23

Repercussus

Likes received: 70

#1 - 2012-07-25 07:58:49 UTC | Edited by: Troyd23

Hey there, i'd like to import my corp member list to a google doc,

Yes, I've searched around on the forums and found a formula roughly like this. The thread also mentioned something about character ID missing/needed to make it function properly.

=importxml("https://api.eveonline.com/Corp/MemberTracking.xml.aspx?userid=xxxx&apikey=xxxxx&characterid=xxxxx", )

(using my director FUll API obviously)

I've played around... and it wants a second argument.. and I think i'm missing the character ID or using it improperly. Should I be using my characters ID, or the Corps ID?

Again All I want to do is import the corp member list into a google doc! Do any of you have a forumula that does this? or explain to me my wrongdoings?

Thank you in advance,

Viziam Amarr Empire 88
Louis Vitton Viziam Amarr Empire Likes received: 88	#2 - 2012-07-25 08:44:59 UTC this may help http://wiki.eve-id.net/APIv2_Corp_MemberTracking_XML there is tone of examples though these forums


Troyd23 Repercussus Likes received: 70	#3 - 2012-07-25 08:47:14 UTC \| Edited by: Troyd23 Using the link provided I developed.... =importxml("https://api.eveonline.com/Corp/MemberTracking.xml.aspx?keyid=xxxx&apikey=xxxxx" It just just keeps giving me an authentication error as my result rather then the expected rowsets. I am using a corporation full API key.

Louis Vitton

Viziam

Amarr Empire

Likes received: 88

#4 - 2012-07-25 08:58:36 UTC | Edited by: Louis Vitton

Troyd23 wrote:

Using the link provided I developed....

=importxml("https://api.eveonline.com/Corp/MemberTracking.xml.aspx?keyid=xxxx&apikey=xxxxx"

It just just keeps giving me an authentication error as my result rather then the expected rowsets. I am using a corporation full API key.

are you using a CAK api key with the rights to view it?

apikey = vCode


Troyd23 Repercussus Likes received: 70	#5 - 2012-07-25 09:08:28 UTC \| Edited by: Troyd23 Awesome thanks, changing apikey to vcode worked. I assume vcode is for the new cak ones, and api for the old legacy. Got the member list printed with.. .a //result/rowset/row/@name argument. Do you by chance know off hand the xpath argument to get it to print everything off in one and organize it alphabetically? (Still new at this xpath stuff)