I have a JSON HTTP datasource that returns data that looks like this:
```
{
"pagination": {
"pageNumber": "3",
"pageSize": "100",
"totalAvailable": "251"
},
"datasources": {
"datasource": [
{"name": "some datasource", "id": 1},
{"name": "another datasource", "id": 2}
]
}
}
```
I created a JSON base view with the tuple root set as /JSONFile/datasources/datasource and this successfully returns one row for each item in the datasource array. But when I try and set up pagination (using pageSize/pageNumber URL parameters) the view fails as Denodo doesn't stop the page requests after there are no more records to return.
The documentation claims that Denodo should stop making requests as soon as a request returns fewer rows than the previous one, but this doesn't appear to be happening. Furthermore if the number of rows is divisible by the page size this method would fail. It seems we should be able to make a setting to get the datasource to stop making requests when a certain HTTP code is returned, in this case it would be 400.
