Clarity Service Management

Expand all | Collapse all

Need help with retrieving more than 250 items from web-service

Jump to Best Answer
  • 1.  Need help with retrieving more than 250 items from web-service

    Posted 01-16-2018 04:34 PM

    I am using C# and USD web service (ver 11) to create a custom report. I found some documentation on how to get around the web service limitation to max 250 items. The documentation shows web calls. to doSelect and getListValues. 

    Anyone has an example using c# code?



  • 2.  Re: Need help with retrieving more than 250 items from web-service
    Best Answer

    Posted 01-16-2018 05:55 PM

    Bill, doQuery() does not have 250 max rows limit. And if you want to use doSelect(), then you would need to -1 for maxRows argument. Here is something that may help you start...

    ListResult allContacts;

    allContacts = ws.doQuery(SID, "cnt", "");

    string[] attrs = { "last_name",  "first_name", "middle_name" };

    string node = ws.getListValues(SID, allContacts.listHandle, 0, -1, attrs);

    ArrayList sdmObjects = getUDSObjects(node);

    for (int i = 0; i < sdmObjects.Count; i++)

    {

    ...

    }

    Thanks _Chi



  • 3.  Re: Need help with retrieving more than 250 items from web-service

    Posted 01-16-2018 05:57 PM

    That is very helpful. Thanks



  • 4.  Re: Need help with retrieving more than 250 items from web-service

    Posted 01-17-2018 10:11 AM

    Bill.......

     

    Did the information provided by Chi_Chen assist you?

     

    If so, please mark his answer as correct so that this thread can be closed.