topic Re: Running a workflow on a list waiting for each item to complete in Data Hub

Running a workflow on a list waiting for each item to complete

SSamani — Thu, 16 May 2024 15:57:19 GMT

Hi there,

I want to run a workflow on a List of custom objects. I would like each object to complete its run through the workflow before starting the next.

At the moment, I can manually enrol a list to a workflow, but they are all kicked off simultaneously.

Is there any way to do this?

Re: Running a workflow on a list waiting for each item to complete

karstenkoehler — Thu, 16 May 2024 16:01:54 GMT

Hi @SSamani,

This is not possible, no. Can you explain why you want to achieve this behavior? Maybe there's a different approach that accomplishes the same thing.

Re: Running a workflow on a list waiting for each item to complete

SSamani — Thu, 16 May 2024 16:09:22 GMT

The Workflow calls an API of a third party system. Normally in day to day use, the calls to this API via the Workflow are infrequent and reliable. However we have made a change that requires a large number of objects to be refreshed. The third party system's API cannot handle a large number of simultaneous calls. To ensure everything stays in sync between HubSpot and the third party system, we would ideally run in through the Workflow. We just need to throttle the rate at which it is run.

I have tried creating smaller and smaller lists that I enrol onto the workflow, but it going to be a large task to run each of those lists through manually.

I would like to be able to take the full list and let it run and be done when its done.

Re: Running a workflow on a list waiting for each item to complete

karstenkoehler — Thu, 16 May 2024 16:14:07 GMT

Hi @SSamani,

Have you considered using the random percentage branches for this purpose, if needed nesting branches within branches?

You could add different delays (10 minutes, 20 minutes, 30 minutes etc) in each branch before getting to the API step - eliminating lists and breaking the overall list into neat chunks which get handled at different delays.

Re: Running a workflow on a list waiting for each item to complete

SSamani — Thu, 16 May 2024 16:19:06 GMT

Yes, that's was what I was just about to try, went off for a cup of tea and came back with a similar thought. I might create a workflow that waits a random time and then calls the workflow I want.

Re: Running a workflow on a list waiting for each item to complete

james-portant — Tue, 21 May 2024 05:50:33 GMT

Hey @SSamani & @karstenkoehler
We have a similar reuierement and this is a cool solution. I'm also going to try it now.
Thanks for your thread!
Cheers,
James