POST Authentication to a REST API

[dcoronno]

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

[Anonymous]

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.

[kleighton]

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

[lbendlin]

You call Web.Contents with a Content payload to transform a GET call into a POST call.

Web.Contents - PowerQuery M | Microsoft Docs