Forum Discussion

dcoronno's avatar
dcoronno
Regular Visitor
5 years ago

POST Authentication to a REST API

Hi,

 

I am having issues doing a POST method in M to grab an authentication token.
Specifically I am trying to grab data out of the REST API to Power Query for Excel..

 

They have given a piece of curl code, but I am having trouble dissecting it into M.

curl -X POST --user {user}:'{password}' https://auth.anaplan.com/token/authenticate

 

Any help would be appreciated

Need Help

3 Replies

  • kleighton's avatar
    kleighton
    Helper II
    5 years ago

    Hi,

     

    I was fighting with retrieving authentication tokens for some time. Here's what worked in my situation. The following is a function to retrieve an Auth Token which i then call in several different data queries. You may need to change the content type. Hope you can make it work for you! 

     

    let
    Source = () =>
    let
    body = "{
    ""user"": ""UserHere"",
    ""pass"": ""PassHere""
    }",
    Data=Json.Document(Web.Contents("https://LinkHere", [Headers=[#"Content-Type"="application/json"], Content=Text.ToBinary(body)])),
    access_token = Data[token]
    in
    access_token
    in
    Source

     

    cheers,

    Keith

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi dcoronno ,

     

    You could try this

    Get Access token in Power BI Desktop:


 

() =>

 

let

    body = "client_id=" & #"App ID"

    & "&scope=https://analysis.windows.net/powerbi/api/.default&client_secret=" & #"App Secret"

    & "&grant_type=client_credentials",

    Data= Json.Document(Web.Contents("https://login.microsoftonline.com/"& TenantID & "/oauth2/v2.0/token/",

    [Headers=[#"Content-Type"="application/x-www-form-urlencoded"], Content=Text.ToBinary(body)])),

    access_token = Data[access_token]

in

    access_token

     

    This is the official document you can refer to.

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.