@J_I Late to this post but I thought I would throw this out there. I’ve been using a scheduled function to run much of our integration UBAQs. The steps you tried can be simplified.
- DynamicQuery.GetQueryExecutionParametersByID
- DynamicQuery.ExecuteByID - Runs the GetList
- Updating the fields in the DataRows via ‘Custom Code’ node + setting DataRow.RowMod = “U”.
- DynamicQuery.UpdateByID - Updates the Results table.
If you don’t want to use custom code to set the RowMod, you can use an Update Table By Query widget in a Pre-Processing directive of the Update Method of the UBAQ.
Here is a basic version of the function.
UBAQRunner.efxb (26.4 KB)