Hi All,
I am trying the workflow from on complete transfrom map script currently what is happening it taking all record from the import set table hold. it is not taking from the current import set table record only why this is happening can any one help me with this below is my scripts--
(function runTransformScript(source, map, log, target) {
gs.info("Transform Map onComplete script triggered");
try {
var importSetId = map.getImportSetID();
var wflw = new Workflow();
var wfId = wflw.getWorkflowFromName('END POINT TO API');
if (wfId) {
var wfInputs = {
import_set_id: importSetId
};
var started = wflw.startFlow(wfId, target, wfInputs); /
gs.info("Workflow startFlow result: " + started);
if (!started) {
gs.info("Trying startFlowRetroactive...");
var retroStarted = wflw.startFlowRetroactive(wfId, target, wfInputs);
gs.info("Workflow startFlowRetroactive result: " + retroStarted);
}
} else {
gs.error("Workflow 'END POINT TO API' not found.");
}
} catch (e) {
gs.error("Error starting workflow: " + e.message);
}
})(source, map, log, target);
here is runscript--
var importSetId = workflow.inputs.import_set_id;
if (!importSetId) {
gs.error("No import_set_id passed to workflow.");
}
var grendpoint = new GlideRecord('u_api_inventory_data_upload');
grendpoint.addQuery('import_set', importSetId);
grendpoint.query();
while (grendpoint.next()) {
try {
var grapi = new GlideRecord('cmdb_ci_api');
grapi.initialize();
grapi.name = grendpoint.u_api_name;
var newSysId = grapi.insert();
if (newSysId) {
gs.info("Inserted cmdb_ci_api record with sys_id: " + newSysId + " for API: " + grendpoint.u_api_name);
} else {
gs.warn("Failed to insert cmdb_ci_api record for API: " + grendpoint.u_api_name);
}
} catch (e) {
gs.error("Error inserting cmdb_ci_api record: " + e.message);
}
}
