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.
