I am using Foundry automate to write ontology actions (for either AIP functions or external API via webhooks)
While this typically works on an ongoing basis for data change, usualyl you run into problems for the initial batch where you need to run the edit functions for millions objects. There is a limitation in Foundry Automate to manually execute the queries to a certain batch size; and there is no way I can set - let’s run these batches, then after these batches run the other etc.
this resulted in someone needing to remember to click the button every few hours.