topic Re: Connect to API with token that changes in Developer

Connect to API with token that changes

Anonymous — Fri, 29 Apr 2022 15:10:47 GMT

Hello, I am trying to connect to an API that requires re creation of a token every 8 hours. I can get it to create a token and pull the json into postman, but not into Power Bi. When I use that postman token. I also don't know how to code it in bi to make a new token, as this one expires every 8 hours.

I am entering information into Power Bi and getting the 400 error, and referring to swagger endpoints for the API

Re: Connect to API with token that changes

lbendlin — Mon, 02 May 2022 12:32:31 GMT

There are many examples for handling refresh tokens. Here is one : Solved: Refresh token api call - Microsoft Power BI Community

Re: Connect to API with token that changes

Anonymous — Mon, 02 May 2022 12:43:09 GMT

I'm now finding the issue is it is a POST request instead of GET, is there any way to connect to data of they have it set up as a POST?

Re: Connect to API with token that changes

lbendlin — Mon, 02 May 2022 12:46:18 GMT

Providing a Content payload to Web.Contents() converts the API call from GET to POST.

Web.Contents - PowerQuery M | Microsoft Docs

Re: Connect to API with token that changes

Anonymous — Mon, 09 May 2022 00:55:00 GMT

HI @Anonymous,

In fact, you can also use post requests in the power query web connector. You need to add the request contents to the header or body(this is based on your API settings) and attached them to the data connector.

let rootURL = "app.xxx.com", secretId = xxxxx, GetJson = Web.Contents( rootURL, [ Headers = [ #"Authorization" = "Basic " & secretId, #"Content-Type" = "application/json" ], Content = Text.ToBinary("grant_type=client_credentials") ] ), body = "xxxxx", Result = Web.Contents( rootURL, [ Headers = [ Authorization = "Bearer " + token, apikey = "xxxxxxx", RelativePath = "/api/departments/list/", Content = Text.ToBinary(body), ContentType = "application/json" ], Query = [ page = "1", sortDirection = "asc" ] ] ) in Result

Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code Chris Webb's BI Blog (crossjoin.co.uk)

Regards,

Xiaoxin Sheng