UBAQ update fields via powershell

[Nancy_Hoyt]

Hi there,

I am struggling with a UBAQ and I think I am just not thinking about it correctly.

We have powershell running DMT to upload some records automatically. I would like to add a run of an Updateable BAQ in there to input data into two fields on the order line after my imports (it’s taking OrderDtl Char03 and putting into QuoteNum and ShortChar03 and putting into QuoteLine, I also do the var to int conversion).

I have the uBAQ made, but I am not sure what to put a bpm on to get the fields filled out. I tried Set field via get list post processing, and on manual run it shows the data there, but I don’t get an “update” when I try to run from the PS script. How do I setup the UBAQ for the PS run on the query export to update the data?

(PS: I know there are now more elegant ways for this with functions and Rest calls and whatnot. But we have this getting used effectively at this time and really just need to tweak it for a minor data fix post imports.)

thanks for your consideration!
Nancy

[aosemwengie1 (Alisa Osemwengie)]

Use your powershell to execute this function:

Run UBAQ via Function

@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. [image] If you don’t want to use custom code to set the RowMod, you can use an Up…