Data Import and Management Flashcards

Which import set transform state indicates the row was successfully written to the target table?

Answer: Transformed

A state of 'Transformed' on an import set row means the row was successfully processed and written to the target table.

When loading data from an Excel file, ServiceNow uses the first row as:

Answer: Column headers that become import set field names

ServiceNow reads the first row of an Excel file as column headers, which become the field names in the auto-generated import set table.

Which role is required to create and manage Transform Maps in ServiceNow?

Answer: admin or import_transformer

The admin role or the import_transformer role grants the ability to create and configure Transform Maps.

What is the purpose of the 'onComplete' script in a Transform Map?

Answer: To run cleanup or post-processing logic after all rows have been transformed

The onComplete script runs once after all rows in the import set have been processed, useful for sending notifications or running post-import logic.

A 'Skipped' state on an import set row most commonly means:

Answer: The coalesce field found a match but 'Force update' was disabled and no change was detected

Rows are skipped when a matching record exists in the target but the incoming data is identical to the existing data, so no update is needed.

Which ServiceNow table stores the configuration records for Import Set Data Sources?

Answer: sys_data_source

The sys_data_source table stores all Import Set Data Source configurations including connection details, type, and file format settings.

When importing data via a SOAP web service data source, ServiceNow communicates with the external system using:

Answer: XML-based SOAP envelopes over HTTP/HTTPS

SOAP web service data sources use XML-formatted SOAP envelopes to request and receive data from external web services.