Validate data using JavaScript

Configure validation transformation

Validation, using JavaScript, is available under MAPPING/ Additional Transformations/ Validate. 

MAPPING

MAPPING/ Additional Transformations/ Validate

Examples

Generate an exception

The Flow execution will stop, and an exception will be generated.

// generate an exception when postal_code or phone are empty 
// or postal_code is not a number

var postalCode = dataSet.getFieldValue(currentRow, 'postal_code');

var phone = dataSet.getFieldValue(currentRow, 'phone');

if (Utils.isNothing(postalCode) || Utils.isNothing(postalCode) ||
    !Utils.isNumber(postalCode)) {
    value = TaskResult.HALT;
} else {
    value = TaskResult.CONTINUE; 
}

Reject the dataset

The source-to-destination transformation will be skipped. No rows will be loaded into the destination.

// skip the transfromation when postal_code or phone are empty 
// or postal_code is not a number

var postalCode = dataSet.getFieldValue(currentRow, 'postal_code');

var phone = dataSet.getFieldValue(currentRow, 'phone');

if (Utils.isNothing(postalCode) || Utils.isNothing(postalCode) ||
 !Utils.isNumber(postalCode)) {
   value = TaskResult.STOP;
} else {
   value = TaskResult.CONTINUE; 
}

Reject the current row

The current row will be skipped (not loaded in destination).

// skip the current row when postal_code or phone are empty 
// or postal_code is not a number

var postalCode = dataSet.getFieldValue(currentRow, 'postal_code');

var phone = dataSet.getFieldValue(currentRow, 'phone');

if (Utils.isNothing(postalCode) || Utils.isNothing(postalCode) ||
 !Utils.isNumber(postalCode)) {   
   value = TaskResult.REJECT;
} else {
   value = TaskResult.CONTINUE; 
}

Available variables

The following variables can be referenced by name from JavaScript and Python code: