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 does one import from API to Google Docs
Author
Previous Topic Next Topic
Captain Teuta
Aliastra
Gallente Federation
#1 - 2013-11-07 14:41:42 UTC  |  Edited by: Captain Teuta
Another question. =)

How can I import the alliance ranking list into Google docs? I've seen it done for other things so I know it must be very simple one line of code. Thanks!

This is all I have so far and it's incomplete.

=importxml("https://api.eveonline.com/eve/AllianceList.xml.aspx")
Hel O'Ween
Men On A Mission
#2 - 2013-11-07 15:07:42 UTC
Captain Teuta wrote:
Another question. =)

How can I import the alliance ranking list into Google docs? I've seen it done for other things so I know it must be very simple one line of code. Thanks!

This is all I have so far and it's incomplete.

=importxml("https://api.eveonline.com/eve/AllianceList.xml.aspx")


Please be more specific: what in this list do you consider to be incomplete?

EVEWalletAware - an offline wallet manager.
Captain Teuta
Aliastra
Gallente Federation
#3 - 2013-11-07 15:44:58 UTC
Hel O'Ween wrote:
Captain Teuta wrote:
Another question. =)

How can I import the alliance ranking list into Google docs? I've seen it done for other things so I know it must be very simple one line of code. Thanks!

This is all I have so far and it's incomplete.

=importxml("https://api.eveonline.com/eve/AllianceList.xml.aspx")


Please be more specific: what in this list do you consider to be incomplete?


It's not the list that is incomplete it's my attempt at importing it. The above command/call/importantxml is not complete. It's missing parameters I assume.
Elmore Jones
New Eden Mining Organisation
The Craftsmen
#4 - 2013-11-07 22:04:11 UTC
That api call (detailed here EVElopedia API Alliance list) simply returns a full list of active alliances in the game. I haven't looked into what order they are returned in. To get rankings you would need to process this xml client side to sort by members/sov owned/whatever. I don't think GoogleDocs could handle that :(

A possible workaround could be to use LibreOffice with scripting to format your import and then upload the result to your GoogleDoc.

+++ Reality Error 404 - Reboot Cosmos +++
Hel O'Ween
Men On A Mission
#5 - 2013-11-08 16:12:44 UTC  |  Edited by: Hel O'Ween
Captain Teuta wrote:
Hel O'Ween wrote:
Captain Teuta wrote:
Another question. =)

How can I import the alliance ranking list into Google docs? I've seen it done for other things so I know it must be very simple one line of code. Thanks!

This is all I have so far and it's incomplete.

=importxml("https://api.eveonline.com/eve/AllianceList.xml.aspx")


Please be more specific: what in this list do you consider to be incomplete?


It's not the list that is incomplete it's my attempt at importing it. The above command/call/importantxml is not complete. It's missing parameters I assume.


I'm guessing here as I've never used Google Docs - does Google Docs perhaps have a limit for the size of the XML it imports? Because - as mentioned by Elmore - the API call returns a huge XML with all alliances and all corporations of those alliances.

EVEWalletAware - an offline wallet manager.
Abdiel Kavash
Deep Core Mining Inc.
Caldari State
#6 - 2013-11-11 22:20:26 UTC  |  Edited by: Abdiel Kavash
=importXML("https://api.eveonline.com/eve/AllianceList.xml.aspx?version=1", "//row/@name")

gets you the alliance names, as far as I can tell sorted by member count. If you want the member count, use:

=importXML("https://api.eveonline.com/eve/AllianceList.xml.aspx?version=1", "//row/@membercount")

I can confirm that GDocs handles both without a problem.

For more info see: http://wiki.eve-id.net/APIv2_Eve_AllianceList_XML

I have just written a tutorial covering basic use of the API in Google docs.