Custom Load Method with IDOWebService.asmx

Hi All,

I'm attempting to run the Time Phased Inventory Status for a single item in SL8 using the IDOWebService.asmx methods. I have been getting an error message back that states that you cannot call the Custom Load Collection directly.

Should I be attempting to load the collection via the Post-Query Command or do I need to be using the CallMethod ?

List locProps = new List() { "Item", "DerQtyOnHand", "DerQtyRsvdCo" };

DataTable dtLocs = await IDO.CallMGRest(xSLToken, "SLItems", locProps, string.Format(@"Item='{0}'", item), "", "SupDemItemwhseSp('MAIN', '')", 0);

return StatusCode(200, JsonConvert.SerializeObject(dtLocs.Rows));

Thank you!

Find more posts tagged with

Accepted answers

Legacy Contributor

Short answer, you can't with IDOWebService.

Slightly longer answer, use the .NET API and its LoadCollection command to call a Custom Load Method on an IDO.

Legacy Contributor

The method does take two parameters, the warehouse (which can simply be MAIN) and a special filter. It's not documented, but when you do a wiretap on the call the form makes, you can discover the format of how that parameter should be sent:

<FilterString><Item><Property>Item</Property><Operator>=</Operator><Value>AL-10000</Value><DataType>ItemType</DataType></Item></FilterString>

So if you pass that XML code as a normal string for the second parameter, the call will succeed and you will get your results. Obviously replace the Value element contents (AL-10000) with the item # you want the Time-Phased Inventory data for.

Legacy Contributor

Here is my Postman request string:

https://hostname/IDORequestService/MGRestService.svc/json/SLItems/adv?props=Item,Description,DerQtyOnHand,DerQtyRsvdCo,ITWHWhse&amp;filter=&amp;orderby=&amp;rowcap=200&amp;distinct=&amp;customloadmethod=SupDemItemwhseSp&amp;customloadmethodparms=MAIN,<FilterString><Item><Property>Item</Property><Operator>=</Operator><Value>AL-10000</Value><DataType>ItemType</DataType></Item></FilterString>&amp;loadtype=&amp;bookmark=&amp;postquerycommand=&amp;readonly=&#39;

 The second parameter is the XML, just escaped. It is the same as I sent previously.

All comments

Legacy Contributor

Short answer, you can't with IDOWebService.

Slightly longer answer, use the .NET API and its LoadCollection command to call a Custom Load Method on an IDO.

Legacy Contributor

Hey Tim,

Thanks for the response.

I was also looking at the MGRestService.svc methods and realized there is a customloadcollection there. I'm attempting to utilize this feature using Postman now.

I've gotten my token and I can call back a simple SLItems query -- however this particular customloadcollection requires parameters -- The IDO Methods for suggests that this SupDemItemwhseSp method does not have any parameters.

Nonetheless I've tried to pass parameters that the default SupDemBuildSp require, which is Warehouse and Filter -- but I am getting an error back from the API saying that the input contains invalid xml characters. Any idea how to actually pass these CustomLoadCollectionParms with the Rest API?

Legacy Contributor

Hey Tim,

Thanks for the insight -- it is much appreciated.

I'm however still having an issue with defining how the parameters should be passed in the "customloadmethodsparms" query.

I've tried a couple things but i'm still getting "Wrong number of parameters in call to SupDemItemwhseSp method."

My Postman Url looks like this:

{{baseUrl}}/json/:ido/adv?props=Item,Description&filter=Item = '2A17922X'&orderby=ASC&rowcap=0&distinct=false&customloadmethod=SupDemItemwhseSp&customloadmethodparms=<Parameters><Parameter>MAIN</Parameter><Parameter><FilterString><Item><Property>Item</Property><Operator>=</Operator><Value>AL-10000</Value><DataType>ItemType</DataType></Item></FilterString></Parameter></Parameters>&loadtype=&bookmark=&postquerycommand=&readonly=

<Parameters><Parameter>MAIN</Parameter><Parameter><FilterString><Item><Property>Item</Property><Operator>=</Operator><Value>AL-10000</Value><DataType>ItemType</DataType></Item></FilterString></Parameter></Parameters>

Copyright © 2025 Infor. All rights reserved.