I thought a simple flat file to web service call would be very simple, but it just turned out not to be. Let’s still call it simple because in the end that’s all it is - we get all the data lines within a given CSV file sent over web.
Firstly, the file and it’s quirks
Depending upon various factors including the age of the host, where the host is (both geography and within a given IT environment), the operating system and software etc., the file is encoded. UTF-8 is the recommended encoding for HTML5 (and in turn the most common encoding for any web service calls). But given this is fairly new, most often than not we will find encoding to be different.