How do you raise the row limit in OpenAPI

Document ID : KB000117836
Last Modified Date : 18/10/2018
Show Technical Document Details
Introduction:
How to raise the returned row limit in OpenAPI.
Instructions:
  1. Log on to the Data Aggregator host.
  2. Locate and edit the following file:
    /opt/IMDataAggregator/apache-karaf-<vers>/etc/com.ca.im.odata.beans.ODataLimiters.cfg
  3. Modify the file to set the limits and defaults. The following example shows the default values for this file. The bold attributes control the limits and defaults:

    defaultTopLimit=50
    defaultExpandTopLimit=100
    maxTopLimit=20000
    maxSubQueryLimit=2000000
    defaultRateTimeIntervalSecs=3600
    defaultHourlyTimeIntervalHours=168
    defaultDailyTimeIntervalDays=30
    defaultWeeklyTimeIntervalWeeks=52
    defaultQueryTimeoutSecs=30
    maxQueryTimeoutSecs=120
  4. To alter the row limit, alter maxTopLimit:  Defines the limit for the value in the maximum number of rows in the output.
Additional Information:
Please keep in mind that this default of 20,000 is there to protect the environment.  Raising it beyond 20,000 has risk and that risk gets larger the further beyond 20,000 you raise it.

Documentation Link:  (3.6)

https://docops.ca.com/ca-performance-management/3-6/en/apis/openapi/configure-openapi-defaults-and-limits