Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Samuel Sachs
5
|
Posted - 2014.04.29 17:05:00 -
[1] - Quote
Hi,
need a bit help, working on an table that shows alliances from eve online and corporations in there, with member count and other datas, my problem is now, i didnt know how to import this right into docs, found this:
https://api.eveonline.com/eve/AllianceList.xml.aspx
Basic like this i need in my spreadsheet, than i can filter corporations and the other stuff i want maybe ?
https://neweden-dev.com/Eve/Alliance_List
But when i use the command =IMPORTxml(https://api.eveonline.com/eve/AllianceList.xml.aspx) give me only an error message.
how i can do this right?
|
Wafflehead
Hurricane Research
94
|
Posted - 2014.04.30 17:48:00 -
[2] - Quote
Samuel Sachs wrote:Hi, need a bit help, working on an table that shows alliances from eve online and corporations in there, with member count and other datas, my problem is now, i didnt know how to import this right into docs, found this: https://api.eveonline.com/eve/AllianceList.xml.aspxBasic like this i need in my spreadsheet, than i can filter corporations and the other stuff i want maybe ? https://neweden-dev.com/Eve/Alliance_ListBut when i use the command =IMPORTxml(https://api.eveonline.com/eve/AllianceList.xml.aspx) give me only an error message. how i can do this right?
=importXML("https://api.eveonline.com/eve/AllianceList.xml.aspx?version=1", "//row/@name")
This will display all the names, you can just amend the above to what you need |
Samuel Sachs
5
|
Posted - 2014.05.10 02:45:00 -
[3] - Quote
Thanks for your help!
Ok, i was able to import something, but what i want exactly is the follow, i want do a list of the corporation members from an alliance, then i want see how many members theyr corporations have and who is the corporation ceo.
How do i get the corp member count is what i have now with this: =importxml("http://api.eveonline.com/corp/CorporationSheet.xml.aspx?corporationID=1117003242", "// memberCount")
What i still missing is how i can import the member corporations from an alliance, maybe somebody can tell me how it works? |
Samuel Sachs
5
|
Posted - 2014.05.22 21:24:00 -
[4] - Quote
Ideas please |
Louis Vitton
Viziam Amarr Empire
79
|
Posted - 2014.05.22 21:51:00 -
[5] - Quote
use use the following URL: https://api.eveonline.com/eve/AllianceList.xml.aspx Notice that there is no version=1 there. This will give you a full list of alliances and corporations that are members of them. |
Samuel Sachs
5
|
Posted - 2014.05.23 19:02:00 -
[6] - Quote
=importxml("https://api.eveonline.com/eve/AllianceList.xml.aspx?version=2", "//row[@allianceid='99004126']/@memberCorporations")
is an example what i try to use but gdocs gives me an answer that the resource from this url is to big.
Any Ideas ?
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |