Q&A BY TAG 'Pagination'

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

Problem with pagination for JSON HTTP datasource
answered 27-10-2022 15:32:23 -0400

I have a JSON HTTP datasource that returns data that looks like this: { "pagination": { "pageNumber": "3", "pageSize": "100", "totalAvailable": "251" }, "datasources": { "datasource": [ {"name": ...

Answers: 1

Pagination JSON Data Source

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