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.
 

ESI and Power Query Guide

First post
Author
Previous Topic Next Topic
LSky NLX
Brave Newbies Inc.
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.
Blacksmoke16
Resilience.
#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.
Steve Ronuken
Fuzzwork Enterprises
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
LSky NLX
Brave Newbies Inc.
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.
LSky NLX
Brave Newbies Inc.
Brave Collective
#5 - 2017-06-09 18:20:36 UTC
Anyone else tried playing with this and had more success?
LSky NLX
Brave Newbies Inc.
Brave Collective
#6 - 2017-06-11 08:04:00 UTC
I pushed through and got it to work. Please visit the guide here!