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.
 

Does ESI work with google sheets?

First post
Author
Previous Topic Next Topic
nether void
Caldari Provisions
Caldari State
#1 - 2017-01-21 18:05:42 UTC
Is there a moderately easy way to get the two to work together? If the XML api is going away and ESI won't work with google sheets I won't bother to automate the new sheet I'm building. I've got it set up to pull prices from eve-central, and that will have to be good enough. But I also would like to pull wallet journal and other character info.

Really will suck to have to hand type in all this crap, but don't want to have to rely on 3rd party apps. They never seem to have the features I'm looking for. Plus I can't simply splice two together when I want to cross reference data from this app to use in that app.
salacious necrosis
Garoun Investment Bank
Gallente Federation
#2 - 2017-01-21 19:07:34 UTC
nether void wrote:
Is there a moderately easy way to get the two to work together? If the XML api is going away and ESI won't work with google sheets I won't bother to automate the new sheet I'm building. I've got it set up to pull prices from eve-central, and that will have to be good enough. But I also would like to pull wallet journal and other character info.

Really will suck to have to hand type in all this crap, but don't want to have to rely on 3rd party apps. They never seem to have the features I'm looking for. Plus I can't simply splice two together when I want to cross reference data from this app to use in that app.


TL;DR Yes for public endpoints, not very easily for authenticated endpoints (e.g. your wallet endpoints). Regardless, you'll need to write some google app script to handle JSON.

Long version...

Public endpoints won't require authenticated scopes, but everything else will and Sheets doesn't give you an easy way to handle the OAuth flow to get an access token. Even if you have an access token, you'll need to use Google App Script to send a request with the proper headers to ESI (using the UrlFetchApp class). Sheets still doesn't handle JSON without resorting to Google App Script either, so you'll have to write a small bit of script to handle ESI call results.

Use EveKit ! - Tools for EVE Online 3rd party development
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2017-01-21 19:32:21 UTC
One ways you can use ESI with authenticated endpoints, is to create a refresh token, and use that to create an access token on demand, from code you've written.

It's a bit of a pain, but once it's done, it's simple enough to work with.

Using something like postman to do the authentication step works well.


Unfortunately, right now, there is no ESI endpoint for wallet transactions. The XML endpoint should be good for the next year and a bit.

(For that kind of data, you'll want to do custom code anyway. Because you don't want to be constantly going back to the source to get data you've already retrieved. for multiple pages)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
nether void
Caldari Provisions
Caldari State
#4 - 2017-01-21 20:21:17 UTC
I'm ok with writing some custom code in google script, just can't find anybody already doing it? I work best from example. lol

Any links to examples?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2017-01-21 21:07:31 UTC
https://github.com/nuadi/googlecrestscript may be of some interest.

Not authed though.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Blacksmoke16
Resilience.
#6 - 2017-01-21 21:29:13 UTC
https://github.com/nuadi/googlecrestscript/blob/dc6b6e80ae9545f4d54490d1c217c3595757e4c4/MarketScript.gs

Is the same script Steve linked but when he first made it and the endpoint required authorization.