search cancel

SDM: Returning all rows in a REST Web Services Query

book

Article ID: 187799

calendar_today

Updated On:

Products

CA Service Desk Manager SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service CA Service Desk Manager - Mobile Application CA Service Desk Manager - Xtraction

Issue/Introduction

When running a REST Web Services query, only 25 records are returned at a time.  Is there a way to increase this record count or have all records returned by default?

Environment

Release : 17.2

Component : Svc Desk Web Services

Resolution

It is not possible to default list out all possible records due to the potential of a performance issue when returning for such queries.  However, in Service Desk Options Manager (accessible by logging into the SDM Web interface as a user with Admin privileges), the following settings dictate the number of records returned by REST Web Services:
 
rest_webservice_list_max_length:
    Specifies the maximum number of rows that a REST Web Service query returns.
    Default: 500
 
rest_webservice_list_page_length:
    Specifies the default number of rows that a REST Web Service query returns per page.
    Valid Range: 1-500
    Default: 25
 
We have experimentally tested providing a very large integer value which would exceed the valid range for option "rest_webservice_list_page_length" with some success.  However, such testing was not very rigorous and we would suggest to abide by the recommended range value that is given.