Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

How to create a web request using Jira automation to retrieve data from filters

Sidharth verma May 16, 2024

I want to create a webhook request using Jira automation to get data from a filter and count the number of rows from that filter. If i do this using Normal JQL it is only giving me 100 records since that is a limit set by Jira. 

Can someone help me in getting the same data using webhook request ? 

2 answers

1 vote
Joseph Chung Yin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 16, 2024

@Sidharth verma -

To supplement what @Kalyan Sattaluri suggested, as of right now the 1000 issue limitation is controlled at the system level and cannot be changed.  Here is an existing enhancement request where you can add yourself as a watcher -

https://confluence.atlassian.com/jirakb/how-to-see-total-count-of-issues-when-using-jql-and-the-result-is-greater-than-1000-1319567658.html

Here is a reference KB link on how to get # of count from a JQL - https://confluence.atlassian.com/jirakb/how-to-see-total-count-of-issues-when-using-jql-and-the-result-is-greater-than-1000-1319567658.html

Lastly, here is the reference on Automation rule's limitation - note that the JQL search issue count is limited to 1000 issues too - https://support.atlassian.com/cloud-automation/docs/automation-service-limits/

My best recommendation for you is to refine and optimize your JQL, so you are not pulling so many issues back.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

 

 

1 vote
Kalyan Sattaluri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 16, 2024

Hello @Sidharth verma 

Search end point documentation is here - LINK

At a igh level, your end point will be like:

https://yourdomain.net/rest/api/3/search?jql=filter=12345

replace bolded part with your domain & filterID (or name)

You could specify maxResults as optional query parameter, but depending on how your Jira is configured, you can only get a predefined max number.. maybe its 1000, I dont know..

https://yourdomain.net/rest/api/3/search?jql=filter=12345&maxResults=1000

If there are more than 1000 records (or the limit set by your admin), you need to implement pagination logic, which you cannot do in automation but outside using Python or some other scripting language.

Typically people get around it by creating filters which are within their max threshold.

Finally, if all you want to know if how many records there in the filter, the end point payload gives you that info right away under the "total" section like below.

image.png

But yeah, please review docs for more info. Hope it helps!

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events