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!
Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.

JIRA Connector

Atom

Using the connector, aside from an elaborate union, is there a way to select more than one project at a time??

Meteoroid

Taylor - thanks for setting this up initially.


I have stolen most of your work, and modified it to pull max records - 100 at a time (this was based on our local administration).

 

Published here (also tried to attach it):

https://gallery.alteryx.com/#!app/Jira-Iterative-Macro-Connector/5cf81b8a0462d712c8e75001

 

I had a need to pull this data regularly and refresh an MDI board based on the Jira data (for tableau).


Can write this out to just about any format.

 

 

Highlighted
Meteor

HI there, My Jira Connector starting failing a couple weeks with the below error. Does anyone have any suggestions? In the tool my logon information discovers the project however if fails to make the api call.

 

Error: JIRA Connector (1): Tool #227: JIRA API error --> HTTP/1.1 403
X-AREQUESTID: 856x43111256x7
X-ANODEID: s4708cdc
X-XSS-Protection: 1; mode=block
X-Content-Type-Options: nosniff
X-Frame-Options: SAMEORIGIN
Content-Security-Policy: frame-ancestors 'self'
X-ASEN: SEN-11755321
Set-Cookie: JSESSIONID=1B4B875C7826564C70E100E42ADF5432; Path=/; Secure; HttpOnly
X-Seraph-LoginReason: AUTHENTICATION_DENIED

......

Meteoroid

you may need access in jira to actually view the underlying data.  might be a local permission issue, otherwise I would try getting a fresh API token.

Meteor

JIRA Has recently removed the authentication based on username:password.
You need to generate an API key using user email instead of username

and API Token instead of password.
here is the link

https://developer.atlassian.com/cloud/jira/platform/jira-rest-api-basic-authentication/

 

This worked for me however, error message I was seeing was `Authentication Failed`

Let me know if this works for you.

@Coxta45

Is there anyway to return the results from a Filter Query on the Jira Project?  This would a) allow us to only pull back particular records and b) allow the filter columns to be used in the data that is returned.

 

Thanks

Meteoroid

I am not sure on this, but you might have better luck asking the Jira community on that one.

 

Anything that is available through their api you can technically use in these macros. You just have to edit the macro to set up the query the way you want it, which might be exponentially easier said than done.

 

For me, I created some calculated fields in my alteryx workflow that basically conducted the filtering for me, this was easier, and guarantees to provide a clean set of data to tableau.

Atom

If we are using boards with Epics, it there a field that links stories to the epics they are under. I tried to search through the columns for it, but I may have overlooked it.

 

Thanks,

D'Ante