QvRestconnector

[John4]

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
;

[viliam_vacula]

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.

[Chip_Matejowsky · Accepted solution]

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

[viliam_vacula]

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.

[Bill_Britt]

Hi,

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

[Bill_Britt · Accepted solution]

Hi,

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

Bill