Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pablomind
Creator
Creator

How to pull the whole table of Worklog using the Qlik JIRA Connector (Qlik Web Connectors)?

Hello,

I've successfully pulled the Issue and Projects Table using the Qlik JIRA Connector but when im trying to get the Worklog table it only does for an specific issue but i want all the worklogs of all issues at once. Is this even possible with this connector?

Thank you in advance,

Pablo

1 Solution

Accepted Solutions
chrisbrain
Specialist II
Specialist II

I think you would have to create a for/next loop in your Qlik script which loops through every issue ID and runs the Worklog table once for each.

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense

View solution in original post

7 Replies
chrisbrain
Specialist II
Specialist II

I think you would have to create a for/next loop in your Qlik script which loops through every issue ID and runs the Worklog table once for each.

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
pablomind
Creator
Creator
Author

Thank you very much this solution worked perfectly!

chrisbrain
Specialist II
Specialist II

Great!

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
juraj_misina
Luminary Alumni
Luminary Alumni

Hello Chris,

maybe a bit off topic, but is there any guesstimate if/when will the Jira connector come out from Beta? Thanks.

Juraj

victorbertoldozg
Contributor
Contributor

Coud you post an exemple of your script with a for condition?

Thank

Victor

ajayvermaida
Partner - Creator
Partner - Creator

how to get the full table of sprint with Jira web connector or rest API ?

gvalenti
Partner - Contributor
Partner - Contributor

Hi, this solution works fine. The problem is the number of calls from Qlik to Jira. For example, 50 projects, with 100 issues, generate 5000 calls from qlik sense to the JIRA server and the result is 5000 logins which burden the JIRA server. Is there a solution that does not involve such a large number of calls to the server?