Have successfully created an External BAQ in Epicor that reaches out to SQL database table and returns a single value:
I have then created a post-processing method directive where I’m trying to execute this external BAQ and pass the result into a variable. I’ve added the “Invoke BO Method”, calling the “Ice.DynamicQuery.ExecuteByID” with specified parameters.
The parameters queryID, executionParams, and return value:
The QueryID and return value are pretty straightforward…but what is supposed to go into the executionParams? The dropdown in that field allows for creating a new variable or creating a new expression. Just not sure what this is expecting.
Trying to use the widget for dynamic query is kind of a pain . It’s easier in code. You need to get the execution parameters first. If you don’t have any parameters I think you might be able to leave it unspecified.
Oh, meant to mention. If I leave the executionParams as [unspecified] (using the widget), I get an error of Element: Invoke BO Method 2; Description: Business object method parameters not mapped: ‘executionParams’.
That dataset should be just a single value passed back. How do a assign that value to a variable or a BPM data field? Tried this but received an error, so I must be using the wrong “passing” value: