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
code

3 Answers

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
code
Thanks for your input. Unfortunately, none of the available options work for us, the APIs we intend to connect to are from a third party software and cannot be changed. Does denodo support customization by means of custom developed components (for pagination)? Or have we reached a dead-end?
user
10-05-2021 11:11:54 -0400
Hi, Denodo supports pagination using the parameters mentioned in the document [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). If you want to consider the API customization by means of custom developed components and if you have a valid support account you can open a support case on [Denodo Support Site](https://support.denodo.com/) so that the support team can help you. Hope this helps!
Denodo Team
21-05-2021 21:56:16 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here