Looping an API Call to Jira

Question

Howdy All!

I'm attempting to build a workflow out that will call to Jira's JQL REST resource, however I'm having problems breaking this down correctly. I'm going to try and best describe the parameters as possible.

Scenario:

- Will have about 2000-3000 results by the end.

- Can only query 50 values at a time.

- Need to update the "startAt" parameter in increments of 50 it will start at 0 (Especially struggling here I can't think of a way to have it auto update after all is done)

- I want it ideally to append to a list each "successfulRun".

Best,

-K

Snip.PNG

_Angus_Birnie · Answer

can you set up an iterative macro and have the "startAt" value be part of the iterate output on the macro?

KQPham · Answer

It's just something I want to functionally learn how to do with Alteryx.

I have attempted to use the Macro a few times, but I wasn't sure if this was a permission's or access problem.

It's not that they're clunky, but I feel like optimizations for my use case could be a better solution.

I'm trying to combine a few of our Project Management tools and it would be easier to troubleshoot if the workflow layouts if they were similar.

[Workflow that Calls API with new self iterating "startAt" parameter each "successfulRun"]

apathetichell · Answer

@caltang only one I see in the marketplace is the free one by capitalize consulting. I'm too lazy to set up my new unlinked to my profile or my license marketplace identity to see if it's a locked macro or not. At its core - I'd posit a JIRA api should be pretty straight forward but apparrently people really like to think they need iterative macros for things.