Validating data before importing through ServiceNow data source

Overview

ServiceNow supports multiple data sources types like file (data stored in excel, csv file), jdbc (data from databases like MySQL, SQL, Oracle, Sybase, DB2) and LDAP (data in LDAP Server through ports). Importing data from outside ServiceNow instance, there might be differences in actual data type and data fetched data (from outside ServiceNow). This situation mostly arise in file import.

Objective

Before importing data from outside, each and every row with column needs to be verified. This can be achieved by creating onBefore script of Transform Map. If any of the column is violating the data types from ServiceNow instance table, the row transformation can be stopped for the record by using below code continuing for next row transformation.

ignore = true;