Get only Open issues from JIRA

svani
Tera Contributor

HI everyone,

 

Is anyone implemented to get only Open issues(not closed,deployed)issues from JIRA to servicenow.

We have the API to get all issues from the JIRA but we can see there more than 10k issues so we need to limit them so is there any way to filter and write the query.

i have written the below query but no luck.

Please let me know if someone has any idea on it.

rest/api/2/search?jql=project=SNOW&status=In Progress

 

Thanks in advance 

4 REPLIES 4

Abbas_5
Tera Sage
Tera Sage

Hi @svani,

Please refer to the below link:
https://www.servicenow.com/community/now-platform-articles/get-list-of-issues-from-jira-using-rest-a...

 

If it is helpful, please mark it as helpful and accept the correct solution.

Thanks & Regards,

Abbas Shaik

svani
Tera Contributor

Hi @Abbas_5 ,

 

I have referred that and also i can able to get all issues wrt to project but the only thing is how to get specific status issues(can be able to get in progress also) but the issue is if i wanna get inprogress,todo, like other types we do not have specific API i did not get anything from Jira docs too.If you have any idea please help me here.

 

thanks in advance

Josh Gold
Tera Expert

@svani can your team consider third-party tools as an alternative? You can set up a Jira ServiceNow integration with Unito to only sync open issues. It's a no-code flow builder and ServiceNow partner that supports all fields in Jira, including custom fields. It can turn issues into ServiceNow records of any kind as long as your ServiceNow account has access to the record type you're working with. Let me know if you want more information. Good luck!

Mathieu Lepoutr
Mega Guru

Dear @svani 

 

If you’re looking to sync only open issues from Jira to ServiceNow without dealing with large payloads, you might consider Exalate. It allows you to define precise filtering criteria, like syncing only issues with specific statuses, and handles large datasets efficiently.

 

This could simplify your integration and reduce the need for manual API query adjustments.

 

Thank you.

Kind regards,
Mathieu Lepoutre