Macro question - workflow needs to rerun based on condition

Hello Alteryx community,

I could use some best practice tips on how to best solve this workflow based on what I need. I have a workflow that downloads events from an api, but it only returns up to 499 events. So in case 499 events are returned the workflow needs to run again completely. If there are between 0 to 498 events the workflow does not need to run again.

The amount of events is calculated with the summarize tool at the moment.

Is it possible with this design or do I need to do a complete overhaul to use macro's?

Macros

Accepted answers

estherb47

Hi @Pingu

When you want to loop through a workflow based on a condition, you'll want to use an Iterative macro.
There's a great e-Learning here: https://community.alteryx.com/t5/Interactive-Lessons/Creating-an-Iterative-Macro/ta-p/657925

Just be sure that you have a way to update the API call so that it returns the next set of results, before you make the call in the download tool.

Let me know if that helps.

Cheers!

Esther

All comments

estherb47

Esther

MarqueeCrew

@Pingu ,

if on call #1 you know how many calls you need, instead of wrapping this up in a macro I would use a GENERATE ROWS tool to create the URL strings necessary and feed them into another DOWNLOAD tool. Example would be to modify the page# o each record or change a query parameter.

cheers,

mark

Pingu

Thank you for your answers MarqueeCrew and EstherB47

The amount of calls is not known beforehand unfortunately.

The download tool does not need to be updated. The call returns all 'unseen events' but only up to 499 at a time. So the next time it is called it will return the next 499 until there are no more left so the last call is always between 0 and 499. So if it is called very often it is always <499. But I do not think work will appreciate if i abuse our Alteryx Server for hourly runs . Also depending on the time of day then there will be a lot of runs wit 0 events.

Thank you and I will look into the Iterative Macro learning.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703