Integration issue- the last line is split across two files (chunk 1 and chunk 2)


Hi Team,

while calling through API for export for integration, if the file size is large, it is divided into chunks of 10MB each (e.g. if the file size is 890 MB, it will be divided into 89 chunks). As a result, we are getting incomplete record on the last row of every chunk and the rest of the records are being stored in the next chunk due to the size limitation of 10 MB. Please suggest some ways to get rid off this issue so that each chuck contains complete rows (even if the size of the chunks will be slightly less than 10 MB) and the partial row in chunk1 can get shifted to chunk2 as a complete row.