Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, i'm tryng to to get Access Token from an OAuth2 Authorization Code flow.
Here the code: "PART 1" work fine and return the Authorization Code, bat "PART 2" don't work and return error.
Thanks for help
let
// PART 1: Get Authorization Code
Body =
"{
""username"":""<MyUsername>"",
""password"":""<MyPsw>"",
""scope"":[""<SelectedScope>""]
}",
url = "http://XXXXXXXXXXXXXXXXXXXXXXXXXXX/api/login/sso",
GetJson = Json.Document(Web.Contents(url, [Headers=[ContentType="application/json"], Content=Text.ToBinary(Body)])),
AuthorizationCode = GetJson,
// The previous code correctly returns the Authorization Code
// PART 2: Now I try to Get Access Token passing the Authorization Code, the client_id and the client_secret
// Base64 Encoding
a = "<client_id>" & ":" & "<client_secret>",
a2 = Text.ToBinary(a),
a3 = Binary.ToText(a2, BinaryEncoding.Base64),
TokenURL = "http://XXXXXXXXXXXXXXXXXXXXXXXXXXX/oauth2/token/",
Body2 =
"{
""grant_type"": ""authorization_code"",
""code"": """&AuthorizationCode&"""
}",
Source = Web.Contents(TokenURL, [Headers = [ContentType="application/json", Authorization = "Basic "&a3&""], Content = Text.ToBinary(Body2)])
in Source
Solved! Go to Solution.
Solved, the problem was due to an erroneous Base64 Encoding
Solved, the problem was due to an erroneous Base64 Encoding
Hi @Marco_Iac,
What type of error message displayed? Can you please share more detailed information?
How to Get Your Question Answered Quickly
In addition, you can also try to add the 'relative path' option to your connector if it works:
let
// PART 1: Get Authorization Code
Body =
"{'username':'<MyUsername>','password':'<MyPsw>','scope':['<SelectedScope>']}",
url = "http://XXXXXXXXXXXXXXXXXXXXXXXXXXX/api/login/sso",
GetJson =
Json.Document(
Web.Contents(
url,
[
Headers = [
ContentType = "application/json"
],
Content = Text.ToBinary(Body)
]
)
),
AuthorizationCode = GetJson,
// The previous code correctly returns the Authorization Code
// PART 2: Now I try to Get Access Token passing the Authorization Code, the client_id and the client_secret
// Base64 Encoding
_client = "<client_id>:<client_secret>",
TokenURL = "http://XXXXXXXX.XXXXXXXXXXX.com",
Body2 =
"{'grant_type': 'authorization_code','code': '"& AuthorizationCode& '" }",
Source =
Web.Contents(
TokenURL,
[
Headers = [
ContentType = "application/json",
Authorization = "Basic " & Binary.ToText(Text.ToBinary(_client), BinaryEncoding.Base64)
],
RelativePath="/oauth2/token/",
Content = Text.ToBinary(Body2)
]
)
in
Source
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
26 | |
3 | |
2 | |
2 | |
2 |