Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

requests to a JWT API token

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 ?

Need Help

3 Replies

  • dax's avatar
    dax
    Community Support
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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"