I tried to use custom pagination and create logic in load script to create different pages to load:
The vMyUrl is well structured because I copied it values from the trace and test it in navigator.
But still QLik give me the same results, I think it send request ignoring the startAt and maxResults... Even by forcing the parameters startAt=100 and maxResults=10, it load first 50 records and starting from position 0.
Do you how to debug the message sent from Qlik Sense? Wireshark would work ?
Thanks for your help.
A helpful page: https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/1.0/Create-REST-connection/Loading-paged-data.htm?_ga=2.61476396.1843087527.1516959992-1961611840.1507728064
I have found root cause of the problem but not yet the solution.
The URL I am giving to contain a JQL request in which I have a jira custom field. The custom field name is composed of 2 words "Feature Team".
Usually the JQL can be like : projet=ANO and "Feature Team"=TEAM1&startAt=0&maxResults=100.
This JQL work correcly in navigator or any other rest reader program.
In qlik sense it ignores all what I wave after the double quotes (").
I have tested my second comment script without "Feature Team" and it working great.
So the problem now, do you know how can I ignore double quotes in variables in load script?
Thanks for your help.
One other thing, in the for loop you need to use $ expansion for total i.e. $(total), also use the Next statement at the end of the loop to continue on.
Great work though Haidar, this was a really helpful article, so good to read something that's straight forward, all on the one thread and not loaded with comments from other users giving multiple links to other articles
Hi Haj Ali
Did you ever get this working correctly? I'm trying to do the same but my results are limited to the first 50 records no what what I try.
It doesn't look like my API call works when I use the startAt and MaxResults values. I thought it may have been down to my use of the " character or the user of the '-' in the issuetype name in the search criteria of the query:
I haven't tried the custom pagination yet, I just want to check if my query is right first before I try again.
Any help is appreciated.