Can I structure a JIRA API GET request similar to a JQL query

Question

Hi Folks,

I'm a self-confessed newbie when it comes to using the JIRA API (API's in general) and I need to figure out the feasibility of something pretty quickly.

I've looked at the API documentation and can see a lot about creating issues, updating issues etc. using the API, but what I'm really interested in is being able to create a GET request that can return data to a JSON file like I can with a JQL query when searching for issues.

As I said, I'm new to using API's so be gentle with me, but figured I'd ask here as it would be the best place given its specific forum.

Any constructive guidance will be appreciated.

Huw

David Leal_28ge8x · Answer

@HuwM OK If you need any help let me know. Please keep in mind that JIRA has a limitation of 100 records per query, so you need to implement a pagination strategy. Vote to this JRACLOUD-67722 open request if you want to have this number to be increased.

HuwM · Answer

Hi @David Leal thanks for the quick response,

The target tool is Tableau.

I too am currently exporting to excel, but it still requires the manual step of updating the Excel workbook with the Data from JIRA.

Thanks for the link, I'll check it out.

Huw

David Leal_28ge8x · Answer

@HuwM I am also newbie with JIRA REST API. I am exporting the issues from JIRA into Excel file, what is your destination tool? Excel Jira REST API end to end Example was for me a good starting point to try to understand how to get the information and parse it in VBA. It is an old post from 2016, but it gives you a good overall for VBA.