Trigger Import set from business rule
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-28-2017 05:22 AM
I have a scoped application 'itfm' which has a table say 'itfm_table'. whenever a record is inserted in this table, i need to trigger an import set that imports the data in an excel file into some other table which is currently in global scope. The question is :
1> How to bring a servicenow scoped application into my personal scope which has another application.
2> How to trigger an import set and associated transform maps on insert of a record in my scoped application. Can a After Insert business rule trigger an import set. do i need to create the import set in my personal scoped application to trigger that from a business rule in my scoped table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-28-2017 06:21 AM
I'm not seeing anything in your script you posted why you would get two records.
As for the SncTriggerSynchronizer... try preceding it with 'global.' to indicate that it comes from the global scope.
global.SncTriggerSynchronizer.executeNow(grSIS);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-28-2017 06:42 AM
I wanted to raise a red flag on one choice. Updating a system property like this. How often are you expecting this to run? Each time a property is updated, the entire cache of system properties is refreshed. This can cause major performance issues up to bringing down the instance if run often enough. What is the requirement driving updating the system property, since I don't see it used further in your code.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-28-2017 06:45 AM
Good point. Thanks for bringing that up Chris! I totally missed it.
