what is the best way to count the lines in an CSV file, so that if the lines are greater then 1000 it will skip the record creation and then post the whole file into SFTP. if less than 1000 then it will create the record.
aryansrivastava
(Aryan Srivastava)
1
tylerlamparter
(Tyler Lamparter)
2
If you can fit all the data on a single page, you could set your export page size to 1001. Then, within the pre-save page script, you could check whether data.length > 1000, and if so, call the Job API of the current flow to cancel it.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| FAQ: How do I send a series of records in a large CSV file as multiple smaller files via FTP? | 0 | 69 | July 30, 2020 | |
| Getting around API call record limits | 3 | 108 | June 27, 2024 | |
| HOW TO: Optimize FTP file transfers | 0 | 54 | September 21, 2020 | |
| Database export failing due to the size of the export | 1 | 37 | June 16, 2021 | |
| Improving Performance in a File-Based FTP to S3 Flow | 3 | 68 | August 13, 2025 |