KB-2148 Export Data Store Entity to CSV or Excel smart service only returns 1000 rows

Symptoms

When using the Export Data Store Entity to CSV or Export Data Store Entity to Excel smart service on a database view or table, only 1,000 rows are exported even though more rows were expected to be exported.

Cause

The CDT and database view/table used for the smart service do not have the same field set as the primary key. Without the same field set as the primary key, Appian will not be able to export the data consistently. This is referenced in the Export Data Store Entity to CSV documentation:

Exporting data store entities from either record lists or smart services relies on sorting the entity by its primary key. This sorting ensures that data is exported consistently - that is, all rows are exported and no row is exported more than once

Action

Update the view/table and/or the CDT to ensure the same field is set for the primary key in both.

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: September 2020

Related
Recommended