Forum Discussion
Rest API Pagination Issue
I don't see any variable used in your relative url which holds the pagination. You should follow the documentation which url parameters you should use. But, let's say you have two url parameters offset and count. Your relative url should be
service/dataservice/runquery?configCode=ds_p6adminuser&offset=offsetVariable&count=5000.
You should have created a variable named offsetVariable and count should be equal to the last column of your pagination rules, which is also 5000 in your screenshot. You should change {offset} to the variable offsetVariable.
Hi, I think your parameter offset is not set correctly. What is your relative URL and are you using parameters for this setup? I found this post helpful in understanding the necessary steps: https://techcommunity.microsoft.com/blog/fasttrackforazureblog/implementing-pagination-with-the-copy-activity-in-microsoft-fabric/3914977. Please read step 2 carefully and check if that setup is used correctly.