Cognos Analytics

 View Only
Expand all | Collapse all

Rest API - 1000 row limit

  • 1.  Rest API - 1000 row limit

    Posted Thu September 22, 2022 07:35 AM
    Has anyone figured out how to overcome the 1000 row Get limit on an API?  I am using the Progress Data Direct Rest API, which I know has some sort of paging option.  But how do I get all rows returned to a single object in a data module?

    Unions don't seem to be an option in the Data Module either.
    (Cognos Analytics on Demand)

    Thanks and hoping .....
    --
    Please note that our normal operating hours from Monday to Thursday are 08h00-17h00 SAST and 08h00-13h00 SAST on Fridays. SSN believes in the need for flexibility in how we and our partners work. Whilst it suits me to send this email now,  any response or action required from you respects your flexibility, unless time-sensitivity is explicitly indicated. 

    #CognosAnalyticswithWatson


  • 2.  RE: Rest API - 1000 row limit

    IBM Champion
    Posted Thu September 22, 2022 11:40 AM
    Hi,

    There is a documentation provided by IBM available at the following URL:
    Progress® DataDirect® Autonomous REST Connector for JDBC™ User's Guide for Partners

    You will find explanation about changing "#maximumPageSize":1000,"

    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------

    Original Message