Clarity PPM1

Expand all | Collapse all

Odata Connector limits data to 2000 rows while calling from postman

Jump to Best Answer
  • 1.  Odata Connector limits data to 2000 rows while calling from postman

    Posted 05-17-2019 04:01 AM
      |   view attached

    I Am using odata to pull some table data on my DW. When i am using the direct odata connector on Tableau, it's giving me all rows. When i am calling the api through Postman or python script, its limiting number to 2000, is there a way to use pagination to pull entire data.

    Example of URL i am trying to call:

    https://cppmbi9000s.ondemand.ca.com/api/odata4/SJC014tDataSourceV4/DWH_INV_OBS_MAPPING

     

    I have attached the code also on what python code i am using to call the api.

    Attachment(s)

    zip
    Ca PPm ticket.txt.zip   695B 1 version


  • 2.  Re: Odata Connector limits data to 2000 rows while calling from postman
    Best Answer

    Posted 05-21-2019 04:14 AM

    Hi Sangoyita,

    I see an issue was opened with support.

    Pasting the issue content here:

    10000 records is the limit set by Saas and cannot be increased.

    If you are only seeing 2000 records then that may be an issue with the third party tool you are using.

    The 10000 limit per page is set by SAAS to ensure not too much data is pulled in the ODATA connector

    For building reports, we recommend that you use a reporting tool such as Power BI. Power BI renders the data faster using caching and offers better data
    security and control.

    Business intelligence tool recommended in the documentation for example: Microsoft Power BI or Tableau

    Excel provides no convenient way to map the report users to the Clarity PPM users.

    OData v4 is not supported by Tableau; it support only v2. Microsoft Power BI supports both.

    https://docops.ca.com/ca-ppm-saas/15-6/en/administration/configure-the-data-warehouse-and-advanced-reporting/configure-odata-access-to-the-data-warehouse

    Regards