Get data from API with token

Pla31000 — Thu, 07 Nov 2019 16:39:01 GMT

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.

topic Get data from API with token in Developer

Get data from API with token