EVE Technology Lab

 
 

ESI and Power Query Guide

First post
Author
Brave Collective
#1 - 2017-05-11 19:35:11 UTC  |  Edited by: LSky NLX
I finally managed to make SSO authentication work in Microsoft Power Query, in order to make authenticated ESI API calls in Excel and Power BI. Vastly superior to Google Docs in my opinion. Mostly anyway!

Please read this article on the Zansha Wiki to find out how to do this. Bonus guide on Invention by my fellow corp director.

If you have any questions or feedback on this particular method, questions on Excel 2016, or Power BI, hit me up on Slack and I will try to answer your questions.
#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.
Brave Collective
#5 - 2017-06-09 18:20:36 UTC
Anyone else tried playing with this and had more success?
Brave Collective
#6 - 2017-06-11 08:04:00 UTC
I pushed through and got it to work. Please visit the guide here!
Forum Jump