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.
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
Update the view/table and/or the CDT to ensure the same field is set for the primary key in both.
This article applies to all versions of Appian.
Last Reviewed: September 2020