topic Re: Exit ForEach loop with condition (like in a WHILE statement) in Workato Pros Discussion Board

Exit ForEach loop with condition (like in a WHILE statement)

filipe-oliveira — Tue, 15 Mar 2022 04:17:41 GMT

Hello Workato Community,

Is there a way to exit a ForEach loop given a specifc condition (like in a WHILE statement)?

I'm just looking for an ID in a list and I want to stop the ForEach once the ID is found.

I added an IF condition inside the ForEach but, as per my understanding, this would just prevent the following steps inside the ForEach from being executed, but the ForEach would still need to iterate through the whole list.

Thank you,

Filipe

Re: Exit ForEach loop with condition (like in a WHILE statement)

vinny-sosa — Tue, 15 Mar 2022 04:32:57 GMT

This is the only way that I am aware of the do it. I know it seems like a waste of cycles but the iteration happens pretty quickly. This feature is much much needed and long overdue.

Re: Exit ForEach loop with condition (like in a WHILE statement)

ajorde — Tue, 15 Mar 2022 04:41:51 GMT

You could call a function to iterate on the loop and then return response/stop job from the function when it meets the criteria. You would still need a list to iterate through in the function.

Re: Exit ForEach loop with condition (like in a WHILE statement)

mike-flynn1 — Tue, 15 Mar 2022 05:01:54 GMT

sometimes the .where function can help prevent unnecessary loops.

I also echo Vinny, as an engineer I hate wasting electrons but a simple if statement also gets the job done. I have tried many different ways of breaking a loop in Workato and it didn't work out well - so now I just keep it simple.

Re: Exit ForEach loop with condition (like in a WHILE statement)

rachelnatik — Tue, 15 Mar 2022 09:23:15 GMT

Vinny and I just discussed this recently. You can submit product feedback on this.

Re: Exit ForEach loop with condition (like in a WHILE statement)

david-macintosh — Tue, 15 Mar 2022 21:00:03 GMT

You should looking into droppong your list into a collection then execute SQL against the collection to get your desired entry / entries. I have found this extremely useful for limiting iteration as well as nested looping, greatly reducing the complexity and size (number of actions) required for various recipes.

Re: Exit ForEach loop with condition (like in a WHILE statement)

omri-benmoshe — Tue, 15 Mar 2022 21:24:31 GMT

Hello Folks,

You can use this pattern to break form a loop.

Loop Break Example

Re: Exit ForEach loop with condition (like in a WHILE statement)

omri-benmoshe — Tue, 15 Mar 2022 21:37:01 GMT

I've added a link to EU Costomers

Loop Break Example EU

Re: Exit ForEach loop with condition (like in a WHILE statement)

kolson — Thu, 17 Mar 2022 04:16:02 GMT

Hi Omri - doesn't the Stop Job exit the entire job? What if you want to continue processing after you leave the loop?

Re: Exit ForEach loop with condition (like in a WHILE statement)

brock-richard — Tue, 29 Mar 2022 02:42:29 GMT

Hey Kris, because the error that is being thrown is inside of the Monitor block, it just exits the loop, and the following steps after the On Error block will continue to be executed.