Forum Discussion
Need help overcoming pagination issue with API request (PowerBI <> Scoro)
Hi dnsyzygy ,
You should be able to find a top-level record on each of your endpoints that return the total number of available records, something like this.
Once you've found that, then follow this thread that I answered a while back:
https://community.fabric.microsoft.com/t5/Power-Query/How-to-deal-with-paginated-API/m-p/3222229
It's a far simpler and clearer way of managing pagination than a looping function IMO.
Pete
Hi BA_Pete
thank you for the prompt reply.
Unfortunately I'm still a newby and chatGTP is not managing to help, although I think the problem is more related with Scoro themselves more than anything..
Was wondering if you could be more specific in terms of the code to use in the steps you set out? Or at least in the first, to see if I can get somewhere..?
Probably based on the early part of the code I sent initially. Let me know if you're able to help.
Once again, many thanks for any help you can provide!
Best
dn