How to fetch Data from API with dynamic access token

Question

Hi Team,&nbsp;Im new to API/REST API methods in PowerBI. So please help me with understand and how to achieve the below requirement&nbsp;Im trying to fetch the WebEx meeting informaiton for my analysis from&nbsp;https://webexapis.com/v1/meetingsOur webex support team has given me a document which to follow some steps to get to the actual data. Below are the steps&nbsp;1. go to https://developer.webex.com&nbsp;and create an integration which provides me client ID, client Secret ID and&nbsp;OAuth Authorization URL. Here is the documentation to for the same&nbsp;https://developer.webex.com/docs/integrations&nbsp;2. when we enter the&nbsp;OAuth Authorization URL in to the brower and hit enter, we get the code3. with this code, client ID, client secret id, go to postman and generate the access token4. this access token is then used to generate the bearer token&nbsp;5. with the bearer token entered as one of th parameters, we will be able to get to the actual data in Postman&nbsp;Now, the question is how to do this in powerbi without going to developer.webex.com&nbsp;&nbsp;Please help me as i have relatively zero knowledge on APIs

amitchandak · Answer

LP2803 , refer if this can help
https://www.youtube.com/watch?v=N8qYRSqRz84
https://docs.microsoft.com/en-us/rest/api/power-bi/embedtoken/generatetoken

anonymous · Answer

Hi&nbsp;LP2803&nbsp;,Hope&nbsp;the links could help you a little bithttps://community.powerbi.com/t5/Desktop/Pull-data-from-RESTful-API-with-token-authentication/td-p/80531https://community.powerbi.com/t5/Desktop/REST-API-With-Authentication-and-Dynamic-Variables/td-p/888225https://community.powerbi.com/t5/Desktop/Issue-with-getting-data-via-API-with-bearer-token/td-p/126232https://community.powerbi.com/t5/Desktop/Pull-data-from-RESTful-API-with-token-authentication/td-p/80531/page/2https://docs.microsoft.com/en-us/power-bi/developer/automation/walkthrough-push-data-get-token&nbsp;Best Regards,Eyelyn Qin

shrutivyas06 · Answer

Hello,&nbsp;You can refer below blog to achieve this functionality-https://www.advaiya.com/generate-dynamic-token-and-get-data-from-custom-api-in-power-bi/&nbsp;RegardsShruti Vyas

vr_2020 · Answer

shrutivyas06&nbsp;- I was trying to use this code in Blank Query in Advance editor as per your blog and getting filed token not found. Looks like the API URL for token generation that I am trying to use in the following code seems to be wrong. Can you please help me with one sample API URL format that should be used in url = &lt;&lt;API Url for token generation&gt;&gt;&nbsp;leturl = &lt;&lt;API Url for token generation&gt;&gt;,headers = [#"Content-Type" = "application/json"],postData = Json.FromValue([username="&lt;&lt;User Name&gt;&gt;",password= "&lt;&lt;Password&gt;&gt;"]),response = Web.Contents(url,[Headers = headers,Content = postData]),Data = Json.Document(response),access_token=Data[token]inaccess_token&nbsp;&nbsp;

Forum Discussion

How to fetch Data from API with dynamic access token

4 Replies

Related content

Error fetching data

Error Fetching Data

Error fetching data

Fetch licences information

Dynamically Fetch and Display Documents in Power BI