Forum Discussion
List.Generate - Qualys API - Issue fetching all records
Hi All, I am trying to access the Qualys API data (Post request). I succesfully get the first 300 records (API limits is 300 records). The response has fields "hasMore" and "lastseenId" based on...
Does the dataurl include the "?" ? That may be missing.
[Result = Json.Document(Web.Contents(data_url & "?" & "lastSeenId=" [Result][lastSeenID]
Pat
The URL does include "?" however I still tried how you mention but no luck.
Hi HR_BI
I find some post with problems similar with yours, I hope they could help you solve your problem.
For reference:
Web API - Pagination of results restricted to 100 by API
How To Do Pagination In Power Query
Using a loop to pull more than 100 items from API
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.