Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The Dutch statisticual bureau has a lot of data available and it's available as open data. When requesting data they have put a limit of 10.000 records in 1 request. I'm trying to figure out the pagination settings for the REST connector, but haven't managed to get it working.
I can request the data in xml or json format. For example request of the first 10.000 records for a the subject I'm looking at:
for xml: https://opendata.cbs.nl/ODataFeed/odata/83765NED/TypedDataSet
for json: https://opendata.cbs.nl/ODataFeed/odata/83765NED/TypedDataSet?$format=json
At the bottom of both responses I can find a new url directing me to the same url, but including "&$skip=10000".
So I guess I need to use the NextUrl pagination type. But I can not get it to work.
Hoping to find the solution here (or at least some helpfull pointers).
I am struggling with the same problem. How do I implement the top and skip logic from Odata with the Qlik sense REST connector?
It's a critical feature.
Alex