Forum Discussion

Falcon's avatar
Falcon
Helper I
4 years ago
Solved

Connect API oauth2 to pull data

Hello Everyone, I am trying to pull API data using oauth2. I have been following different methods online without success. All I have are token URL: https://xxxxxxxx/api/v2/oauth/token client_id:...
Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    Falcon

    I've just noticed that the json was malformed + I've added a relative path for the auth.
    Try this:

    let
    ClientId = "XXXXXXX",
    ClientSecret = "XXXXXXX",
    Uri = "https://secure9.aladtec.com/",
    Body ="{
        ""grant_type"": ""client_credentials"",
        ""client_id"": """ & ClientId & """,
        ""client_secret"": """ & ClientSecret & """
}",
    OAuth2Response = Web.Contents(Uri, [RelativePath = "mohcacc/api/v2/oauth/token", Content=Text.ToBinary(Body)])
in
    OAuth2Response

     

SpartaBI's avatar
SpartaBI
Community Champion
4 years ago

Falcon

I've just noticed that the json was malformed + I've added a relative path for the auth.
Try this:

let
    ClientId = "XXXXXXX",
    ClientSecret = "XXXXXXX",
    Uri = "https://secure9.aladtec.com/",
    Body ="{
        ""grant_type"": ""client_credentials"",
        ""client_id"": """ & ClientId & """,
        ""client_secret"": """ & ClientSecret & """
}",
    OAuth2Response = Web.Contents(Uri, [RelativePath = "mohcacc/api/v2/oauth/token", Content=Text.ToBinary(Body)])
in
    OAuth2Response

 

  • Falcon's avatar
    Falcon
    Helper I
    4 years ago

    OMG that worked, thanks SpartaBI, you're such a big help