Learn how to submit a CSV Import using SuiteScript

				
					/**
 *@NApiVersion 2.1
 *@NScriptType ScheduledScript
 */

define([ 'N/search', 'N/file', 'N/task'],
 (search, file, task) => {

	execute = (context) => {
        log.debug('==START==','==START==');
        try {
            const allFiles = getFiles();
            for(let fileId of allFiles) {
                // create CSV import task
                const scriptTask = task.create({taskType: task.TaskType.CSV_IMPORT});
                // change this to your mapping ID
                scriptTask.mappingId = 116;
                const csvFile = file.load(fileId);
                scriptTask.importFile = csvFile;
                // submit csv import job
                const csvImportTaskId = scriptTask.submit();
                log.debug('CSV task submitted ID', csvImportTaskId);
            }
        }
        catch(e) {
            log.error('Error', JSON.stringify(e));
        }
    }

    getFiles = () => {
        const folderSearchObj = search.create({
            type: "folder",
            filters: [
                // change this ID to the folder ID where the CSV files are
                ["internalidnumber","equalto", 655]
            ],
            columns: [
                search.createColumn({
                    name: "internalid",
                    join: "file",
                    label: "Internal ID"
                })
            ]
        });
        let allFiles = [];
        folderSearchObj.run().each(function (result) {
            let internalid = result.getValue({
                name: "internalid",
                join: "file",
                label: "Internal ID"
            });
            allFiles.push(internalid);
            return true;
        });
        return allFiles;
    }

    return {execute};

});