---
sourceDocument: Xanadu API Reference
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/api-reference

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu API Reference

ft:clusterId :

    - crapiref

bundleId :

    - crapiref

workflow :

    - Creator


---

# GlideImportSetTransformMap - Scoped, Global

# GlideImportSetTransformMap - Scoped, Global {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read

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.
**Related concepts**   

* [GlideImportLog](https://servicenow-prod.fluidtopics.net/qNWk7yJGC8yDqUP2uVapVg#GlideImportLogAPI "The GlideImportLog API provides methods to write log entries directly to the Import Log [import_log] table.")
* [GlideImportSetRun](https://servicenow-prod.fluidtopics.net/DuUdB5QjbqzVKw9vNXpdgQ#GlideImportSetRunAPI "The GlideImportSetRun API provides methods to creates an Import Set Run record which the GlideImportSetTransformer API can consume.")
* [GlideImportSetTable](https://servicenow-prod.fluidtopics.net/hcK8zq2yc77uOy_947gQmw#GlideImportSetTableAPI "The GlideImportSetTable API provides methods to create temporary Import Set tables.")
* [GlideImportSetTransformer](https://servicenow-prod.fluidtopics.net/58WsAVdtp1Sky5h7T0fw~Q#GlideImportSetTransformerAPI "The GlideImportSetTransformer API provides methods to create an Import Set Transformer object used to execute an Import Set Transform.")
* [GlideTransformLog](https://servicenow-prod.fluidtopics.net/40hOpIutNqObDYC_~w8L~w#GlideTransformLogAPI "The GlideTransformLog API provides methods to create a GlideTransformLog object to log messages to localhost logs.")

## GlideImportSetTransformMap - GlideImportSetTransformMap(String transformMapName, String
importSetTableName, String targetTableName) {#ariaid-title2}

Instantiates a GlideImportSetTransformMap object.
{#GImpSetTMp-GlImportSetTransformMap__table_nnl_z1f_vjb__entry__3}

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

{#GImpSetTMp-GlImportSetTransformMap__table_nnl_z1f_vjb}  

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

## GlideImportSetTransformMap - addDateTimeTransformEntry(String sourceColumn, String
targetColumn, Boolean coalesce, String dateTimeFormat) {#ariaid-title3}

Add a GlideDateTime transform entry to a transform map.
{#GImpSetTMp-addGDTTrnsEntry_S_S_B_S__table_mrr_n1f_vjb__entry__3}

| Name | Type | Description |
|-|-|-|
| 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. {#GImpSetTMp-addGDTTrnsEntry_S_S_B_S__ul_jq3_byx_bkb} |
| 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 2. Parameters]

{#GImpSetTMp-addGDTTrnsEntry_S_S_B_S__table_mrr_n1f_vjb} {#GImpSetTMp-addGDTTrnsEntry_S_S_B_S__table_nrr_n1f_vjb__entry__2}

| Type | Description |
|-|-|
| void |   |
[Table 3. Returns]

{#GImpSetTMp-addGDTTrnsEntry_S_S_B_S__table_nrr_n1f_vjb}  

    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) {#ariaid-title4}

Adds a string transform entry to a transform map.
{#GImpSetTMp-addTransformEntry_S_S_B__table_mrr_n1f_vjb__entry__3}

| 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. {#GImpSetTMp-addTransformEntry_S_S_B__ul_jq3_byx_bkb} |
[Table 4. Parameters]

{#GImpSetTMp-addTransformEntry_S_S_B__table_mrr_n1f_vjb} {#GImpSetTMp-addTransformEntry_S_S_B__table_nrr_n1f_vjb__entry__2}

| Type | Description |
|-|-|
| void |   |
[Table 5. Returns]

{#GImpSetTMp-addTransformEntry_S_S_B__table_nrr_n1f_vjb}  

    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() {#ariaid-title5}

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().
{#GImpSetTMp-create__table_k5g_xs2_vjb__entry__3}

| Name | Type | Description |
|-|-|-|
| None |   |   |
[Table 6. Parameters]

{#GImpSetTMp-create__table_k5g_xs2_vjb} {#GImpSetTMp-create__table_l5g_xs2_vjb__entry__2}

| Type | Description |
|-|-|
| String | The sys_id of the created transform map. |
[Table 7. Returns]

{#GImpSetTMp-create__table_l5g_xs2_vjb}  

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