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.
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.
