- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-13-2020 10:40 AM
Hi,
I was trying to insert/update the record via JDBC probe into SQL database table from ServiceNow. Below script was working as expected
var mid = new GlideRecord("ecc_agent");
mid.addQuery('name','MID_Serverxxx');
mid.query();
if(mid.next()){
}
var data = new GlideRecord("sys_data_source");
data.addQuery('name','xxname of datasourcexx');
data.query();
if(data.next()){
}
var r1 = new JDBCProbe(mid.name);
r1.setDataSource(ds.sys_id);
jr1.setFunction("INSERT");
r1.setTable("xxdatabase tablexx");
r1.addParameter("skip_sensor","true");
r1.addField("Number", "INC7845129");
r1.addField("Contact", "david");
r1.create();
But when I updated to below script to insert the records from target table "Incident", tickets assigned to Service desk group. It throws me an error
r1.addField("Number", current.number);
r1.addField("Contact", current.caller);
r1.addField("opened",current.opened_at);
r1.create();
Thanks
Solved! Go to Solution.