get jira data via rest api into excel
Budget: €50 – €250 EUR
I want to have excelsheets which will be filled with data from Jira.
The starting point should be an searchfield (Searchfield can be used in Excel directly or can also be an external python tool). In the searchfield the user should type a "Version". The version is an attribute which will be used in nearly all the jira tickets.
The excel sheet should load all the ticketinformation from type "Epic" and the version. The received data should then populate some columns.
Check the attached excel sheet.
I have created a demo Jira project, which we can take for testing purposes. But the excel sheet should be connected later with our production Jira project.
Ideally Python 3 should be used.
If this task is finished further tasks will be created. I need to filter some tickets via jql query later (if jql is not possible, then another solution). The result will be again some tickets.
The starting point should be an searchfield (Searchfield can be used in Excel directly or can also be an external python tool). In the searchfield the user should type a "Version". The version is an attribute which will be used in nearly all the jira tickets.
The excel sheet should load all the ticketinformation from type "Epic" and the version. The received data should then populate some columns.
Check the attached excel sheet.
I have created a demo Jira project, which we can take for testing purposes. But the excel sheet should be connected later with our production Jira project.
Ideally Python 3 should be used.
If this task is finished further tasks will be created. I need to filter some tickets via jql query later (if jql is not possible, then another solution). The result will be again some tickets.