How can I implement GP WebService "GetCustomerList" using eConnect, i.e. I have to pull summary data/fields for all customer records. I see the default DOCTYPE = 'Customer' needs Index1From & Index1To to be set to valid value, to pull one or more customer records. However, first thing I don't have the key in the code until I have customerList and secondly I don't need all customer data in detail just summary fields.
eConnectOut etOut = new eConnectOut();
etOut.DOCTYPE = "Customer_List";
etOut.OUTPUTTYPE = Int32.Parse(key);
etOut.INDEX1FROM = "1234567890";
etOut.INDEX1TO = "1234567890";
etOut.FORLIST = 1;
etOut.ACTION = 0;
etOut.FORLOAD = 0;
etOut.ROWCOUNT = 0; //all rows
I tried to extend eConnect Doctype by making insertion in eConnect_Out_Setup table for DOCTYPE=Customer_List alike Customer and removing any required, index or trigger column values. But when I try call that DocType from code, I get null result.
What am I doing wrong and what is the best way to implement GP WebService methods in eConnect, since I don't have option to use WebServices (as its not configured on my server due to missing patches which I can't get) and making direct SQL call is my least preferred way ?