MID server script include scripts - export csv file issue

Sagaya
Tera Expert

‎09-24-2023 02:24 AM

Hi All,

I am trying to send a file to MID server , following below steps and facing some issues.

Steps:

1. Initialize and create  "JavascriptProbe" in  scheduled job [scheduled script execution] 

2. Mid server script include :
     i ) Create and attached a file in MID server attachments.
     ii) Retrieve sys_attachment sys id.
     iii) create a xml for ECC payload, & pass filename , mid server attachment & sys_attachment sys id. 
    iv) create a ECC queue record by pass xml 
 
Issue :
1.  Unable to call mid server script include through JavascriptProbe in scheduled job.
Sample :
var jprobe = new JavascriptProbe(<mid server name>); 
jprobe.setName("Test"); 
jprobe.setJavascript("var req = new <mid server script include name>();req.<function name>()");
//Sample : jprobe.setJavascript("var req = new Test();req.testFunction()");
jprobe.addParameter("skip_sensor", true);
 jprobe.create();
 
2. For testing, implemented above step #2 in scheduled job and trying to transfer file to MID server , however  ECC Queue input log return "<result name=""><output> Transfer completed , xx bytes transferred "</output></result> and state = error. 
Note : Insert ECC queue topic ='StreamPipeline'
Sample  queue output payload :
 '<?xml version="1.0" encoding="UTF-8"?>' +'<parameters>' +
                    '<parameter name=\"stream_relay_response_topic\" value=\"ExportResult\"/>' +
                    '<stream_relay_source attachment_sys_id=\"' + attachment_sysId + '\" type=\"AttachmentSource\"/>' +
                    '<stream_relay_transform attachment.table_sys_id=\"' +ecc_agent_attachment_sysId + '\" order=\"0\" stream_relay_transfer_progress_interval=\"150\" type=\"AttachmentProgressTransformer\"/>' +
                    '<stream_relay_sink path=\"' +fileName+ '\" type=\"FileSink\"/>' +
                    '<parameter name=\"instance\" value=<INSTANCE NAME>>' +
                    '</parameters>';
 

Please help to provide your feedback to resolve these issues.

 
Regards
Sagaya
0 Helpfuls
  • 448 Views
1 REPLY 1

Danish Bhairag2
Tera Sage
Tera Sage

‎09-24-2023 03:10 AM

Hi @Sagaya,

 

When you say create & attach a file in sys attachment table what do u mean by that would please explain

 

Reason for asking that is , If the file contains data from servicenow table. You can try the Export Set functionality in servicenow to transfer file to mid server.

 

Link : https://www.google.com/url?sa=t&source=web&rct=j&opi=89978449&url=https://m.youtube.com/watch%3Fv%3D...

 

Please mark my respons helpful & accepted if it helps you resolve your issue.

 

Thanks,

Danish

 

 

0 Helpfuls