Skip to content

Data Types

Connect iPaaS Data Mapping and Transformation

Figure 1. Connect iPaaS Data Mapping and Transformation

Drag & Drop Fields

All the attributes which are available to an action application could be seen in the Trigger Data Panel which is placed on the rightmost side of the screen. You just need to drag & drop to map input fields of the Action. Please refer Figure 1. Look how we could use Dynamics data from the Trigger panel in ServiceNow actions.

These fields change depending on what trigger application you have added in your workflow.

For ex - if Outlook is a trigger application, then you will see From, Subject etc. as Trigger data in the panel.

Excel Style Functions

Connect iPaaS provides a really powerful set of features to apply complex formulas on data for transformation. Here are the set of functions that are available.

  • Simple Math Operations ( + , - , * , / , ( , ) )
  • Trigonometry Functions (SIN, TAN, COS etc.)
  • Date Time Functions (Today, Now() etc.)
  • Statistical Functions (Average, Mean etc.)
  • Text Operations (Clean, Trim, Lowercase etc.)
  • Data Validation (ISTEXT, ISNUMBER etc.)
  • Financial Operations (FV, NPV, PV, etc.)
  • Logical Operations (OR, NOT etc)
  • Engineering Operations (BIN2DEX, HEX2DEC etc.)

Check out Figure 1. Look how we have used ABS() as a function in the input field of ServiceNow action.