ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Dev Space

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

JIRA Connector

5 - Atom

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

7 - Meteor

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):!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.



7 - 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


7 - Meteor

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.

7 - 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


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

Let me know if this works for you.

5 - Atom


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.



7 - Meteor

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.

5 - 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.




8 - Asteroid

Thank you @MPolin That worked.