Odata Connector limits data to 2000 rows while calling from postman

[sangrover]

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)

Ca PPm ticket.txt.zip   695 B 1 version

[Jose Ignacio Mugica]

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