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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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
September Fabric Update Carousel

Fabric Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors