Page History

(Optional) Correlate when a Zendesk ticket is first created in ServiceNow

Since the transform map primarily handles corresponding actions in ServiceNow for actions initiated in Zendesk (i.e. when a user creates a ticket in Zendesk, the transform map will handle actually creating the ticket in ServiceNow after receiving it from the meshlet and MBS), ServiceNow can send back a .correlate message so Zendesk knows what the unique identifier (sys_id) of the record is in ServiceNow.

In this case, you would create an onAfter transform script in the PSP Common Incident to Incident transform map with the following code to send back the .correlate message that the meshlet can process into Zendesk and save into the Correlation ID custom field:  Check the Use source script checkbox, then add the following in the Source script:

answer = // Correlate sharing instance record
(function transformEntryrunTransformScript(source, map, log, target /*undefined onStart*/ ) {
	if var table_name = "incident";  // table being shared
	var queue_name = "psp.in.meshlet.zendesk.incident.instance_name"; // queue that meshlet reads messages from
	
	if(source.u_assigned_to_email.indexOf('<') == -1)correlation_id != ""){
		return;
	}
	
	var queueGR = new GlideRecord("u_psp_queues");
	var startIndexqueue = source.u_assigned_to_email.indexOf('<') + 1"";
	queueGR.addQuery("u_name", queue_name);
	queueGR.query();
	if (!queueGR.next()){
		return;
	}
	
	queue = queueGR.sys_id;
	var endIndexshareGR = new GlideRecord("psp_replicate_conf");
	shareGR.addQuery("table_name", table_name);
	shareGR.addQuery("u_target_queue", queue);
	shareGR.query();
	if (!shareGR.next()){
		return;
	}
	
	var tableGR = new GlideRecord(table_name);
	tableGR.addQuery("sys_id", target.sys_id);
	tableGR.query();
	if (tableGR.next()){
		var pspR = new PerspectiumReplicator();
		pspR.shareRecord(tableGR, table_name, "correlate", shareGR.sys_id);
	}
})(source, map, log, target);

 NOTE: By default the Zendesk meshlet will read any information in the <comments> field of the Common Incident sent back as part of the .correlate message when updating the Zendesk ticket with the ServiceNow sys_id. If you prefer to specify a default comment when no comments are entered, you can enter a default message to use in the defaultCorrelateResponse meshlet configuration.

(Optional) Add a comment when a ticket is successfully created in Zendesk

When the  meshlet creates a new ticket in Zendesk, it will send back a .correlate message that ServiceNow can consume and add a comment to the incident. For example, you can create an onAfter transform script on the PSP Common Incident to Incident transform map with the following code to log the ID of the record as created in Zendesk:  

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

	// Add your code here
	if (source.u_action == 'correlate') {
		var igr = new GlideRecord('incident');
		igr.query('sys_id', source.u_correlation_id);
		if (igr source.u_assigned_to_email.indexOf('>');
	var email = source.u_assigned_to_email.substring(startIndex, endIndex);
	var sgr = new GlideRecord('sys_user');
	sgr.addNotNullQuery('email');
	sgr.addQuery('email', email);
	sgr.query();
	if (sgr.next()) {
			return sgr.igr.comments.setJournalEntry('Record successfully created in Zendesk with ID ' + source.u_sys_id);
			igr.update();
		}
	return "";
}
})(source);

Click Update to save your changes.

Image Removed

, map, log, target);