Forum Discussion

DLEATE's avatar
DLEATE
Frequent Visitor
4 years ago

Help Needed with Recursive Pagination based on the value of a parameter

I was wondering if anyone could help me, I am tying to pull around 3k records from Qualys API however they have a max limit of 1000 per query. I have managed to get a working query that extracts the...
Need Help
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi DLEATE 

 

I'm not able to provide detailed suggestions as I don't have much experience in this kind of recursive pagination. I found some articles and videos for related topics. Hope they would be helpful. 

Fibonacci Sequence: Understanding the Power Query Recursive Function for Power BI 

Start of series: Programming loops with M-language in Power Query 

How to do Pagination without knowing the number of pages (Part 2) in Power Query | List.Generate 

How to Use List Generate to Make API calls in Power Query 

Iterate Over Dynamic Web API Pages With Power Query – How To Resolve Cursor-Based Pagination 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.