SDM: Returning all rows in a REST Web Services Query

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.3.X

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.