Get data from API with token

Pla31000 · ‎11-04-2019

Hi,

I have a problem to connect a web source :

I have an URL with a token authentification that is refresh every days.

I'm able to recover datas if i put directly the token in my url , but i have some difficulties to connect with a dynamic parameter :

let
   url = "https://URL/token",
   body = "{""username"":""XXXX"",""password"":""XXXX""}",
   token = Json.Document(Web.Contents(url, [Headers=[#"Content-Type"="application/json"], Content=Text.ToBinary(body)])),
   TokenBin = Json.FromValue(token),
   TokenText = Binary.ToText(TokenBin),
   AccessTokenHeader = "bearer " & TokenText,
   localbusiness = Web.Contents("https://URL/localbusiness", [Headers=[Authorization=AccessTokenHeader]])
in
localbusiness

I notice that on the step where I try to convert the binary value to text, the text string change and make my token invalid.

How can I recover this token in dynamic ?

Thx

---------

Edit :

I found a solution , it works for me :

Instead of using the header authorisation, I put directly the token in the url by using the Uri.BuildQuerryString function :

let
   url = "https://URL/token",
   body = "{""username"":""XXXX"",""password"":""XXXX""}",
   token = Json.Document(Web.Contents(url, [Headers=[#"Content-Type"="application/json"],Content=Text.ToBinary(body)])),
   TokenBin = Json.Document(token),
   tokentext = Uri.BuildQueryString(tokenBin),
   source = Web.Contents("https://URL/localbusiness?"&tokentext),
   localbusiness= Json.Document(source),
   in
localbusiness

Hopes it will help another.