I managed to solve this problem using Qlik General Web Connector
In http://localhost:5555/web/connector/WebConnector choose General Web Connector and then use JQL to get what you want, you will have to fill in the pass and user name and the arguments for the URL. Then choose JSONToXMLRaw ot JSONToTable.
You will need to set legacy mode to true in Sense ini file for this to work.
Thanks youness for your post, it really help to correctly undestand how to configure the pagination.
I have a little problem, when I save or test the connection, it request to fill stringToEscape parameter, or I do not see any field mentionning this parameter in the "Edit Connection" dialog.
Have you encountered the same problem before?