Connect to API with token that changes

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

Web.Contents - PowerQuery M | Microsoft Docs

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