Table Function with parameter in External BAQ using C# code

Epicor ERP 10
1

I have an external BAQ that uses a table function with parameter. It works fine using the External BAQ program, however it doesn’t work when I call this EBAQ using code.

image
image521×545 17.5 KB

image
image855×365 15.9 KB

I get the following error:

Parameter ‘paramCustNum’ is configured as mandatory but no value is specified

Even tho I add the parameter and its value inside the “ExecutionParameter” table:

using (DynamicQueryImpl dynamicQueryBO = WCFServiceSupport.CreateImpl<DynamicQueryImpl>(_session, DynamicQueryImpl.UriPath))
                {
                    DynamicQueryDataSet dsDynamicBAQ = new DynamicQueryDataSet();
                    QueryExecutionDataSet dsExecutionParams = new QueryExecutionDataSet();

                    dsDynamicBAQ = dynamicQueryBO.GetByID(baqName.Trim());

                    foreach (KeyValuePair<string, string> pair in _params)
                    {
                        dsExecutionParams.Tables["ExecutionParameter"].Rows.Add(pair.Key, pair.Value, typeof(string), false);
                    }
                    resultSet = dynamicQueryBO.Execute(dsDynamicBAQ, dsExecutionParams);
                }

I have also done it using typeof(int) but it still doesn’t work.

Any ideas what I am doing wrong?