Q&A BY TAG 'pagination'

You must sign in to ask a question. If you do not have an account, you can register here

API connection working but cannot paginate using a cursor key reference in the JSON response
answered 25-02-2022 00:53:13 -0500

I have a working API call that returns the first set of data without error (up to first 5000 records). However, when I try to set up pagination using a value in the end of the results it spins indefinitely. The token to use is called "cursor" at th...

Answers: 1

Pagination API

Pagination issue which retrieving data from API
answered 02-09-2021 13:44:50 -0400

We are connecting to API via a GATEWAY where our request is passed though based on the URI. Example 1) We have a API https://abc.com/api/v1.1/ 2) We need to call the API via a gateway, So Denodo will call http://gateway.com/abc/api/v1.1/query/pagesiz...

Answers: 1

REST API Pagination Denodo Pagination

Support for custom pagination scheme
answered 21-05-2021 21:56:16 -0400

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 posit...

Answers: 3

Pagination

Joins with Paginated Data
answered 29-04-2021 13:48:58 -0400

If we have a schenario where results from two paginated APIs are to be JOINED. e.g. We have 1 million customers, and an API that returns 100 at a time. And another API that reutrn All Customer Orders, again 100 at a time, with no guarantee about what p...

Answers: 1

Pagination join

Get all JSON results from restful webservice
answered 21-04-2021 07:22:54 -0400

I have the following URL that is return JSON format for one of my views: http://mycompany:9090/denodo-restfulws/hcc_dv/views/mytestview/?$format=JSON However, it only returns the first 25 rows. I have tried every conceivable varitation to get all 150 ...

Answers: 1

pagination json REST Webservice

Pagination Issue
answered 22-10-2020 08:41:33 -0400

Here is the format of data : { "name": "mytable", "elements": [ { "name": Den, "number": null, "date": "2020-06-12", "designation": null }, ...........1000 rows exist ] "links": [ { "rel": "next", "title": "Next interval", "href": "?$start_index=...

Answers: 1

Pagination

Want API as paginated
answered 02-10-2020 08:30:49 -0400

Hello, Below is the Scenario, Please suggest I have extrenal API that gives me limit of 1000 records at a time. The data that I receive contains link for next page(a half link ex:) Full link is like : https:/exmaple.com/sgvu/myapi/query?Select n...

Answers: 1

Pagination #API #Rest_API

Iterate Api
answered 29-09-2020 21:09:37 -0400

Hello, I have 12 number of pages with my API with limit of 1000 and offset of 1000. Now If I obtain a single page of data it consists of 1000 rows of data and I cannot increase the limit to even 2000 becuase of source that provides only 1k data at a ...

Answers: 1

Pagination #API #Rest_API

Json data source pagination
answered 30-06-2020 17:43:41 -0400

Hi , I am able to fetch the data from API using oauth2 successfully, I am facing a challenge in configuring the pagination. https://apiexplorer.csod.com/apiconnectorweb/apiexplorer#/info I am trying to fetch the data from the above instructions, as ...

Answers: 3

Pagination REST API get JSON oauth2

Denodo workday connection - Pagination
answered 19-06-2020 00:31:12 -0400

Hi team, i have imported workday SOAP Web Service using an XML data source in denodo. The web service has multiple pages. But base view is giving data from only 1st page by default. I need to get all the web pages in single request. I could find pagina...

Answers: 3

pagination Workday