requests to a JWT API token

[Anonymous]

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 ?

[dax]

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.

[Anonymous]

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"

[jnickell]

Just wanted to say thank you. Your post gave me the help I needed to solve my own similar JWT authentication issue

https://community.powerbi.com/t5/Power-Query/Assistance-with-converting-CURL-request-into-PowerQuery...