I have a csv file with delimiter '|'. When I try to run the smart service by passing a csv file where few fields are null, it is returning the error message 'Error executing SQL'. But when I replace the null with random text values it is writing the data to DB.
Is this an expected behavior of this smart service?
Is there any way to import or read a csv file with null values?
Discussion posts and replies are publicly visible
Just keep in mind that previewCSVForImport() is intended for small CSV files only, as it can read a maximum of 1,000 rows per call. It’s great for previews or lightweight imports, but not suitable for large files.
previewCSVForImport()
Nandhavi Nandakumar Thanks for the update! Let me know how it goes after updating to the latest version.