Web API with token

[JeffvH]

Hi Guys!

I'm completely new to PowerBI and API's... I want to retrieve data via Request URL's.

First I need to login to get a token:

https://dashboard.emb2020.nl/api/Security/Logon?username=USERNAME&password=PASSWORD

Then you'll get this response body:

 { "token": "EDSF4wffrhwszurfhawsuhrf==",
 "userID": "FIRST and LASTNAME",
 "emb": true,
 "language": "nl-nl",
 "i10n": true, "resultCode": 4,
 "resultText": "RECONNECT",
 "resultDescription": "Reconnect gelukt" }

 Now I want to use this token in the next request:

https://dashboard.emb2020.nl/api/Company/GetCompanies?api_key=TOKEN

 The token changes everytime you login, so you can't hardcode it.

What's the easiest way to do this?

[V-lianl-msft]

You have one hour before it expires.

You coulde refer to :

https://community.powerbi.com/t5/Power-Query/Refresh-token-api-call/m-p/937553 

https://www.bmc.com/blogs/microsoft-apis-authentication-tokens/ 

[BarbaraAckles]

I also had the same issue