topic Re: Incomplete data export due to number of cell limitations in App Development

Incomplete data export due to number of cell limitations

SaaraKorppi — Mon, 04 Jul 2022 07:41:27 GMT

We are using the Capability API exportData (https://help.qlik.com/en-US/sense-developer/February2022/Subsystems/APIs/Content/Se[…]ientAPIs/CapabilityAPIs/VisualizationAPI/exportData-method.htm) 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-ExportData.html.

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

Re: Incomplete data export due to number of cell limitations

Tami — Mon, 11 Jul 2022 15:47:27 GMT

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.

Re: Incomplete data export due to number of cell limitations

carlos_molino — Mon, 11 Jul 2022 20:23:42 GMT

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-genericobject-exportdata.htm