Jira Iterative Macro Connector
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Printer Friendly Page
- Mark as New
- Subscribe to RSS Feed
- Permalink
Hello All,
Public Gallery Link: https://gallery.alteryx.com/#!app/Jira-Iterative-Macro-Connector/5cf81b8a0462d712c8e75001
After a few requests, I have finally decided to post some information on the Jira Iterative Macro Connector. Hopefully this short document helps to clarify.
Special Note and Thank you: This work was an "add-on" from @Coxta45 original "Jira Connector" and is an improvement (to me) based on some needs and limitations of a single API call.
Please refer here for detailed documentation to the Original Jira Connector:
https://community.alteryx.com/t5/Dev-Space/JIRA-Connector/td-p/51562
What is different from the original Jira Connector and the Jira Iterative Macro Connector?
Jira Connector | Jira Iterative Macro Connector |
Single API Call | Multiple (Iteartive) API Calling |
Subject to server data limits | Will iterate beyond Server limits |
Macro Dialogue Interface | Text Based Interface (file) |
Why the need for Iterations?
We use Jira for Digital Manage for Daily Improvement (MDI) boards and Scrum boards, and the limitations of Canned Dashboards and complexity of EasyBI called for a need to extract all the data on a board and pull it into Tableau.
Due to Jira server limitations from local site admins, I was only able to pull 100 records from a given Jira Project at a time. Having Jira projects that contained thousands of records, I had a need to iterate beyond the server limitations. The iterations verify max records and iterate on a single API call until the max records for a project are received.
What input do I need to use the Macro?
The table below (also attached) outlines the following:
- First Row depicts the header row
- Second Row depicts the actual information you need to supply
- Third Row depicts an explanation of the information you need to supply
for | Query | issues | max | start_with | user | Iterator | fields | project | api | pass | Site Base |
all | {"jql":"project = 16301","startAt":0,"maxResults":1000,"fields":[],"expand":["names"]} | all | 100 | 0 | example@domain.com | 0 | all | <projectID> | /rest/api/latest/search?jql&startAt&maxResults&validateQuery&fields&expand | <API TOKEN> | https://example.jira.com |
(all issues, all issues assigned to me, etc. - just do all) | (you can change this to reflect the other base parameters in the input file. its just a base input set for the extraction, it will update as you iterate) | (all issues, improvements, bugs, etc. - probably do all and filter later) | (max number of results, will overwrite maxResults) | (starting position, start at 0 to pull everything. Large numbers pull less data) | (use your email, or rather the email that has an API token tied to it) | (leave at 0, I think this is unused now with some changes but I don’t want to touch this) | (same as before, probably leave at all unless you want a truncated data set) | ( id of desired project as is in data, e.g. 16301 which will be referenced in the JQL query) | (this is the desired api the whole thing is built around) | (must be a Jira Admin and generate this from your Jira site) | (your jira domain) |
Initial Workflow Setup
Please refer to the screenshot and steps below to help with initial workflow setup when using the Iterative macro.
- Step 1 - update the file in this post with the appropriate information or add a manual text based input containing the information
- Step 2 - hook up a browse to the iterative side
- This is mostly unused if setup correctly, but is required for iterative macros
- Can be useful if you need to debug the iterative side of the macro as it will show you outputs of the iterations which feed into the inputs of the next iteration
- Step 3 - the output data stream which you can build any data transformations as you see fit
- I personally did some data cleanup here as I intentionally export the kitchen sink and then trim it down later
- Labels:
- API
- API Output Tool
- Custom Tools
- Developer
- Gallery
- Macro
- Mark as New
- Subscribe to RSS Feed
- Permalink
I seem to keep running into a Tool #11 error, but I've tried adding field names into the JQL query string and I keep hitting the same wall. Granted, this is probably just my ignorance since I'm just fumbling along trying to make this work, but in the query string, I am assuming that the field names do indeed to within the provided brackets? However, is there anything special about the "expand":["names"] I should be addressing?
- Mark as New
- Subscribe to RSS Feed
- Permalink
There is to many errors with this one, does anybody have the original connector ? That one worked great
- Mark as New
- Subscribe to RSS Feed
- Permalink
Can somebody provide the original connector as mentioned above by @Carlos_Tovar?
- Mark as New
- Subscribe to RSS Feed
- Permalink
Hello, I filled in the fields like the template said to, and I got this error, does anyone know how to fix this?
Thanks!
- Mark as New
- Subscribe to RSS Feed
- Permalink
@SDB40 whenever I try to connect to the macro I am getting the following error message:
Any suggestions as to what I'm doing wrong?
- Mark as New
- Subscribe to RSS Feed
- Permalink
Hello @gomi, I am not certain. Looks like the authentication failed. Did you follow the instructions and obtain an API token associated with an administrator and input those credentials into the text file consumed by the workflow?

- « Previous
- Next »