A company needs to import data from a CSV file into the User table. The CSV includes fields for first name, last name, email, and department. However, the import fails because some email addresses are invalid. Which feature in ServiceNow can be used to prevent invalid emails from being imported?
Trap 1: Data Source configuration
A Data Source defines the source file and field mapping, not validation rules.
Trap 2: Import Set Row
Import Set Row is a staging record; validation occurs during transform.
Trap 3: Import Set Table API
The Import Set Table API is used to insert records programmatically, not for validation.
- A
Data Source configuration
Why wrong: A Data Source defines the source file and field mapping, not validation rules.
- B
Import Set Row
Why wrong: Import Set Row is a staging record; validation occurs during transform.
- C
Transform Map with condition scripts
Transform Maps can include condition scripts to skip or error on invalid data, such as invalid email addresses.
- D
Import Set Table API
Why wrong: The Import Set Table API is used to insert records programmatically, not for validation.