community
cancel
Showing results for 
Search instead for 
Did you mean: 

Dev Space

Customize & extend the power of Alteryx. SDKs, APIs, custom tools, and more!
SOLVED

JIRA Connector

I love this connector as well - but unfortunately we've been able to use this in our organisation becasue we use Kerberos authentication with our JIRA instance.

 

We've tested it without the Kerberos authentication and it works, so we've narrowed down the problem, is there anyway to have this connector work with a JIRA instance sitting behind Kerberos authentication?

Atom

Excellent tool... Thanks for sharing this with us

Bolide

@jimmyly89,

 

Currently the connector is using basic authentication - requests to the api simply send an Authetication header with the encrypted credentials.  My guess (and this is a guess) is that Kerberos authentication might require using JIRA's REST API OAuth Authentication Method, which is substantially more involved and also requires the configuration of Application Links within your JIRA admin, as well.

 

Having said that, I am currently working on the development of new JIRA connectors (one for input, another for output), using the new HTML/JavaScript SDK, and will be doing my best to include 2 authentication methods: a "Basic" and "Developer" login option, where the "Developer" option will use the OAuth methods, assuming you have configured the application links properly (visit link above for documention and/or more info on this).  I can't make any promises for the OAuth method at this point simply because I haven't been able to test it yet and honestly have no idea what obstacles I may encounter.  Again, I will do my best to make it happen and hopefully it will remediate the Kerberos login issue.

 

p.s. - Now would be a great time to suggest any pertinent, burning, suggestions for improvements and/or additional cpabilities within the connector :-)

 

Taylor

I'm loving the connector - thank you for taking the time to put this together. It's been extremely helpful so far. I agree with above statements that being able to enter a data range would be a nice to have. Another hope is to be able to address the 50 record limit that Jira has imposed by building pagination into the connector. I'm struggling to be able to pull a history of all the tickets we have in a given project, and yes I've used some of the suggestions mentioned in this thread (I'm still a bit of a newbie)

Bolide

@Saltygunner thanks for the feedback and I'm glad to hear that you've found it to be useful.  Pagination, and/or the ability to "chain" the calls behind the scenes until all, or a much higher limit, of the issues are retreived is probably the #1 suggestion at this point for the new connector.  I'll make sure it's feature #1 on the changelog :-)

Atom

Is there a ways to get CSV file Attachment file from issue in jira to Alteryx.  

Bolide

@prerna - while I wouldn't dare try to download the attachments as part of the connector (for hopefully obvious reasons), I'll look in to including attachment locations/endpoints as a field in the output.  You could then either get them manually or do some subsequent magic with the download tool

Atom

I have a csv file in my jira issue as a attachment, which I want in Alteryx for data filtering. So, is there a way Alteryx and get those file from jira to Alteryx. Not manually


Bolide

@prerna - again, you'll have to get the attachment info for said issue and then use the download tool's GET/FTP method to grab those attachments.  This is not something that I'd ever have any interest in building in to a connector but would rather give the user the necessary ammunition to put "Self-Service" analytics to use.

 

Either some manual work wil be required OR I think that you'll find this to be a bit cumbersome for many reasons...

 

For starters, keep in mind....

1) attachments will likely be of different types (excel, word/text, pdf, images, etc...)

2) you don't know sheet names (for excel files) and can't assume they're all the same
3) in order to try any automation, the aforementioned attachments would require some pretty reliable consistency and/or your JIRA issues would need to be precisely filtered to only those with that static criteria before trying to download attachments, much less do anything with them thereafter
4) lastly, if you do get to that point, I'd encourage you make sure you're doing some "clean-up" along the way so that you don't just continue downloading and saving oodles of copies of attachments...your server admins will thank you, as well, if you're scheduling this or running in a gallery

 

I have attached an example that should get you started.  It currently downloads and saves the attachments for a task to the [Engine.TempFilePath] directory with a file name of [jira-issue-key] + [attachment-name].  It will require some tweaking to run and you'll need to understand how Basic Authentication works with the JIRA API.  Edit the text input with your applicable parameters using a sample jira task.  When you have it working, you can replace the text input with your results from the JIRA connector and move the username, password, and url parameters to the formula tool.  Lastly, you can save the attachments wherever you want...but again, be cognizant of the fact that you could fill up some disk space in a hurry if you're pulling large attachments or pulling them from hundreds/thousands of jira tasks. 

Atom

First off, thank you for creating the JIRA connector! It's a fantastic tool :)

 

Today, the connector allows us to read data. Will you be making an enhancement to write to JIRA? I'm trying to automate our ticket process and would love to create JIRA stories dynamically (via the tool) when certain conditions are met? For example, if a data review fails, we need to a create a JIRA story with any necessary details to have our technical team investigate further. Thanks!