Learn how to Automatically add an Attachment to a NetSuite Message Object

5 thoughts on “Learn how to Automatically add an Attachment to a NetSuite Message Object”

1. how can I attach a file in the file sublist of any transaction in 2.0. I have tried the below code but its giving error as :”SSS_INVALID_SUBLIST_OPERATION”,”message”:”You have attempted an invalid sublist or line item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist.

   Code:
   var attachment_list = new Array();
   attachment_list.push(fileObj.id);
   var nsRecord = record.load({
   type : record.Type.INVOICE,
   id : i_INV_InternalID,
   isDynamic: true
   });
   var lineCount = nsRecord.getLineCount({
   sublistId: ‘mediaitem’
   });
   log.debug(‘lineCount:’,lineCount);
   //return;
   nsRecord.selectNewLine({
   sublistId: ‘mediaitem’
   });

   nsRecord.setCurrentSublistValue({
   sublistId: ‘mediaitem’,
   fieldId: ‘mediaitem’,
   value: attachment_list[0]
   });

   nsRecord.commitLine({
   sublistId: ‘mediaitem’
   });

   var success = nsRecord.save({
   enableSourcing: true,
   ignoreMandatoryFields: true
   });

   Reply

   1. Hello Onkar,

      Sublist operations can be tricky. There are two approaches to use. You may want to try the record.Sublist operation instead of the method you are trying. Here is some SuiteScript 2.0 SuiteLet code where we are in a POST and a file was submitted. We attach it to a purchase order and then we display to the user the name of the file that was submitted.

      if (request.files.file)
      {
      log.debug(request.files.file, request.files.length);
      for (names in request.files.file)
      {
      log.debug(‘file.field:’ + names, request.files.file[names]);
      }

      request.files.file.folder = runtime.getCurrentScript().getParameter({
      name: ‘custscript_pri_trx_app_file_cabinet_loc2’
      });

      request.files.file.name = Date.now() + ‘_’ + request.files.file.name;
      log.debug(request.files.file.folder);

      var internalID = request.files.file.save();

      log.debug(‘file saved’, internalID)
      log.debug(‘tran_id’, tran_id);
      log.debug(‘mode’, mode);

      if (internalID && tran_id) {
      record.attach({
      record: {
      id: internalID,
      type: ‘file’
      },
      to: {
      id: tran_id,
      type: record.Type.PURCHASE_ORDER
      }
      });

      statusFld.defaultValue = ‘Success! ‘ +
      ‘File ‘ + request.files.file.name + ‘ successfully attached to the transaction.‘;
      }
      }

2. Hello Marty.

   Thanks for this. Is there a way to automatically include several email addresses in the email window?

   Thanks a lot.

   Reply

   1. I think you would have to manipulate the form via undocumented NetSuite client-side libraries. I have interrogated the email client-side forms (there are two of them) and it is feasible.

      Marty

3. For anyone working on attaching additional email and file to the message object, the easiest way I found is to use the search module to get additional emails and file ids to attach to message:
   Code:
   Part I for the additional emails
   First get the emails form a custom field, in my case I have a custom filed in the customer record to save the emails delimited by commas

   *******************************
   function addCCRecipients(REC, rootRecType, recid) {
   var customerId = null;

   // Get the customer ID from the transaction itself
   if (rootRecType == ‘TRANSACTION’) {
   try {
   var lookupResults = search.lookupFields({
   type: search.Type.TRANSACTION,
   id: recid,
   columns: [‘entity’]
   });

   if (!isEmpty(lookupResults.entity)) {
   customerId = lookupResults.entity[0].value;
   }
   } catch (lookupError) {
   return; // Exit this function
   }
   } else if (rootRecType == ‘ENTITY’) {
   customerId = recid;
   }

   if (!isEmpty(customerId)) {
   try {
   // Look up the additional emails from the customer record
   var additionalEmails = search.lookupFields({
   type: search.Type.CUSTOMER,
   id: customerId,
   columns: [‘custentity_add_emails’]
   });

   var emailsString = additionalEmails.custentity_add_emails;

   if (!isEmpty(emailsString)) {
   // Split the email string by multiple possible separators[ people struggle with simple instructions:-(]
   var regex = /\s*[,;]\s*/;
   var emailList = emailsString.split(regex);

   // Add each email to the CC list like you would for a line item
   var line = 0;
   emailList.forEach((email) => {
   email = email.trim();
   if (email) {
   try {
   REC.insertLine({ sublistId: ‘otherrecipientslist’, line: line });
   REC.setSublistValue({ sublistId: ‘otherrecipientslist’, fieldId: ’email’, line: line, value: email });
   REC.setSublistValue({ sublistId: ‘otherrecipientslist’, fieldId: ‘cc’, line: line, value: true });
   line++;
   } catch (emailError) {
   // Continue with the next email
   }
   }
   });
   }
   } catch (emailsError) {
   // Error processing additional emails – continue
   }
   *******************************
   Part II for the file attachment

   function attachFilesToEmail(REC, rootRecType, recid) {
   if (rootRecType != ‘TRANSACTION’ || isEmpty(recid)) return;

   try {
   /* Search for files attached to a transaction and get the file id,
   in my case its the same transaction the message object is on
   can be modified for any record really q*/
   var fileSearch = search.create({
   type: ‘transaction’,
   filters: [
   [‘mainline’, ‘is’, ‘T’],
   ‘AND’,
   [‘internalid’, ‘anyof’, recid]
   ],
   columns: [
   search.createColumn({ name: ‘formulanumeric’, formula: “{file.internalid}” }),
   search.createColumn({ name: ‘formulatext’, formula: “{file.name}” })
   ]
   });

   var searchResults = fileSearch.run().getRange({ start: 0, end: 100 }); // you’re not attaching 100 files, right?

   if (searchResults && searchResults.length > 0) {
   var attachmentLine = 0;

   // Add each file as an attachment to the email
   searchResults.forEach(function(result) {
   try {
   var fileId = result.getValue({ name: ‘formulanumeric’, formula: “{file.internalid}” });
   var fileName = result.getValue({ name: ‘formulatext’, formula: “{file.name}” });

   if (fileId) {
   REC.insertLine({ sublistId: ‘mediaitem’, line: attachmentLine }); // attach to mediaitem sublist just like any other line item
   REC.setSublistValue({ sublistId: ‘mediaitem’, fieldId: ‘mediaitem’, line: attachmentLine, value: fileId });
   attachmentLine++;
   }
   } catch (fileErr) {
   // Continue with next file
   }
   });
   }
   } catch (searchError) {
   // Error searching for attached files – continue
   }
   }

   Reply