Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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.