topic Re: QvRestconnector in QlikView

QvRestconnector

John4 — Mon, 26 Jan 2026 21:26:37 GMT

Hello,
i'm loading data from an API (postman) using Qvrestconnector on qlikview it only loaded first 400 records only,

i'm trying to make a loop but it loads same records with different key roots,

i want to be abl to load the rest of data or how to add a new offset record everytime the loop runs? any help

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=;queryHeaders=Authorization%2Bearer $(vToken) %1X-OAPI-Application-Id%2froM0YE2RajLD50Z;PaginationType=None
;

Re: QvRestconnector

viliam_vacula — Mon, 14 Nov 2022 16:00:00 GMT

Please post the full code you currently have (without any confidential stuff, IDs etc.) and maybe somebody will be able to spot a mistake and fix it.

Re: QvRestconnector

Chip_Matejowsky — Mon, 14 Nov 2022 20:44:02 GMT

Hi @John4,

Have you checked if there's a data limit on the API side? I don't believe there is one on the Qlik REST connector side.

Best Regards

Re: QvRestconnector

viliam_vacula — Tue, 15 Nov 2022 03:05:30 GMT

Hello,

the API is fine. The limitation that it sends us only 400 rows of data is known and cannot be removed.

We can get a value for the total number of records in the dataset. We just don’t know how exactly to write the loop which makes the GET calls over and over with an increasing offset until the entire dataset is received. We try with a FOR loop, we know how to increase the offset every time to get the next 400 records and we know how to calculate the number of loops.

We just don’t know the proper syntax to write the actual loop that would keep making the GET calls and appending the results into a table until the whole dataset is received.

Re: QvRestconnector

Bill_Britt — Tue, 22 Nov 2022 12:33:19 GMT

Hi,

When you are selecting the data, can you try to set the Preload symbols count to "No limit"

Re: QvRestconnector

Bill_Britt — Tue, 06 Dec 2022 12:52:10 GMT

Hi,

I have just checked with R&D and there is not limit. Where did you get your information from?

Bill