Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
slong
Contributor II
Contributor II

Multiple REST calls from a data connection

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

1 Reply
AlfonsS
Contributor
Contributor

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.