Hi Nirmala,
I think you cannot use global variables declared in onStart transform script to be used in the onBefore as per below link
https://hi.service-now.com/kb_view.do?sysparm_article=KB0676967
For your approach as all the imported records should have same value in Parent you can use below approach
1) use onComplete script so that it would run at the end when all transform happens
2) in that create a record in Table A
3) now query for all the target records from the import set table and update the field with the sys_id from step 2
Ensure you use setWorkflow(false) while updating to avoid triggering any business rule on Table B
Sample script below
(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {
var gr = new GlideRecord('TableA');
gr.initialize();
gr.u_name = false;
var qNumber =gr.insert();
var gr1 = new GlideRecord('import_set_table');
gr1.addQuery('sys_import_set', source.sys_import_set);
gr1.query();
while(gr1.next()){
var targetRecordSysId = gr1.sys_target_sys_id; // get the target record sys_id
var tableB = new GlideRecord('table B');
tableB.addQuery('sys_id', targetRecordSysId);
tableB.query();
if(tableB.next()){
tableB.<table_A_field> = qNumber;
tableB.setWorkflow(false);
tableB.update();
}
}
})(source, map, log, target);
Mark ā
Correct if this solves your issue and also mark š Helpful if you find my response worthy based on the impact.
Thanks
Ankur
Regards,
Ankur
āØ Certified Technical Architect || āØ 9x ServiceNow MVP || āØ ServiceNow Community Leader
