Multiple REST calls from a data connection

slong — Fri, 10 Dec 2021 20:23:41 GMT

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

Re: Multiple REST calls from a data connection

AlfonsS — Thu, 01 Jul 2021 12:06:48 GMT

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.

topic Re: Multiple REST calls from a data connection in Connectivity & Data Prep

Multiple REST calls from a data connection

Re: Multiple REST calls from a data connection