none
Power Query with OAuth 2.0 RRS feed

  • Question

  • Hello,

    I am trying to access APIs on a web site which uses OAuth 2.0.

    I have an App created for my user id on the website and it provides an access token, client id and api key. How do I provide these in the URL in Power Query for authorizing and then access other APIs (for ex, get group info that this user belongs to) in sequence. I did not find much information online.

    Any pointers/documentation is appreciated.

    Thank You,

    Harisha

    Tuesday, May 31, 2016 6:36 PM

Answers

  • We still don't have any way to make use of arbitrary OAuth-protected sites using our built-in credential system. Some people acquire the token through some other means and then manually set the header on the HTTP request. An example of doing that can be found at http://www.poweredsolutions.co/2014/11/06/getting-api-results-from-azure-machine-learning-into-power-query/

    The drawbacks of this approach are that
    1) It exposes a potentially-secret value in your source
    2) The access token tends to have a limited lifespan after which you'll need a new one.

    Friday, June 3, 2016 5:05 PM

All replies

  • We still don't have any way to make use of arbitrary OAuth-protected sites using our built-in credential system. Some people acquire the token through some other means and then manually set the header on the HTTP request. An example of doing that can be found at http://www.poweredsolutions.co/2014/11/06/getting-api-results-from-azure-machine-learning-into-power-query/

    The drawbacks of this approach are that
    1) It exposes a potentially-secret value in your source
    2) The access token tends to have a limited lifespan after which you'll need a new one.

    Friday, June 3, 2016 5:05 PM
  • And now?
    Sunday, July 29, 2018 7:35 PM
  • And now?
    Now we do. Find out more about Custom Connectors here.
    Monday, July 30, 2018 12:52 AM