Transform through API script

[Sagaya]

Hi ,

I have a requirement to transfer the data from import set table to target table through OOB API . So created a action step in flow designer and trying to transform data through GlideImportSetTransformer() API , however it is not working and no error in import set also . Please find the below code and help to fix this issue.

Seems GlideImportSetTransformer() API does not transfer data from importset table to target table.

/** Create a Trasnform map**/

var transformMapName='TFName';

var importSetTableName='u_temp_tf_name';

var targetTableName='incident';

var transformMap = new sn_impex.GlideImportSetTransformMap(transformMapName, importSetTableName, targetTableName); 

transformMap.addTransformEntry("number", "number", true);

var transformMapId = transformMap.create();}

/**Execute an Import Set Transform using the GlideImportSetTransformer  **/

var transformMapId = '102fe6de28b6399065306d8075143eb7';

var importSet = new GlideRecord('sys_import_set');

importSet.short_description = 'Import set for incident';

importSet.table_name = importSetTableName;

var importSetID = importSet.insert();

gs.print("importSetID="+importSetID);

var importLog = new GlideImportLog();

var importSetRun = new GlideImportSetRun(importSetID);

var transformer = new GlideImportSetTransformer();

transformer.setLogger(importLog);

transformer.setImportSetID(importSetID);

transformer.setMapID(transformMapId);

transformer.setImportSetRun(importSetRun);

transformer.setSyncImport(true);

transformer.transformAllMaps(importSet);

var importSetRunvalue = transformer.getImportSetRun();

gs.print("importSetRunvalue="+importSetRunvalue);

var importRunSysId = importLog.getImportRunHistory();

gs.print("importRunSysId="+importRunSysId);

if(transformer.isError()) {

gs.error('Error executing the transform');

}

output  :

 Regards,

Rajan.

[DanielCordick]

is there a reason you can use a transform map? seems like your trying to recreate the wheel. this may be something to push back on

[Sagaya]

Hi DC ,

Due to my requirement, i need to configure transform map in flow designer action step and need to fix why GlideImportSetTransformer() does not transform data from importset table to target table.  

Regards,

Rajan.