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 Xiaoxin Sheng,
The Url and Relative Url we are using is these:
https://ksa1.p6.oraclecloud.com
/xxxxxx/pds/rest-service/dataservice/runquery?configCode=ds_p6adminuser
and provided the pagination as below:
and the output is we are getting 40 times duplicate data.
Could you help us to get the Incremental data.
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.