https://netsuiteprofessionals.com logo
Join Slack
Powered by
Im trying to do run a multiple file saved import u...
# suitescript
n
Im trying to do run a multiple file saved import using the 
task
module. I am not getting a particular useful error log, just that 
FAILED_TO_SUBMIT_JOB_REQUEST_1
. I think the only problem I have is with the 
CsvImportTask.linkedFiles
. It says it takes a key value pair. Not sure what the 
key
is. Here is the example NS gives 
scriptTask.linkedFiles = {'addressbook': 'street,city\nval1,val2', 'purchases': file.load('SuiteScripts/other.csv')};
in this example they used 
addressbook
and 
purchases
. Where do they get the internal id, is it the record browser, analytical browser, not sure what the internal id is of the linked record? For my specific case, I am trying to use the 
Sales Order Items
for the linked file. Not sure what the internal id is for that, is it just 'items' ?
b
probably item
n
yeah it doesn't seem to work. it could be something else though. as mentioned, not getting a useful error
i'll play around with it a bit more tomorrow
b
the rather boring looking:
Copy code
require(["N/task", "N/file"], function (task, file) {
  var scriptTask = task.create({ taskType: task.TaskType.CSV_IMPORT });
  scriptTask.mappingId = 2;
  scriptTask.importFile = "number,entity,location\r\nSOT1,9,1";
  scriptTask.linkedFiles = { item: "number,item,amount\r\nSOT1,9,9" };
  scriptTask.submit();
});
works for me, the mapping was setup such that the number column is the primary key and all the select fields were done by internal id number instead of name
2 Views
Open in Slack
PreviousNext
Powered by