Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Trigger Import set from business rule

amtg
Kilo Contributor

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.

7 REPLIES 7

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);


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.


Good point. Thanks for bringing that up Chris! I totally missed it.