Getting empty return when using Resources["CSVParserFunctions"].ReadCSVFile(params);
I have a simple CSV file with content like below.
Date,PCSN,Total
4/27/2018,H192857,3
4/27/2018,H193177,4
4/27/2018,H193100,20
I'm using CSVParser_Extensions v4.0.1, but keeps getting empty returns with the following code. Really appreciate any help on this.
var sFile = "PMP/test1.csv";
var params = {
path: sFile /* STRING */,
columnMappings: 'Date;PCSN;Total' /* STRING */,
hasHeader: true /* BOOLEAN */,
longitudeField: undefined /* NUMBER */,
dateFormat: "dd.MM.yyyy" /* STRING */,
fileRepository: me.name /* THINGNAME */,
latitudeField: undefined /* NUMBER */,
fieldDelimiter: "," /* STRING */,
stringDelimiter: "\"" /* STRING */,
dataShape: "VMS.CSV.Test" /* DATASHAPENAME */
};
// result: INFOTABLE
var result = Resources["CSVParserFunctions"].ReadCSVFile(params);