Incomplete data export due to number of cell limitations

[SaaraKorppi]

We are using the Capability API exportData (https://help.qlik.com/en-US/sense-developer/February2022/Subsystems/APIs/Content/Se[…]ientAPIs/Capab...) to get the exported Excel files and CSV files, and we found there are limitations in number of cells, when reached the limitation, the exported file is incomplete. We tried to find the exact number of the limitation from Qlik but only found one related EngineJSON API documentation and it's a bit outdated https://help.qlik.com/en-US/sense-developer/February2021/apis/EngineAPI/services-GenericObject-Expor....

Are the limitations in that documentation still used and do they also work for the Capability API exportData?

[Tami]

We had a similar issue when using API to retrieve data so we keep looping the API call until there are no other records found. 

[carlos_molino]

The default maximum number of rows in the Excel export file is: 1048566 rows per sheet. For pivot tables: 1048566 column dimensions. 10 rows can be added after the export.

You can find more information in:

https://help.qlik.com/en-US/sense-developer/May2022/Subsystems/EngineJSONAPI/Content/service-generic...