How to send attachment as a file not as a link

Samiksha2 · ‎10-10-2023

Hi All,

I have a requirement to add attachment in the emails.

I have created a mail script.

 addAtachments();

    function addAtachments() {
        var gr = new GlideRecord('sys_attachment');
        gr.addQuery('table_sys_id', current.sys_id);
        gr.orderByDesc('sys_created_on');
        gr.query();
        if (gr.next()) {
            template.print('Attachment: <a href="https://' +
                gs.getProperty('instance_name') +
                '.service-now.com/sys_attachment.do?sys_id=' +

                gr.sys_id + '">' + gr.file_name + '</a>\n');

        }

    }

But client wants to add attachment instead of link.

Please help in this.

Thanks,

Samiksha

Ankur Bawiskar · ‎10-10-2023

@Samiksha2

then to send latest file use this logic

1) create BR on sys_email table and use this script and it will send only latest file

I had used something similar in the past and it worked fine

After Insert on sys_email

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

	// Add your code here
	try{
		var att = new GlideRecord('sys_attachment');
		att.orderByDesc("sys_created_on");
		att.addQuery('file_name', fileName);
		att.addQuery('table_name', 'sc_req_item');
		att.addQuery('table_sys_id', current.instance);
		att.setLimit(1);
		att.query();
		if(att.next()){
			var rec = new GlideRecord('sys_email_attachment');
			rec.initialize();
			rec.attachment = att.sys_id;
			rec.file_name = att.file_name;
			rec.source = 'notification';
			rec.content_disposition = 'attachment';
			rec.email = current.sys_id;
			rec.insert();
		}
	}
	catch(ex){
		gs.info('Email exception' + ex);
	}

})(current, previous);

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Samiksha2 · ‎10-10-2023

Yes @Ankur Bawiskar .
I didnt get your points.😐

Ankur Bawiskar · ‎10-10-2023

@Samiksha2

Your original question was this which I already answered using BR on sys_email table

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Samiksha2 · ‎10-10-2023

@Ankur Bawiskar

Should I create another thread?

I will create another thread. Please help me to send attachment in Emails.

Samiksha2 · ‎10-10-2023

Hi @Ankur Bawiskar ,

I have created a new thread. Please check.

https://www.servicenow.com/community/now-platform-forum/whenever-attachment-attached-to-requested-it...

Thanks,

Sam

Tai Vu · ‎10-10-2023

Hi @Samiksha2

If the attachments from the triggering record, give the below checkbox a try.

In the other hand, we can copy the attachment to the email record once it get generated.

Let me know if it works for you.

Cheers,

Tai Vu