You can translate the question and the replies:

Support for custom pagination scheme

We have a third party REST API that we plan to connect from Denodo. The API supports pagination in the following way: The request header specifies start and end index. **Request Header:** Range: items=1-200 The response header specifies the current position as well as max index. **Response Header:** Content-Range: items 1-2/116989 Can this pagination scheme be supported by denodo?
user
03-05-2021 12:31:42 -0400

1 Answer

Hi, Denodo supports Pagination with Indices. You can select this option when indicating the page number as a parameter on the URL or when indicating the range of rows as parameters on the URL. In the tab Pagination, you can then select Paging indices and provide the following information: * Parameter in URL for page size * Page size * Parameter in URL for next records * Index of the first record * Maximum number of requests You can specify the index of the first record and then it will continue until a request returns less rows than the previous request or until the data source reaches the Maximum number of requests. For more information, you can refer to the [Pagination with Indices](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/http_path#pagination-with-indices) section of the Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
05-05-2021 16:26:11 -0400
You must sign in to add an answer. If you do not have an account, you can register here