Hi All, I am trying to use cursoring in Power BI (Power query) to loop through the search results but cant seem to figure out how this is done in power query. I believe List.Generate is the way to go, but havent found how/where i integrate that into my query. Any help greatly appreciated

that looks like the Premium 30day endpoint, in which case, there is a next field in the full response object Premium search APIs | Docs | Twitter Developer Platform

Yes! Cursoring through the results using the ‘next’ is what i need to figure out using Power Query - Cursoring | Docs | Twitter Developer Platform seems to have decent pseudocode but no references how this can be done using power query.

No, the cursoring page you linked is not relevant to you - this is the REST API which is different to the Premium API you’re calling.

Premium search APIs | Docs | Twitter Developer Platform is what you need to implement.

I don’t know Power Query enough to give an example, but you want to extract the next value from the first request, and then add that value to the subsequent request as a parameter, and loop through like that.

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.