topic Re: REST API Pagination in Connectivity & Data Prep

REST API Pagination

yuvaraj2020 — Tue, 21 Dec 2021 13:58:50 GMT

HI ,

Please assist me on REST API Pagination Offset connection, while using Pagination Offset drop down, I having following fields to filled

offset value, start initial value, count value and total records path. i m not sure how to fill the total records path. please assist how to fetch the total records path in pagination.....

Re: REST API Pagination

petter — Thu, 01 Nov 2018 06:04:58 GMT

The total records path is dependent on the data structure in the file you are reading so you will have to provide us with a sample of that file. In general it is the nesting of the structure separated by slashes which lead to the place where the total records are provided in the data file.

Re: REST API Pagination

stevedark — Thu, 01 Nov 2018 06:59:30 GMT

Hi, I have found in the past that using the parameters in the connection is more of a hassle then just using the WITH CONNECTION settings and passing in the parameters required by the API directly. Depending on the API you will need to pass the page number or max record number that you are after as a parameter.

Which APl is it you are using?

Steve

Re: REST API Pagination

yuvaraj2020 — Thu, 01 Nov 2018 08:20:28 GMT

REST API Connector

Re: REST API Pagination

yuvaraj2020 — Thu, 01 Nov 2018 08:21:13 GMT

REST API COnnector to Fetch JSON

Re: REST API Pagination

petter — Thu, 01 Nov 2018 10:10:09 GMT

Actually - helping out via the forum to get the REST Connector to work OK is a pain....

Thanks for the screenshots but they don't help me all the way to understand how to get the path right.

You will have to figure out the nesting level of where the TotalResultCount resides and then take the various names that that the tags have leading to this and construct the path - something like this:

root/meta/total_count

for your case it might be:

root/QueryResult/TotalResultCount

Re: REST API Pagination

yuvaraj2020 — Thu, 01 Nov 2018 10:23:04 GMT

I have tried the same "root/QueryResult/TotalResultCount" but it doesn't works, it shows me the error data path is wrong..

Re: REST API Pagination

petter — Thu, 01 Nov 2018 10:24:18 GMT

Use the preview in your Data load editor to find how the path should be constructed - don't guess.

Re: REST API Pagination

stevedark — Thu, 01 Nov 2018 10:29:32 GMT

When I have an API that is being particularly fiddly I tend to use PostMan (https://www.getpostman.com/) and get it working in there first. Once you have the correct paging coming back in PostMan it is usually relatively simple to migrate that across to Qlik.

Re: REST API Pagination

pkostick — Tue, 26 Feb 2019 18:56:27 GMT

Steve,

How does one specify that the QVRestConnector.exe is being used within the WITH CONNECTION syntax?

Pete