I have a view with 11017 records and I'm trying to export this data to csv via Export Data Store Entity to CSV smart service. The issue is that it exports only 11015 records and the file size is around 200KB
Discussion posts and replies are publicly visible
Without any details, it is impossible to suggest anything.
Are you sure there are no filters applied?
After applying a filter I'm receiving 11015 records in CSV and 11017 records in the view.
The view actually has 53 columns but I'm querying only 3 columns. After applying the filter I can see 11017 records in the view and 11015 records are extracted to CSV
does your view have a primary key? I would suggest checking the view, this might be causing the issue. You can find more suggestions here:
No, my view doesn't have a primary key. So I did try assigning the primary key but interestingly the smart service started exporting more than 173430+ records and throws an error while the view has only 11017 records.
I used row_number() as the primary key which for some reason generated 173430+ records. So instead I have used 2 ID columns from the table to create a primary key in the view and that solved the problem
© 2023 Appian. All rights reserved.