Loop a process until condition is met

Hello,

Been spending the last couple days trying to get this to work with an iterative macro but can't quite get it work with an API call.

I figured I would try to post an example workflow. It's a bit difficult to describe without having the API call in place so I put sample results in an input tool at the end of each container.

Representing the process in containers, the first container would be the initial run and the second container would theoretically be the second run and would complete the process because the API call returned a status of "Complete".

I would like this API call to repeat until I get a status of Complete. Any suggestions would be great.

Repeat process.yxmd

Macros

API

Accepted answers

CoG

It does sound like an iterative macro is exactly what you'd need. Did yours look something like this:

Sample Workflow.yxmc

All comments

CoG

It does sound like an iterative macro is exactly what you'd need. Did yours look something like this:

Sample Workflow.yxmc

Analyst323

Thanks, I think I made some significant progress. I brought in the macro and connected it to the main workflow. Any idea what this error could mean? The schema shouldn't be changing every iteration...it's just doing repeated API calls.

Edit** Fixed it with a summarize tool to lock in the headers. I think every iteration was duplicating the headers causing it to post that error.
Edit2** Summarize tool actually stopped making it work all together.

This is what i'm seeing on the Complete output and the iteration output. It looks like it's duplicate headers on the iterations

But I don't think the iteration is repeating until status is complete. I'll try to test a few more. Attaching the macro.

Looks like someone else encountered this issue but I don't see a solution posted. When I do autoconfigure by name, the macro doesn't post any data which I'm guessing is due to the filter we have in place.
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Macro-issues-with-quot-Field-schema-changed-between-iterations/m-p/570818#M125394%3Futm_content=en&utm_source=designer_2022.1.1.30961_trial-False&utm_medium=global_search

Analyst323

I think I got it to work! I just put a summarize tool before the download tool so that the headers would remain the same on the iteration.

Thank you for your help!

Capture4.JPG

CoG

Great job problem solving! I'm glad you were able to achieve a solution.

You are very welcome.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703