Update Table by Query in Function - Set RowMod = "U" Causing API Issue with Invoke BO Method

Kinetic ERP
1

I am trying to use a function to update records in the PartWhse table. I have an Invoke BO Method that uses Erp.PartWhseSearch.GetRows, I have an Update Table by Query widget, and then an Invoke BO Method that uses Erp.PartWhseSearch.Update.

When I don’t set RowMod = “U” in the Update Table by Query widget, nothing gets updated in the PartWhse table.

When I do set RowMod = “U” in the Update Table by Query widget I get an error because there is no API key being sent

image
image869×83 7.29 KB

I added the following assemblies to my function, but this hasn’t helped. I am not sure how to add get the update to work and send the API key as part of the Invoke BO Method.

image
image975×595 81.9 KB

@hmwillett You have been extremely helpful in the past, if you have any insight into this issue I would appreciate your help once again.

2

Why are you using REST inside a function, is there a reason you can’t use the business objects directly?

3

Honestly, lack of seeing another way based on the widgets available in the function design.

I would very much welcome alternative solutions.

I am calling the function when the update button is clicked on a Dashboard populated by a UBAQ.

I did start trying a data directive instead of the function but I am still curious why the update isn’t working when rowmod is set to U.