Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Olivia Zomec
KarmaFleet Goonswarm Federation
0
|
Posted - 2017.02.06 18:52:49 -
[1] - Quote
Is there a list somewhere that shows what the functions are that I can use to import api data into a spreadsheet?
e.g. https://api.eveonline.com/account/characters.xml.aspx?keyID=XXXXXX&vCode=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
What I am mainly after is something that will return a result into a spreadsheet as whether or not the character is training.
Then I want to be able to import the PI information. Such as whether or not the extracting is running or stopped.
I have around 120 characters and the current available programs do not give me what I want. |
Olivia Zomec
KarmaFleet Goonswarm Federation
0
|
Posted - 2017.02.06 18:56:37 -
[2] - Quote
http://eveonline-third-party-documentation.readthedocs.io/en/latest/xmlapi/account/account_characters.html
that doesn't help at all because it doesn't tell you what to type in,
Path: /account/Characters.xml.aspx Cache timer: 1 hour Access mask: 0 Parameters: none
What path, where do I type it in. This page is missing the most basic information. How to use it.
The code listed in my first post is what I am after
Also if it helps, I am inputting this information into google sheets |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6445
|
Posted - 2017.02.06 20:41:42 -
[3] - Quote
http://eveonline-third-party-documentation.readthedocs.io/en/latest/xmlapi/intro.html http://eveonline-third-party-documentation.readthedocs.io/en/latest/xmlapi/authentication.html
It's telling you _exactly_ how to form the urls.
Now, what it's not telling you how to do is use it with google sheets, but that's not API documentation. That's google sheets documentation, on how to consume an XML based API. the XML api documentation isn't missing anything.
And you'll be disappointed with the PI information endpoint. Due to how the database is updated, PI information only updates when you look at it in client (it's a hell of a lot more efficient than doing it on a timer) So, unless you're willing to code up the simulation for extraction, you're not going to get it telling you when it's finished.
If you're willing to learn, I have some sample code for google sheets here: https://github.com/fuzzysteve/eve-googledocs-script
But it's not exactly what you're looking for, so you'll have to write it, using mine as a template. https://github.com/fuzzysteve/eve-googledocs-script/blob/master/MarketOrders.gs is a fair base.
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Olivia Zomec
KarmaFleet Goonswarm Federation
0
|
Posted - 2017.02.07 19:24:40 -
[4] - Quote
I really want to learn this, but the link I posted seems to just dump it on the user without any explanation. e.g. /account/Characters.xml.aspx, it doesn't tell me what other information to put with this, nor does it tell me if tats something I plug into an app, or type directly into the address bar. Once I get the api side of it down, the rest would be fairy simple. |
Olivia Zomec
KarmaFleet Goonswarm Federation
0
|
Posted - 2017.02.07 19:47:06 -
[5] - Quote
Another example of not enough information.
http://eveonline-third-party-documentation.readthedocs.io/en/latest/xmlapi/character/char_planetarypins.html
It tells you that you need to enter the planet id. But doesn't show where in the url it needs to be, or how to type it |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6452
|
Posted - 2017.02.07 21:28:20 -
[6] - Quote
uh, they're parameters?
which meants they go after a ? in a get url.
https://api.eveonline.com/char/PlanetaryPins.xml.aspx?keyID=XXXXXX&vCode=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX&planetID=345894327589&characterid=45283947
That's how they all work.
Make sure to read all the documentation for the XML api, before going to look at the calls on it. It does pretty much explain everything that's specific to it.
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Jaseac
KarmaFleet Goonswarm Federation
8
|
Posted - 2017.02.08 02:56:40 -
[7] - Quote
On the sample code for google sheets you linked, where do you find out how to write it?
e.g. function loadRegionAggregates(priceIDs,regionID){ if (typeof regionID == 'undefined'){ regionID=10000002; }
That all looks like a foreign language to me. |
Althalus Stenory
Flying Blacksmiths
108
|
Posted - 2017.02.08 14:13:59 -
[8] - Quote
https://developers.google.com/apps-script/guides/sheets/functions ?
EsiPy - Python 2.7 / 3.3+ Swagger Client based on pyswagger for ESI
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6452
|
Posted - 2017.02.08 15:11:14 -
[9] - Quote
Jaseac wrote:On the sample code for google sheets you linked, where do you find out how to write it?
e.g. function loadRegionAggregates(priceIDs,regionID){ if (typeof regionID == 'undefined'){ regionID=10000002; }
That all looks like a foreign language to me.
It's (mostly) javascript.
There are tutorials out there, along with sample code.
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |