These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Science & Industry

 
  • Topic is locked indefinitely.
 

Import industry jobs google doc

First post
Author
Previous Topic Next Topic
Faith Cassidy
Sebiestor Tribe
Minmatar Republic
#1 - 2014-12-31 14:44:20 UTC
The documentation for the eve api is non existent, how would I import industry jobs into a google doc?
Alhira Katserna
Deep Space Exploration And Exploitation
#2 - 2014-12-31 14:58:51 UTC
i am using this

Quote:
=IMPORTXML("http://api.eveonline.com/char/industryjobs.xml.aspx?keyId=XXXXX&vCode=XXXXX", "/eveapi/result/rowset/row/@blueprinttypename")


and to get a clue about what i am looking for i use this site New Eden Dev Site where we can find under 'character' this site https://neweden-dev.com/Char/IndustryJobs and under the xml output you can find the endpoints for this stuff and all other aswell on the page before.
Faith Cassidy
Sebiestor Tribe
Minmatar Republic
#3 - 2014-12-31 15:03:59 UTC
awesome thanks
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2014-12-31 15:57:45 UTC
https://github.com/fuzzysteve/eve-googledocs-script/blob/master/IndustryJobs.gs may also be of interest.

open your sheet, go to tools -> script editor, hit the close button (it'll only show that screen once per sheet), delete the text that's there, then paste in the function.

Then

=loadJobs("corp",650435,"7okqZ1gsdrkjtghk453nGnVWqb2wkyd21C",90926985)
=loadJobs("corp",650435,"7okqZ1gsdrkjtghk453nGnVWqb2wkyd21C",90926985,1) (if you want the history as well)

change corp to char, if you only want your own jobs

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter