Skip to main content

ServiceNow Accessing the import_set api in a Transform Map Script

ServiceNow Accessing the import_set api in a Transform Map Script 


link: https://developer.servicenow.com/dev.do#!/reference/api/utah/rest/c_ImportSetAPI


how you could loop through target records in an onComplete t-map script:

(Change the staging table name to your import set table, or alternatively use sys_import_set)

var grST = new GlideRecord('x_cls_clear_skye_i_eon_hr_import');
grST.addEncodedQuery('sys_import_set.number=' + import_set.number);
grST.query();
while (grST.next()) {
gs.warn('row--' + grST.sys_target_sys_id);
}

Comments

Popular posts from this blog

Get URL Parameter - server side script (portal or classic UI)

Classic UI : var sURL_editparam = gs . action . getGlideURI (). getMap (). get ( ' sysparm_aparameter ' ); if ( sURL_editparam == 'true' ) { gs . addInfoMessage ( 'parameter passed ); } Portal : var sURL_editparam = $sp . getParameter ( " sysparm_aparameter " ); if ( sURL_editparam == 'true' ) { gs . addInfoMessage ( 'parameter passed ); }

URL link in addInfoMessage

var ga=new GlideAjax('gld_HR_ajax'); ga.addParam('sysparm_name', 'checkEmployeeNumber_hrProfile'); ga.addParam('sysparm_hrprofilenumber', g_form.getValue('number')); ga.addParam('sysparm_employeenumber', newValue); ga.getXMLAnswer(function(answer) { if (answer!='undefined' && answer!=''){ var navURL="<a style='text-decoration:underline;color:blue' href=hr_profile.do?sysparm_query=number=" + answer + ">" + answer + "</a><img width='3' src='images/s.gif'/>"; var sMsg='The employee number entered already exists on another HR Profile ' + navURL; //alert(sMsg); g_form.showErrorBox('employee_number', 'error - please check'); g_form.addInfoMessage(sMsg); } });