Access Token - Client Credentials - Power BI - Connecting API

[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!

[Anonymous]

Hi @uma_mahi 

Based on your code,  you can use web.content connector and you can refer to the following link.

Solved: Connect API with expiring bearer token - Microsoft Fabric Community

Solved: Connect to a Web Service sending parameters - Microsoft Fabric Community

Solved: Channel Advisor API Connection with auth key creat... - Microsoft Fabric Community

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.