We have a number of plumer APIs on connect, all currently invoked by other platforms. We would like to leverage some of these in order to update some table via the API. Is it possible to trigger an API to run at a certain day / time? Or do we have to have something invoke the request?
You need something that invokes the API. Where are you hosting these APIs? If you are using Posit Connect, you could publish a document (quarto/RMarkdown/Jupyter) and set it on a schedule. Otherwise a cron job should work as well.
Yes these are all on Connect. We have some other jobs invoked by rmd schedule, just wasnt sure if i was missing a built in feature! Will do this, thanks!