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

Question

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 ?

Joseph Chung Yin · Answer

@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.

Kalyan Sattaluri_iinm1n · Answer

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.

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