Connecting API - Power BI - Client Credentials

[uma_mahi]

Hi Team ,
Can you please help me how to pass the below query in Power Query and Is it possible to pass the below request in Power BI? Is there any tutorial which explains about the API and how it works with Power BI? Please guide me on this.
access_token_response = requests.post('https://api.xxx.com/auth/connect/token',

                                      headers={'Content-type': 'application/x-www-form-urlencoded'},

                                      data={ 'client_id': '1232cd11-7862-1111-83c2-28f5a0b6ce0a', 'client_secret': 'QopQopQop133111', 'grant_type': 'client_credentials', })

access_token = access_token_response.json().get('access_token')

print("Access Token", access_token)

accounts_response = requests.get('https://web-api.xxx.com/enterprise/v1/accounts',

                                 headers={ "Accept": "application/json", "Authorization": f'Bearer {access_token}' })
Thanks!

[v-shex-msft · Accepted solution]

HI @uma_mahi,

You can try to use the following M query codes if they help for your scenario:

let
    url = "https://web-api.xxx.com",
    body = "{ 'client_id': '1232cd11-7862-1111-83c2-28f5a0b6ce0a', 'client_secret': 'QopQopQop133111', 'grant_type': 'client_credentials'}",
    token_response = Web.Contents(
        url,
        [
            RelativePath = "/auth/connect/token",
            Headers = [#"Content-Type" = "application/x-www-form-urlencoded"],
            Content = Text.ToBinary(body)
        ]
    ),
    access_token = Json.Document(token_response)[access_token],
    accounts_response = Web.Contents(
        url,
        [
            RelativePath = "/enterprise/v1/accounts",
            Headers = [Accept = "application/json", Authoraztion = "Bearer " & access_token]
        ]
    ),
    Result = Json.Document(accounts_response)
in
    Result

Regards,

Xiaoxin Sheng