topic Re: Web API with token in Developer

Web API with token

JeffvH — Fri, 14 May 2021 13:54:32 GMT

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?

Re: Web API with token

BarbaraAckles — Fri, 14 May 2021 22:10:08 GMT

I also had the same issue

Re: Web API with token

V-lianl-msft — Wed, 19 May 2021 02:58:08 GMT

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/