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.
 

Api pulls. A list of functions

First post
Author
Olivia Zomec
The Scope
Gallente Federation
#1 - 2017-02-06 18:52:49 UTC
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
The Scope
Gallente Federation
#2 - 2017-02-06 18:56:37 UTC  |  Edited by: Olivia Zomec
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
#3 - 2017-02-06 20:41:42 UTC  |  Edited by: Steve Ronuken
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) Edit: I've now been informed it includes extraction expiration times. So you'd get that at least.

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
The Scope
Gallente Federation
#4 - 2017-02-07 19:24:40 UTC
Steve Ronuken wrote:
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) Edit: I've now been informed it includes extraction expiration times. So you'd get that at least.

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.




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
The Scope
Gallente Federation
#5 - 2017-02-07 19:47:06 UTC
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
#6 - 2017-02-07 21:28:20 UTC
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
The Scope
Gallente Federation
#7 - 2017-02-08 02:56:40 UTC
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
#8 - 2017-02-08 14:13:59 UTC
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
#9 - 2017-02-08 15:11:14 UTC
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. Lol

There are tutorials out there, along with sample code.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter