Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Issue with getting data via API with bearer token

Hi,   I am using an API that requires a bearer token embedded in the header that has a 30 min lifespan. I have constructed a Power Query ("M") that will pass the username and password to a Microsof...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,
 
Thanks for following this through. The instructions provided for the API are as follows:
 
1. Create an OAuth2 Session
Create a session and get a token (that you need to pass in your Web API request) using your user credentials by doing a “HTTP POST“ request on the URL. 

 

The base URL used for all operations is formatted as follows: https://{deployedAPIServer}/api/{resource}

 
The “https://{deployedAPIServer}/token/" Microsoft OWIN oauth token endpoint with parameters:
 
 "username", with value: the user login
 "password", with value: the user password
 "grant_type" : password (Resource Owner Password Credentials)
 
The content-type of the request should be: application/x-www-form-url encoded
 

Link to image of C# snippet provided in instructions


If the credentials are valid, the response would be a JSON object:
{"access_token":"..base64 encoded string","token_type":"bearer","expires_in":seconds}"
 
2. Call a Secure API
Call a secure rest API with token.
Set the returned token in your request header as a "Bearer" authentication and make the post, get, delete, .. HTTP call.

 

Link to image of C# snippet provided in instructions

 

Does this help?

jlorenzo's avatar
jlorenzo
Advocate I
9 years ago

Hi aexley,

 

Have you tried with Bearer (in capital letters)? I spent hours with that and finally that was the stupid problem.
Now, my big problem is that this solution does not work me on the Power BI service.

 

Good luck!

  • kailashkrishnan's avatar
    kailashkrishnan
    New Member
    8 years ago

    Hi 

    i had the same issue but with some tweaking i was able to get the post and get token together and work.

     

    my issue was i needed token registeration and use the token as bearer token to get the api call

     

    --------------------

    hope this helps for some one.

     

    ------------------

    let
    url = "http://###########/Portal/api/v1/Token",
    url1 = "http://#########/Portal/api/v1/myapi?FromDate=2017/09/29 01:00:00&ToDate=2017/09/29 23:00:00&",

    GetJson = Web.Contents(url,
    [
    Headers = [#"Accept"="application/json",
    #"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"],
    Content = Text.ToBinary("grant_type=password&username=###########&password=###########&client_id=###########&client_Secret=###########")
    ]
    ),

    FormatAsJson = Json.Document(GetJson),
    AccessToken = FormatAsJson[access_token],
    AccessTokenHeader = "bearer " & AccessToken,

    GetJson1 = Json.Document(Web.Contents(url1 , [Headers=[Authorization= AccessTokenHeader ]]))


    in

    GetJson1

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    jlorenzo kailashkrishnan Anonymous thanks for your input.

     

    Just realised there had been further commentary on this so I thought I'd better close out with my resolution.

     

    jlorenzoI had the same issue. Managed to get the functionality to work from Desktop, but when you push to service, it has authorization issues.

     

    My workaround that I settled on was to make Azure Functions for the API calls which I have scripted in C# then I call the Azure Function as an API.