Hi @Jean-Fran_ois A
I think this script should help you. It should create a CSV file (just edit the text variable with the content from your CSV file) and using ecc_agent_attachment and ecc_queue tables it will save that file in the /agent/export folder of your ServiceNow installation on the MID Server.
var d = new Date();
var filename = 'DummyFilename_' + d.getTime().toString() + '.csv';
var text = 'Column_1;Column_2;Column_3\n';
text += 'Lorem;ipsum;dolor\n';
text += 'sit;amet;consectetur';
var midServerAttachGR = new GlideRecord('ecc_agent_attachment');
midServerAttachGR.initialize();
midServerAttachGR.name = filename;
midServerAttachGR.short_description = filename;
var new_table_sys_id = midServerAttachGR.insert();
//Create file
var sa = new Attachment();
var attachmentId = sa.write('ecc_agent_attachment', new_table_sys_id, filename, 'text/csv', text);
var gr = new GlideRecord('sys_attachment');
gr.addQuery('table_sys_id', new_table_sys_id);
gr.query();
if (gr.next()) {
var ecc_queue = new GlideRecord("ecc_queue");
ecc_queue.initialize();
ecc_queue.agent = "mid.server.XXXXX"; //Put here your MID Server agent service name
ecc_queue.name = filename;
ecc_queue.queue = "output";
ecc_queue.topic = "StreamPipeline";
var xml = '<?xml version="1.0" encoding="UTF-8"?>';
xml += '<parameters>';
xml += '<parameter name="stream_relay_response_topic" value="ExportSetResult"/>';
xml += '<stream_relay_source attachment_sys_id="' + gr.sys_id + '" type="AttachmentSource"/>';
xml += '<stream_relay_transform attachment.table_sys_id="' + gr.table_sys_id + '" order="0" stream_relay_transfer_progress_interval="150" type="AttachmentProgressTransformer"/>';
xml += '<stream_relay_sink path="/' + filename + '" type="FileSink"/>';
xml += '</parameters>';
ecc_queue.payload = xml;
//Get SysID of new ECC Queue record
var ecc_sysid = ecc_queue.insert();
}
Hope this helps.
Regards,
Simone
