how to check is .csv file is corrupted or not

Question

hi, 
 
 is there any function that we can check is .csv file is corrupted or not? 
 note:-.csv.file will receive from external system 
 
 suggest me best approch?

Harsha Sharma · Answer

I assume if a file is corrupt then any function or smart service trying to read data from it will not behave as expected. So you can try reading data from the file and log accordingly if its successful or not.

Shubham Aware · Answer

PM Exception Flow is your only native way to catch can't open scenarios. Receive File -> Try to Parse CSV -> if Success: Process Data ; if Exception: Write "CORRUPTED" to DB -> Notify Team.

Stefan Helzle · Answer

A CSV file is just text. So technically it cannot be corrupt or encrypted. But it might happen that it does not follow the expected schema. You could try to read the first line and check the column names against your expectations.