Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Housden996
Helper II
Helper II

Copying Paginated data Next page function not working

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:

Housden996_0-1732790159273.png

Pagination rules:

Housden996_2-1732790242289.png

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:

Housden996_1-1732790225441.png

 

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

 

3 REPLIES 3
Anonymous
Not applicable

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. 🙂

Anonymous
Not applicable

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

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Fabric Update Carousel

Fabric Monthly Update - October 2025

Check out the October 2025 Fabric update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors