Scheduled data import scripting options

Multiple JavaScript objects are available in the Scheduled Data Import Pre script and Post script fields.

Table 1. Data import scripting options
Object Description Example
cancel Set this object to true to stop the import action. Use the Pre script field to evaluate the conditions of the import and determine whether to cancel the import process. To cancel the import process, use the following call:
cancel = true;
import_set Get the GlideRecord object for the new import set. This variable allows you to query the following columns from the sys_import_set table:
  • number
  • sys_id
  • state
  • table_name
If you want to use information from the import set, you can specify one of the properties of the import_set variable.
var x = import_set.number;
data_source GlideRecord of the data source to be used for the scheduled import. Typically, you define the data source with the Scheduled Data Import record. If you want to access this data source or modify the data source in certain conditions, you can use the following.
data_source.import_set_table_name = 'new_set_from_scheduler';