How to insert an image into catalog item table using script

[PraveenGoud1]

Hi Team,

I am trying to attach an image which is stored in servicenow database from workflow while inserting catalog item.

I am not sure how to attach an image using script. Please can anyone help me on this.

Thanks in Advance.

[Jace Benson]

What have you tried?

[dvp]

Here is the code that populates the picture field on new catalog item with attachment on the submited item

var gr = new GlideRecord('sys_attachment');
gr.addQuery('table_sys_id', current.sys_id);
gr.query();

while(gr.next()){

    gr.file_name = 'picture';
    gr.table_name = 'ZZ_YYsc_cat_item';
    gr.table_sys_id = sysid; //sysid is the sys_id of the newly created catalog item
    gr.update();
    
}

[Ankur Bawiskar]

Hi Praveen,

If you want to do this using workflow then you can do this once RITM is created. what following script does is searches for the attachment record for that image in sys_attachment table with that table name and sys id and then creates fresh record in sys_attachment table and copies same data. along with this it also creates entry in sys_attachment_doc table which holds meta data for the image file. the following script is tested and is working fine. just replace the proper values for image record sys id and RITM sys id highlighted in bold

script:

var gr = new GlideRecord('sys_attachment');

gr.addQuery('table_name', 'ZZ_YYdb_image');

gr.addQuery('table_sys_id','<sysIdOfImageRecord>'); // search for the image in db_image table and add the record sys id here

gr.query();

if(gr.next()){

var gr1 = new GlideRecord('sys_attachment');

gr1.initialize();

gr1.file_name = gr.file_name; //replace the image field name
gr1.content_type = gr.content_type;
gr1.compressed = gr.compressed;
gr1.table_name = 'sc_req_item';
gr1.size_bytes = gr.size_bytes;
gr1.size_compressed = gr.size_compressed;
gr1.table_sys_id = current.sys_id; // ritm sys id
var attRec = gr1.insert();

}

var attDoc = new GlideRecord('sys_attachment_doc');
attDoc.addQuery('sys_attachment', gr.sys_id);
attDoc.query();
while(attDoc.next()){
var attDocCopy = new GlideRecord('sys_attachment_doc');
attDocCopy.initialize();
attDocCopy.sys_attachment = attRec;
attDocCopy.position = attDoc.position;
attDocCopy.length = attDoc.length;
attDocCopy.data = attDoc.data;
attDocCopy.insert();
}

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Ankur Bawiskar]

Hi Praveen,

Any update on this?
Can you mark my answer as correct, helpful if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.

Regards
Ankur