If you select Pagination of Offset which is what your REST source demands, the connector also needs information about where to find the total number of rows to fetch. That information can be returned either in the Response Header or in the data itself. That varies with various sources and the way they have chosen to implement their RESTful API.
You need to fill out both the Query Parameter with the Offset and also specify it in the section for Pagination.
So it should look something like this:
Maybe the "Total field path" needs to be adjusted ... but I think it should be right...
thanks for your help. I have tried your solution, but I still only get the first 1000 posts.
I will see if I can get hold of the developer of the API and ask that person what is missing. Maybe there is something with the API that does not support the call.
I will let you know what I come up with.
Kind regards, Jonathan
Looking closer at your JSON result data from Chrome I can see that you actually get the necessary information that the Qlik REST Connector needs to know the total number of rows to get. But you don't retrieve this information as part of the SQL SELECT statement. Then there is no way for the REST-connector to know how it will reach the end of data and it will refuse to iterate. Unfortunately it does not send any warning or error message to that effect.
You should retrieve on table with your real data and one table which contains queryTotal and pageSize. Then you will be able to in the REST Connector dialog box to enter the queryTotal. But just entering it in the dialog box without retrieving the data and not specifying the right path to the data will not make it work.
It is a bit hard to give you exact specification on exactly what to enter where when I don't see the screenshots and preview that you are getting when you do your connect. Is it possible for you to share that with us?