I am facing an issue while paginating the data. We are getting response details in JSOn format and we are simply passing the path of that next page in JSON data source.
But the Denodo Pagination mechanism is something where complete URI will be replaced with nextpage option. However we have a requirement where we need to have some part of URI to be passed with pagination
Example:
1. This is a rough example : I have added this query in ds and this gives me first 1000 records
https://ddtest.com/test/api/query?q=Select first_name, last_name, modified_name from apps
2. Now response has next Page value, I have enabled pagination where I am trying to obtain next page URL from response and I failed.
3. This pagination replaces the current URL to https://ddtest.com/<nextpage value> and this fails becasue we need some part of URI in the pagination request
4. The request from Pagination should happen like this : https://ddtest.com/test/api/<nextpage value> <------This will work fine but we are uanble to achieve this. Can you pleas ehelp on this?
