Hi Neethu,
That's correct.
1) Have business rule after insert on RITM table which runs only for that particular Catalog Item.
2) Have a data source, transform map and field map created as usual. coalesce etc will be present
3) Have scheduled import created with this data source with active= false, run as administrator since it will be triggered from script. In left nav type Scheduled Imports and create new
4) in the business rule condition check whether the RITM has attachment then only run the business rule and have following script
Business rule condition:
current.hasAttachments()
//extra check you can have is whether it is csv or xls based on data source attachment file type
Business rule script:
var dataSourceSysId = ''; // sys_id of the data source you created in step 2
var schImp_GR = new GlideRecord('scheduled_import_set');
schImp_GR.addQuery('data_source',dataSourceSysId);
schImp_GR.query();
if(schImp_GR.next()){
gs.executeNow(schImp_GR); // use this if it is in scoped app
//SncTriggerSynchronizer.executeNow(schImp_GR); // if in non-scope app i.e. global
// the above 2 lines will start the import process, etc automatically
}
Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.
Thanks
Ankur
Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
