How to call SOAP Dynamic query with paging

Epicor ERP 10
1

Hi,

I have been looking at the Ice/BO/DynamicQuery.svc and have been to get the result of a BAQ, and I want to also using paging on the results. I have had a look around but cannot seen any previous question explaining how to call BAQ using SOAP.

I am not sure which method to use? I can see methods which return an empty dataset and the most likely method looks
like “GetList”

GetList(DynamicQuery.DynamicQueryTableset queryDS, DynamicQuery.QueryExecutionTableset executionParams, int pageSize, int absolutePage, out bool hasMorePage)

But I so not see where I specify the BAQ name to execute and not sure how to call.

Regards
Richard

2

Just to share the solution, C#

Epicor_SOAP_Test.Epicor.DynamicQuery.DynamicQuerySvcContractClient dynQuery = GetClient<Epicor_SOAP_Test.Epicor.DynamicQuery.DynamicQuerySvcContractClient, Epicor_SOAP_Test.Epicor.DynamicQuery.DynamicQuerySvcContract>(builder.Uri.ToString(), epicorUserID, epiorUserPassword, bindingType);
var eParms = new Epicor.DynamicQuery.QueryExecutionTableset();
Epicor.DynamicQuery.ExecutionSettingRow pageParm = new Epicor.DynamicQuery.ExecutionSettingRow();
eParms.ExecutionSetting = new Epicor.DynamicQuery.ExecutionSettingTable();
pageParm.Name = “PageNum”;
pageParm.Value = “111111”;
pageParm.Value = “2”;
eParms.ExecutionSetting.Add(pageParm);
//
Epicor.DynamicQuery.ExecutionSettingRow pageSizeParm = new Epicor.DynamicQuery.ExecutionSettingRow();
pageSizeParm.Name = “PageSize”;
pageSizeParm.Value = “1”;
eParms.ExecutionSetting.Add(pageSizeParm);
System.Data.DataSet x = dynQuery.ExecuteByID(“AM_SensorPro_Emails”, eParms);

1 Like