Connect to API with token that changes

[Anonymous]

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

 

 

 

 

 

 

 

[Anonymous]

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?

[Anonymous]

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

[lbendlin]

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

Web.Contents - PowerQuery M | Microsoft Docs

[lbendlin]

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