Forum Discussion

gilbertendaya's avatar
gilbertendaya
Helper IV
5 years ago

Get authorization token from API url

How can I get the authorization token value? I'm using advanced editor in power BI desktop. I do have the generating token URL also the credentials (user and password).   let GetJson = Web.Conten...
gilbertendaya's avatar
gilbertendaya
Helper IV
5 years ago

hi ImkeF thank you for the reply. Is there no easy way in M-query to do this?  

gilbertendaya's avatar
gilbertendaya
Helper IV
5 years ago

hi ImkeF and amitchandak 
do you know how to convert this to M-query?

 

{
    "limit": 10,
    "aggregate": [
        {
            "$sort": {
                "dateProcessed": -1
            }
        },
        {
            "$match": {
               
            }
        }
    ]
}
 
This is for the body.
  • ImkeF's avatar
    ImkeF
    Community Champion
    5 years ago

    Hi gilbertendaya 

    you can simply wrap it into a Json.Document-formula if you escape the quotes like so:

     

     

    Json.Document( "{ ""limit"" : 10 , ""aggregate"" : [ { ""$sort"" : { ""dateProcessed"" : -1 } }, { ""$match"" : { } } ]}")

     

     

    If you have oauth, there is no simpler way in PQ, unfortunately.

     

  • gilbertendaya's avatar
    gilbertendaya
    Helper IV
    5 years ago

    hi ImkeF amitchandak  sorry again for the questions. Please see attached image. I was able to get the token and assigned it to a variable: authKey2 for Bearer Token.

     

    Also added the body.

    I encountered the error:

     

     

    What is this error? Please advise.

    Thank you always.

  • ImkeF's avatar
    ImkeF
    Community Champion
    5 years ago

    Hi gilbertendaya ,

    this is an authentication error.

    I can only repeat that to my knowledge you cannot create an oauth flow without a custom connector in Power Query.

     

  • ImkeF's avatar
    ImkeF
    Community Champion
    5 years ago

    Hi gilbertendaya ,

    sorry to hear. But the link you've provided does contain nothing that relates to authentication. So don't know how I could help here.