ServiceNow table maps are used to map and/or transform outbound ServiceNow field data for the record being dynamic shared or bulk shared. If the field names of the record being shared out from ServiceNow need to be modified, or if the value of one or more fields needs to be transformed, you can create an outbound table map to modify the fields for your integration.
Go to Perspectium > Control and Configuration > Table Maps to access.
Outbound table maps
Outbound table maps are used to map and/or transform the outbound ServiceNow field data for the replicated records. You should use Outbound table maps if the field names of the replicated record from ServiceNow need to be modified, or if the value of one or more fields needs to be transformed. Once the Outbound table map is configured, it can be assigned in a share (such as a bulk share) by selecting it in the Table Map field on corresponding forms.
Outbound table maps are utilized and packaged per integration.
When using a table map in a share (such as a bulk share, including conditional shares), the Sharing setup will default to Share the table records only. If you were to use a Sharing setup of Share all table records and child records with a table map, this will cause duplicate records for a parent and its child records to be sent out since table maps will map all the records to the same target table name.
As well, if you are using conditional shares, the Table Map feature will only appear in the conditional share and not the parent share (such as the parent bulk share).
Inbound table maps
Inbound table maps direct messages to an import set table where a ServiceNow transform map will do the processing. These configurations are used to map inbound replication messages to a ServiceNow table based on the Topic and Type specified in the message. For example, a record coming in with the topic=siam and the type=common_incident can be mapped to the u_psp_common_incident import set table. The corresponding transform map will then process the message appropriately.
Create a ServiceNow table map
- In your ServiceNow instance, go to Perspectium > Control and Configuration > Table Maps.
- Click New.
- Select the table map direction (Outbound or Inbound) from the Direction dropdown. The fields available will change depending on whether you choose Outbound or Inbound.
- Complete the required fields:
- Enter a Name
- (For Outbound table maps only) Select the table you want to create table map for from the Source table dropdown
- (For Outbound table maps only) Enter the name of the target table in the Target Table Name field (e.g. common_incident)
- (For Inbound table maps only) Select the target table to save records into using the Target Table dropdown
- Optionally,
- (For Outbound table maps only) Select the Preview With option to select a record from the source table and preview what the record will look like when shared out using the table map
- (For Inbound table maps only) Specify an Attributes contains value that will be used in combination with the Topic and Type fields to find this table map for directing inbound messages. This is useful if you have incoming messages with the same topic and type that should go to different import set tables. You can use the Attributes contains values to additionally key off a value in the attributes field in the incoming message to direct the message to this table map's target table.
- Click Submit.
Add a table map to your ServiceNow share
ServiceNow table maps are typically used to handle the mapping of fields in certain ServiceNow tables as data is shared out of your instance. For example, you can include a table map as part of your ServiceNow bulk share (or its conditional share) to help with field mappings and data transformation.
Notes:
- If a table map is set, records with an attachment or message size greater than 5 MB will not be shared out due to ServiceNow platform limitations with how large one particular record can be.
Prerequisites:
- Create a bulk share.
Instructions:
- In your sharing ServiceNow instance, go to Perspectium > Perspectium Core > Shares > Bulk Share.
- Click View Bulk Shares.
- From the available shares, click on the one that you want to add a table map for.
- Click the search icon next to Table map. If you are on the Standard view of the dynamic share form, you will find the Table Map option on the Data Enrichment tab.
- If adding a table map to a Conditional Share, open up the conditional share and select the Use Table Map option first.
- If adding a table map to a Conditional Share, open up the conditional share and select the Use Table Map option first.
- From the resulting list, select the table map you want to add.
- Click Update (top right).