The GlideImportSetTransformMap API provides methods to create transform maps and transform entries.

You can use the GlideImportSetTransformMap methods in global and scoped scripts. Use the sn_impex namespace identifier to create a GlideImportSetTransformMap object.

GlideImportSetTransformMap - GlideImportSetTransformMap(String transformMapName, String importSetTableName, String targetTableName)

Instantiates a GlideImportSetTransformMap object.

Table 1. Parameters
Name Type Description
transformMapName String Name of the map.
importSetTableName String Name of the Import Set table.
targetTableName String Name of the target table.

Example

var transformMap = new sn_impex.GlideImportSetTransformMap("temp user map name", importSetTableName, targetTableName);

GlideImportSetTransformMap - addDateTimeTransformEntry(String sourceColumn, String targetColumn, Boolean coalesce, String dateTimeFormat)

Add a GlideDateTime transform entry to a transform map.

Table 2. Parameters
NameTypeDescription
targetColumn String Target column from target table to transform to.
coalesce Boolean
Optional. Flag that indicates whether to insert the record into the target table
  • true: If true and target table contains a record with the same value in this field, the record is updated, that is, not inserted.
  • false: Default. Record is inserted into the target table.
sourceColumn String Source column from Import Set table to transform from.
dateTimeFormat String Optional. GlideDateTime format of the transform, for example, yyyy-MM-dd HH:mm:ss. If empty, the default value is the system date time format.
Table 3. Returns
Type Description
void

Example

var transformMap = new sn_impex.GlideImportSetTransformMap("temp user map name", importSetTableName, targetTableName,);
transformMap.addDateTimeTransformEntry("u_start date", "first day", true, "yyyy-MM-dd HH:mm:ss");
var transformMapId = transformMap.create();

GlideImportSetTransformMap - addTransformEntry(String sourceColumn, String targetColumn, Boolean coalesce)

Adds a string transform entry to a transform map.

Table 4. Parameters
Name Type Description
targetColumn String Source column from Import Set table to transform from.
coalesce String Target column from target table to transform to.
sourceColumn Boolean
Optional. Flag that indicates whether to insert the record into the target table
  • true: If true and target table contains a record with the same value in this field, the record is updated, that is, not inserted.
  • false: Default. Record is inserted into the target table.
Table 5. Returns
Type Description
void

Example

var transformMap = new sn_impex.GlideImportSetTransformMap("temp user map name", importSetTableName, targetTableName); 
transformMap.addTransformEntry("first_name", "first_name", true);
transformMap.addTransformEntry("last_name", "last_name", false);
transformMap.addTransformEntry("age", "age", false); 
var transformMapId = transformMap.create();

GlideImportSetTransformMap - create()

Creates a new transform map.

Note: To create a transform map you must have defined at least one transform entry using either addDateTimeTransformEntry() or addTransformEntry().
Table 6. Parameters
Name Type Description
None
Table 7. Returns
Type Description
String The sys_id of the created transform map.

Example

var transformMap = new sn_impex.GlideImportSetTransformMap("temp user map name", importSetTableName, targetTableName);
transformMap.addTransformEntry("u_first_name", "first_name");
var transformMapId = transformMap.create();