Conditional logic in transformations in Jitterbit Integration Studio

Introduction

Creating a condition on a target node is called conditional mapping. This feature extends basic mapping concepts by adding business logic to control when data is processed. Conditional mapping lets you specify whether a source record being processed should be output to the target based on a defined condition. The condition determines (yes or no) whether the record is mapped. As part of that determination, you can include logic to set what values are used in the mapping. For example, you might use a record only if the size of a text field is less than a specified maximum.

Important notes

When you use a condition script on a target node, be aware of these points:

• You can add conditions to target nodes with a cardinality of [0+], [0, 1], or [1+] on any structure level. If a node is required ([1+]) and the condition evaluates to false, the operation may fail at runtime.

• Target nodes that can have a condition can have only one condition for each node. All logic for the condition must reside in that condition.

• The condition script is always evaluated before any target fields are evaluated. This means that all logic for creating or determining the values for those target fields must be in the condition script if the condition script requires those values to complete its determination.

• If multiple conditions are present, they are evaluated in the order from outer node to inner node. If they are on the same level, then they are evaluated in the order from top to bottom.

Add a condition

You can add conditions as scripts on target nodes with a cardinality of [0+], [0, 1], or [1+]. Hover over the node name and click to open the node actions menu. From the menu, select Add condition to node.

When you select this option, the editable script area on the target node opens.

The contents of the script specify the condition for generating the record. A condition must return a true (1) or false (0) value. It can contain other logic, and a side effect of that logic can be to set the value of other nodes in the transformation.

When a conditional script is present, a condition icon is displayed on the target node. When a source object or variable is used in a conditional script, mapping lines are connected to the node, and the count of mappings includes nodes that the source field or variable is referenced in:

Example 1

The script below requires that the source object code evaluates to true for the record to be processed. If code evaluates to false, then the node is skipped and this particular record is not processed:

Example 2

You can also use the == equals operator as shorthand to write condition scripts. For example, you could write the same condition used in Example 1 like this:

Example 3

To set a condition such that a record is used only if a flag to publish it was set, you could use a script such as this:

bool(Publish_To_Community__c) == true

Example 4

To set a condition such that a record is used only if it is less than a maximum size, assuming that the article text is in the element json$results$item.body$view$value$, you could use a script such as this:

pass = true;

// Log article size
$articleDetailsSize = Length(json$results$item.body$view$value$);
WriteToOperationLog('Current article:' +
    json$start$ + ' articleDetailsSize:' + $articleDetailsSize);

// Checks if the article size > $MaxArticleDetailSize;
// if so, the article is ignored
if($articleDetailsSize > $MaxArticleDetailSize,
    WriteToOperationLog("Ignoring Id " + json$results$item.id$ +
        " as too large (" + $articleDetailsSize + ")");
    pass = false;
);

pass;

Example 5

A condition script can also set values used in other nodes. Building off of Example 4, the condition node can, as part of its logic, set the intended contents of a field to a global variable:

...
$articleDetails = Replace(json$results$item.body$view$value$,
                          'href="/','href="https://example.com/');
...

The global variable is then used to set the value in the desired target field Article_Details__c:

$articleDetails;

Managing conditions

You can edit or remove a condition by clicking on the condition icon displayed to the right of the target node. You can also hover over the node name and click to open the node actions menu.