User Tools

Site Tools


siam_netsuite

ServiceNow to Netsuite Installation Configuration

The ServiceNow Netsuite SIAM Integration allows for replication of processes between ServiceNow and Netsuite.

The following are steps to install and configure the various components to implement the Netsuite SIAM integration for ServiceNow for the first time.

ServiceNow Installation and Configuration

1. Update Sets

To begin integrating Netsuite with your ServiceNow instance you must first install the Perspectium update sets. For the latest update sets, visit the Update Set Releases page and request the download links from support@perspectium.com. For more information on installing or updating the update sets, visit the first time install or updating pages.

The update sets should be installed in this order:

  1. Perspectium for ServiceNow update set.
  2. Perspectium Common Endpoint
  3. Perspectium Common Doc to integrate (ie. Common Incident, Common Change, etc.)

2. Dynamic Share and Shared Queue

After creating the subscribe queue, we will next create a dynamic share and shared queue. Visit the Dynamic share and Shared Queues pages for general information on both of these features.

Creating a shared queue:

  1. Click on the shared queues link under the Replicator tab in the Perspectium App
  2. Create a table with a shared queue named psp.in.siam.client.netsuite and pass in the respective credentials to the queue
  3. Click on this Shared Queue and verify that it is active.

To complete the configuration you will need:

  1. The SIAM endpoint url
  2. The Queue user for your SIAM endpoint.
  3. The Queue user password for your SIAM endpoint.


You will then need to enter this information into the Endpoint URL, Queue User, and Queue user password fields in the psp.in.siam.client.netsuite Shared queues. Once this is done click the update button in the top right of the shared queue view and these settings should be saved.

Creating Dynamic Shares

To create your own share for other tables click the Dynamic Shares module under the Perspectium application menu. Click the new button to move on to the dynamic share form. Select the desired table to share and select the active checkbox. Then choose your trigger conditions and move to the “Additional Settings” section of the form. Select the table map that contains Netsuite and the table name. Select the Target queue psp.in.siam.client.netsuite. See the dynamic share page for more information.

The following images are examples for configuring the ServiceNow incident table to share out to Netsuite incident object:

Below is the code for the “Before share script”:

if (psp_action == 'update' && current.correlation_id == ''){
	psp_action = 'deferred';
}

3. Outbound and Inbound table maps

The inbound table map will handle the conversion of Netsuite incidents into ServiceNow incidents and the outbound table map will handle the conversion of ServiceNow incidents into Netsuite incidents. Both table maps are key components for the SIAM integration. See table map page for more information.

Incident to Common Incident

The outbound table map requires specific fields to communicate from ServiceNow Incidents to the Netsuite incident. For each new table, a table map with the required outbound table map fields are necessary. The “@” designates to the attribute field instead of going directly to the common data format.

To properly share attachments, add the field map as shown below

source field:

${TM:psp_attachment;table_sys_id=$[GR:sys_id];netsuite_sent}

Attachments

The psp_attachment table map below will map attachments into the <attachments> field when an incident message is shared out

Below is the script for the “data” field value:

var sysEncodedAttachment = new GlideSysAttachment();  
var binData = sysEncodedAttachment.getBytes(current);  
var StringUtil = (typeof GlideStringUtil != 'undefined') ? new GlideStringUtil() : new Packages.com.glide.util.StringUtil();
answer = StringUtil.base64Encode(binData);

Transform Map

Depending on what field transformations the customer want you may need to create a new table map. To create a new a new table map do the following.

  1. Navigate to transform maps under System Import Sets with the filter navigator bar at the top left
  2. We will be creating a new map, so select new at the top left
  3. Follow the example of the pictures below and add more fields if necessary

After creating and defining the field values, we need to add a few transform scripts so that ServiceNow will know how to handle, update, and where to direct values and attachments from received messages in the inbound table.

Script for attachments make an onAfter script and put the following:

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {
	
	var attachments = new PerspectiumAttachment();
	attachments.addAttachments(source, target, "netsuite_sent");
	
})(source, map, log, target);
siam_netsuite.txt · Last modified: 2018/06/02 22:59 by paul