Hi @andybmac,
What I would recommend is having a schedule run on an hourly basis (or set it up with a half-hour bias) - for example, you could set one up to check on the hour and another to check half past the hour.
With looping coming out in the next release or two, here’s how I would set it up. I would have a connector to the table API with a query that looks for the current time or earlier and returns the list of IDs. I would loop over that list of IDs and perform whatever action that you need for each item.
I know that doesn’t fulfill the exact criteria that you were looking for but should suffice.
Thanks,
Jake