The Zurich release has arrived! Interested in new features and functionalities? Click here for more

How to copy attachment from sys_email to case record

mania
Tera Contributor

Hi,

 

I am trying the copy attachment from sys_email to case record so i havee used below code but not getting mapped.

Can anyone please let us know where i missed?

(function executeRule(current, previous /*null when async*/) {

    // Add your code here
    var inc = new GlideRecord("sys_email");
    if (inc.get(current.table_sys_id)) {
        var grTask = new GlideRecord("sn_customerservice_case");
        if (grTask.get(inc.instance)) {
            copyAttachmentToTask(grTask.sys_id);
        }
    }


    function copyAttachmentToTask(conceptSysId) {
        // Get record from sys_attachment table
        var sourceAttachment = new GlideRecord('sys_attachment');
        sourceAttachment.addQuery("sys_id", current.sys_id);
        sourceAttachment.query();
        sourceAttachment.next();

        // Get field values from retrieved sys_attachment record
        var fileName = sourceAttachment.getValue('file_name');
        var contentType = sourceAttachment.getValue('content_type');
        var sourceAttachmentSysId = sourceAttachment.getValue('sys_id');

        // Attach sys_attachment record content stream to test_table record
        var gsa = new GlideSysAttachment();
        gsa.writeContentStream(
            grTask,
            fileName,
            contentType,
            gsa.getContentStream(sourceAttachmentSysId));
    }

})(current, previous);

Thanks!

10 REPLIES 10

@Rafael Batistot 

Thanks for the reply!

I tried with your code but still not getting mapped.

Please help on this

Thanks!