JIRA Connector (Macro)
Public Gallery Link: https://gallery.alteryx.com/#!app/JIRA-Connector/58d87c2feffc2a0dd0b5ed8f
I've published a JIRA Connector to the public gallery and hope it will be useful for those using JIRA that are looking for a way to quickly download issues for their JIRA projects. It's pretty straightforward, but here's a preview and quick guide:
30 Second Preview:
Installation & Configuration
Download and import to your Macros folder
As long as your macro folder has been mapped (Options -> User Settings -> Edit User Settings -> Macros), you should find the JIRA Connector tool in the Connectors category on the tool palette the next time you open Alteryx.
3 Tabs: Site & Login, Project & Issues, Fields
Site & Login
Enter the URL for your JIRA site along with your username and password. Email logins will work, but your actual username is preferable because it enables the "Only My Issues" option to work (next tab).
Project & Issues
You'll need to run the workflow at least once with the "Refresh Project List" option selected before being able to use the "Download Issues" option. This loads a list of available JIRA projects that will show in the dropdown under the Download Issues option on subsequent runs.
Once an available project list has loaded, you can select a project to download issues from. You'll also notice some options for filtering issues that belong to yourself or another specific assignee. You can also paginate through large result sets in 1,000 record increments.
Lastly, select one of three options for returned fields and parsing methods.
- Standard - Formatted
- Includes the commonly used JIRA system fields and utilizes more practical parsing and formatting methods
- Standard - Raw
- Includes all JIRA system fields and transposes/flattens multi-dimensional arrays (to a certain extent/depth)
- Can yield wide results
- The Kitchen Sink
- Includes all system fields, as well as custom fields
- Parsed results for this option will likely be very wide and cumbersome
Summary (S) - a brief summary of the results (record counts, etc.)
Raw JSON (J) - direct JSON response from the JIRA REST API
Parsed Results (P) - the parsed results
That's it! Once again, I hope this will be useful and look forward to getting some decent feedback. I've only been able to test this on our company's [cloud hosted] JIRA projects and honestly have no idea if it will work for private server hosted JIRA environments.
Please feel free to leave feedback and/or report any runtime errors below. I'll do my best to publish new versions to the gallery with essential fixes.