jmacdonald
09/25/2019, 12:30 PMjarens
09/25/2019, 2:54 PM/**
 * @NApiVersion 2.0
 * @NScriptType suitelet
 * @NAmdConfig /SuiteScripts/configuration.json
 * @Author Jack Arens | National Food Group
 */
define(['papaparse', 'N/file'],
    function (papaparse, file) {
        var exports = {onRequest: onRequest};
        function onRequest(options) {
            var request = options.request;
            var response = options.response;
            log.debug('Request', request.files.upfile);
            var csv = request.files.upfile.getContents();
            //This breaks when '\n' is in a cell
            log.debug('Read CSV', readCSV(csv));
            //This breaks when '\n' is in a cell
            var iterator = request.files.upfile.lines.iterator();
            iterator.each(function (line) {
                log.debug('Line', line);
                return true;
            });
            //Doesn't break when '\n' is in a cell
            log.debug('Papa Parse', papaparse.parse(csv).data);
            response.writePage({
                output: 'File Received'
            });
        }
        function readCSV(csv) {
            return csv.split('\n');
        }
        return exports;
    });jarens
09/25/2019, 2:54 PMjmacdonald
09/25/2019, 3:26 PM