Looping an API Call to Jira

[KQPham]

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

[apathetichell]

extract the total (ie  "total": 200, )

divide the total by 50.

generate rows for that number.

starting at 50*([recordid]-1) - create "startAt" values.

create your api calls.

send your api calls.

[caltang]

Just curious, I think there are some Jira macros here on Alteryx. Why not use those - or are they clunky/not well maintained?

[apathetichell]

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

[KQPham]

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

[_Angus_Birnie]

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