Data Import and Management Flashcards

Which system property controls the maximum number of rows that can be loaded into an import set at one time?

Answer: glide.excel.max_rows

The glide.excel.max_rows property limits the number of rows ServiceNow will load from Excel and other file-based imports.

In a Transform Map field mapping, what does the 'Use source script' option allow?

Answer: Writing a script to derive the target value dynamically from source data

Enabling 'Use source script' lets you write JavaScript in the field map to compute or transform the value before writing it to the target field.

What is the role of the 'Import Set Row' table (sys_import_set_row) in ServiceNow?

Answer: It acts as the parent staging table for all import set records

sys_import_set_row is the base table extended by all import set (u_imp_*) staging tables to store imported rows.

Which transform map script field fires once per row BEFORE the row is transformed?

Answer: onBefore

The onBefore script runs once per row before transformation, allowing row-level validation or pre-processing.

When importing data via a REST data source in ServiceNow, the response is typically parsed using:

Answer: An XPath expression for XML or a JSONPath expression for JSON

ServiceNow uses XPath for XML REST responses and JSONPath expressions for JSON REST responses to extract records.

Which ServiceNow feature allows you to preview how a Transform Map will process a specific import set row before committing?

Answer: Test Transform

The 'Test Transform' option on a Transform Map lets you process a single row to verify mappings and scripts without affecting target data.

What does the import set state 'Error' indicate about an import set row?

Answer: The transform script encountered an error processing that row

An 'Error' state on an import set row means an exception occurred in the transform map scripts or field mapping for that specific row.