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.
 

Eve API Calls inside a google doc?
Author
Previous Topic Next Topic
Rosco Botix
Space Force Logistics
#1 - 2014-08-19 13:16:51 UTC
Hello Everyone,

Does anyone have a tutorial for calling eve API Data inside of a google doc? Is this possible to do? I'm specifically trying to list my current market orders and their stock level in a particular station's market. I am able to get this data through many different apps however I'd like to get the info pulling automatically into a spreadsheet if I can.

Thanks,
Rosco
Leoric Firesword
Imperial Shipment
Amarr Empire
#2 - 2014-08-19 13:22:27 UTC
totally doable

=IMPORTXML("http://api.eveonline.com/char/MarketOrders.xml.aspx?keyId=YOURKEYIDHERE&vCode=YOURVCODEHERE", "/eveapi/result/rowset/row/@volentered")

you have to give it an attribute to pull back otherwise you get nothing. you may want to paste the url minus the eveapi part so you can see the attributes you can pull back
Rosco Botix
Space Force Logistics
#3 - 2014-08-19 13:57:18 UTC
Thank You, I'm a spreadsheet noob. I appreciate it
Leoric Firesword
Imperial Shipment
Amarr Empire
#4 - 2014-08-19 14:06:17 UTC
Rosco Botix wrote:
Thank You, I'm a spreadsheet noob. I appreciate it


Don't feel bad, took me almost a day of beating my head against a wall to figure out that I needed to tell it I wanted attributes back
Rosco Botix
Space Force Logistics
#5 - 2014-08-19 14:23:36 UTC
Follow up question, How often will that pull the info from the api? I want to make sure I'm not flooding them with requests or anything. Also is there a suggested interval for how often is acceptable to pull the info?
Dragonaire
Here there be Dragons
#6 - 2014-08-19 18:33:21 UTC
Each API has a cachedUntil time in the XML you should obey.

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.
Leoric Firesword
Imperial Shipment
Amarr Empire
#7 - 2014-08-21 13:12:43 UTC
it seems to only pull when I open the sheet, I think there's a 2 hour internal timer for grabbing it again.
Derrick Miles
Death Rabbit Ky Oneida
#8 - 2014-08-21 13:17:01 UTC
You can check the cachedUntil in the examples on the New Eden Development wiki for the API endpoint. You can find the market orders endpoint here, looks like it's one hour.