topic Re: Count and Wait loop in Workato Pros Discussion Board

Count and Wait loop

simontl — Thu, 27 Mar 2025 10:21:14 GMT

I want to have a loop with a counter causing a wait to stop a flood. In Step 4 i have tried changing the Clear Step Output to yes but it still sticks in the 'recordset' from Step 2 - so it processes record 1 3 times. The Google sheet simply shows me what is being processed. Can you help a newbie please?! Thanks.

Re: Count and Wait loop

Prudvi — Thu, 27 Mar 2025 11:00:36 GMT

Hi @simontl,
Not sure what is the exact purpose of using a mycount variable.

What I understand is you want to wait for sometime before processing the next record.
Instead you can use Wait for specified length of time for each iteration, before processing next record in the For Each.
Regards,
Prudvi

Re: Count and Wait loop

shivakumara — Thu, 27 Mar 2025 11:25:11 GMT

Hi @simontl ,
1. I am just curious to know what is the filter condition you are using in the step.2?
2. Does it mean you are getting same payload again and again from the step.2? if possible, can you add the screenshots
3. What are the updates you are doing at the step.5?

Please kindly give your inputs so that we can provide you the suitable solutions.

Thanks and Regards,
Shivakumara K A

Re: Count and Wait loop

ansa — Thu, 27 Mar 2025 14:59:21 GMT

Try something like this. This will pause after each item, after the third item. If you want to Stop after the third item, add a Stop instead of the pause. Hope this helps

Get HTTP List
Create Variable myCount

For each Item in HTTPList
Update gSheets with Item
Increment myCount
If myCount >=3
Pause (or Stop)
End If
Continue Loop

Re: Count and Wait loop

gary1 — Thu, 27 Mar 2025 15:44:31 GMT

Your description of the issue is a little confusing, but I think you're saying the HTTP action (step 5) keeps processing the same record over and over. This is probably because your input for step 5 is using output from step 2 when it should be using output from step 4.

When you create a loop action (step 4), the output of the loop action handles the iteration through your array.

If you use the output from step 2 within the loop, you'll access the same item/data every time (it will default to the first item in the array).

If you use the output from step 4, you'll get the iterated item and its data.

Re: Count and Wait loop

simontl — Fri, 28 Mar 2025 09:21:48 GMT

Thanks gary1... You gave me hope until I confirmed my datapill is indeed from step 4. It is almost as if the counting makes Workato forget where it is. I renamed the variable to 'mycount' in case 'count' was reserved but it made no difference.
And thanks to the others. It seemed a better idea to process a few records and then pause. I have used that approach before.
As background, this is for PlanRadar and I am processing 'tickets' to change their status. The filter is set by the user in the front-end, for example 'all tickets created before 31/12/2024 and not closed'.
Thanks again.