Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've set up a REST connection to Jira using the REST Data Connector in Qlik Sense. The maximum amount of results a single REST call in this case can return is 100. I have more than 100 records which I want to load into Qlik Sense.
Is it possible to make two REST endpoint calls in the same data connector load script ?
From looking at the generated script there's no actual REST url in there and there seems to be a conversion to something which looks like nested SQL ?
My two calls would look something like this with the only difference being the startAt and maxResults parameter values at the end.
https://my-company-portal.atlassian.net/rest/api/3/search/?jql=[MY_JQL_QUERY]&startAt=0&maxResults=100
https://my-company-portal.atlassian.net/rest/api/3/search/?jql=[MY_JQL_QUERY]&startAt=101&maxResults=100
This might be a very late response, but for anyone stumbling upon this, look into Pagination.
More specifically for Jira, use Offset pagination, startAt as your starting parameter and maxResults as your count parameter.
This will alow you to call that API multiple times until all results have been sent.