EVE Technology Lab

 
 

ESI and Power Query

First post
Author
Brave Collective
#1 - 2017-05-11 19:35:11 UTC
Has anyone attempted to use ESI with Power Query?
It is able to pull public data just fine, but the moment I try to pull citadel market info, it obviously requires authentication.

I've been trying to emulate the following approaches, but so far it hasn't gotten me anywhere.

https://www.fuzzwork.co.uk/2017/03/14/using-esi-google-sheets/

https://stackoverflow.com/questions/40753188/google-oauth-refresh-tokens-in-power-query

https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/

Anyone have experience with this and know how one may proceed?

#2 - 2017-05-11 22:42:31 UTC
If google sheets would work I made this:

https://github.com/Blacksmoke16/GESI

Otherwise it seems you have to use postman or something similar to manually get a refresh_token. Then you could use that to get a new token when the old token expires as stated in that stackoverflow link, basically how steve does it for his Google Sheets implementation.
Vote Steve Ronuken for CSM
#3 - 2017-05-12 00:57:04 UTC
I spent several hours trying to get it working. And failed. I could get the token, but getting it to use in the next step I couldn't get working.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Brave Collective
#4 - 2017-05-12 07:40:29 UTC
Blacksmoke16 wrote:
If google sheets would work I made this:

https://github.com/Blacksmoke16/GESI

Otherwise it seems you have to use postman or something similar to manually get a refresh_token. Then you could use that to get a new token when the old token expires as stated in that stackoverflow link, basically how steve does it for his Google Sheets implementation.

This is essentially where I am at. However, parsing this token is where I get stuck.
Forum Jump