Passing OAuth Credentials Between Calls for A Data Source

[wcameron14]

I am working with the Twitter Ads API and trying to pull data into Power BI. As best as I can tell from all of the documentation, the Ads API requires multiple calls to access (POST/GET to get the oauth token then POST/GET to get the data). I need to be able to set the response from a call as a variable in the next call in order to access the data. How do I do that? I feel ok about setting the initial credentials (client ID and access token) for the first call but I'm not sure how to do the additional calls.

[dax]

Hi @wcameron14 , 

You could refer to get-data-from-twitter-api-with-power-query  and https://community.powerbi.com/t5/Power-Query/Looping-API-Call/td-p/1051251  for details.

Best Regards,
Zoe Zhi

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