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

[filipe-oliveira]

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

[david-macintosh]

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.

[omri-benmoshe]

Hello Folks,

You can use this pattern to break form a loop.

Loop Break Example

[omri-benmoshe]

I've added a link to EU Costomers

Loop Break Example EU

[kolson]

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

[brock-richard]

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.