Is there a functionality to schedule data flows to run on a reoccurring basis? Basically looking to create a cron job. I’m looking to see if we can run a data flow to consolidate data every 30-60 minutes during the business day and then send it out via SFTP after all new inputted data as been consolidated.
Hi!
I’m curious if anyone has a better solution than the extremely hacky solution I’ve used in the past, but I’ll share how I’ve done it during a literal Hackday.
To run a data flow (or fire any other Action Chain) periodically, I’ve set up two Timers and cycled back and forth between them. The idea is that Timer 1 can set Timer 2 at the end of the Action Chain it fires, and then Timer 2 can set Timer 1 at the end of the Action Chain it fires, and then they can pass the time keeping back and forth between them. It’s also possible to build checks into the Action Chains both timers take (using the Conditional Action) to not set the other timer under certain conditions - which seems like a feasible way send out data after it’s been consolidated.
Does that make sense? I’m aware that this seems like extremely bad practice (though it does get the job done!) and I’d love to hear if anyone’s done something like this more neatly than I have.