Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi
I am workin with a paginated API and it uses unique urls to pull in the following page instead of a sequential page number.
My copy function works but it isnt pulling in the following page, my following copy funcion is working as follows:
Pagination rules:
NOTE: I fixest the end condition so its now empty and it still doesnt work.
The trailing end of the JSON whic contains the next URL which i need to read is as follows:
Any idea what I am doing wrong here? do I need to get this as a variable and pass into a following copy function or should this just work?
Thanks
HI @Housden996,
According to your description and snapshot, it seems like your requirement is mroe realted ot azure data factory pipeline invoke api. For this scenario, I'd like to suggest you post to that forum to get better support.
Azure Data Factory - Microsoft Q&A
Regards,
Xiaoxin Sheng
Thank you I thought this would be the solution, wanted to try here before diving into a new community. 🙂
HI @Housden996,
In fact, paginated API should base on its definitions. (normally it checks the request header, but it also saw some API checked on request body) You should modify the function and request to send the correspond contents based on the API document and definitions.
For example:
Some of API returned page number in the response, some of them show you the next id, and also it can be directly returned the next link URL.
Regards,
Xiaoxin Sheng