I’m trying to figure out how to do a bunch of different tasks in JIRA using a command line tool. Here’s what I want to do:
I’ve got an Excel sheet with info about 50 issues that need to be linked to 50 other issues. Each row has the issue number, link type, and the target issue number.
Is there a way to make a command line tool that can read this data and automatically create all these links in JIRA? We don’t have the JIRA Command Line Interface plugin installed, so I’m not sure how to approach this.
Has anyone done something like this before? Any tips or advice would be super helpful. Thanks!
I’ve tackled a similar challenge before, and I can share what worked for me. Instead of relying on the JIRA CLI plugin, you can leverage JIRA’s REST API to accomplish this task. Here’s a high-level approach:
Create a Python script that reads your Excel sheet.
Use a library like ‘requests’ to interact with JIRA’s API.
Authenticate using your JIRA credentials.
Iterate through your data, making API calls to create the links.
The beauty of this method is its flexibility. You can easily extend it to handle other bulk operations in the future. Just make sure you have the necessary API permissions in JIRA.
If you’re not comfortable with Python, you could also consider using tools like Postman for API interaction or even a low-code platform like Zapier for simpler workflows. The key is finding the right balance between functionality and ease of implementation for your specific needs.
I’ve been down this road before and it’s totally doable without the JIRA CLI plugin. I used Python with the jira library, which proved a real game-changer for automating tasks. First, install the library with pip install jira and write a script that reads your Excel file using pandas. Then, use the JIRA API to create the links by connecting to JIRA, processing the Excel data, and iterating over each row to create the desired link. Batching requests can speed up the process, especially when dealing with multiple issues. Don’t forget to verify you have the appropriate permissions in JIRA before you start. If issues arise, feel free to ask for further advice. Good luck!
hey mate, i’ve done smth similar b4. try python w/ jira’s api—read excel w/ pandas, use requests, loop thru data to link issues. no fancy plugins needed, just ensure api access. lmk if u need help!