You can translate the question and the replies:

External APIs with Row Limits - How do I get all the rows? ie; Pagination

I'm trying to connect to an external rest service. Unfortunately, this service limits the number of rows per call. My question is how do I loop / continue calling the service until all the data is returned?
user
19-06-2018 11:11:27 -0400

1 Answer

Hi, If you could get the information from the web services as DF, JSON or XML format In Denodo 7.0 I’d recommend you an approach using the XML (JSON and DF are also valid) connector with an HTTP Route as you can read [in this answer](https://community.denodo.com/answers/question/details?questionId=90670000000fynjAAA&Unable+to+setup+a+Workday+connection). In this kind of data sources, you'll be able to limit the number of rows per call configuring the [pagination](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/http_path#pagination) tab of the data route configuration. Hope this helps!
Denodo Team
20-06-2018 12:35:03 -0400
You must sign in to add an answer. If you do not have an account, you can register here