Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello I need to get the jwt token to access an API, my request does not work
My code :
let
GetJson = Web.Contents("https://xxxxxxxxxxxxxx",
[
Headers = [#"Accept"="application/json",
#"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"],
Content = Text.ToBinary("username=xxxxxx&password=xxxxxxxx")
]
),
FormatAsJson = Json.Document(GetJson),
#"Converted to Table" = Record.ToTable(FormatAsJson),
access_token = #"Converted to Table"{0}[Value]
in
access_token
power Bi return an error 404.
If I try with postman, I have no problem
curl --location --request POST 'https:xxxxxxxxxxxxx' \
--header 'Content-Type: application/json' \
--data-raw '{
"username": "xxxxxxxxxx",
"password": "xxxxxxxxx"
}'
Can anyone help me ?
Hi @Anonymous ,
Did you directly add credential in header? If you pass credential by authentication window(after you click "connect", the authentication window will prompt), will it work? You also could try to use Fiddler to find the detailed error information
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
my request works with the following code :
let
url = "https://xxxxxxxx",
body = "{ ""username"": ""xxxxxxxxxxx"", ""password"": ""xxxx""}",
Parsed_JSON = Json.Document(body),
BuildQueryString = Uri.BuildQueryString(Parsed_JSON),
token = Json.Document(Web.Contents(url,[Headers = [#"Content-Type"="application/json"], Content = Text.ToBinary(body) ] )),
#"Converti en table" = Record.ToTable(token)
in
#"Converti en table"
Just wanted to say thank you. Your post gave me the help I needed to solve my own similar JWT authentication issue
User | Count |
---|---|
64 | |
59 | |
47 | |
33 | |
32 |
User | Count |
---|---|
84 | |
75 | |
56 | |
50 | |
44 |