Is there a way to insert into the sys_attachment table directly (from say, a script) ?

[tobrien]

Hi,

I see that you can add a new attachment record using the GlideSysAttachment.write()...

But is it possible to insert directly into that table from a script include?

The sys_attachment table does not seem to have a "content" column.

e.g. ==>

var sRec = new GlideRecord('sys_attachment');

sRec.initialize();

sRec.setValue('filename', 'my.csv');

sRec.setValue('sizebytes', {the size of the csv file});

sRec.setValue( {where ever the content is}, {the csv data});

sRec.insert();

[vkachineni]

FillClientDocumentFileAttachments();
function FillClientDocumentFileAttachments()
{
	var base64dataCSV = 'VGhpcyBpcyBhIFRlc3QgQ1NWIGZpbGUNCg==';  //CSV as BASE64
	var decodedBytesCSV = GlideStringUtil.base64DecodeAsBytes(base64dataCSV);

	var attachGR = new GlideRecord('sys_attachment');
	attachGR.addQuery('table_name', "table_name");
	attachGR.addQuery('table_sys_id', "table_sys_id");
	attachGR.query();		
	if(!attachGR.next())
	{
		var sa = new GlideSysAttachment();
		sa.write(clientDocFileGR, clientDocFileGR.u_file_name, 'application/csv',  decodedBytesCSV);		
	}
	gs.info("Completed adding attachments.");
}

[tobrien]

I credit all of you with workable solutions, and the only reason I marked Mr. Singh as "CORRECT" is because of its' succinctness.

Thanks!