Entra ID Data Mapping

Data Mapping and Transformation is one of the powerful features of Connect iPaaS. When you create a workflow, certain attributes of your trigger application are available to the action application for data mapping and transformation. These attributes can be mapped to the specific attributes of the action application. This powerful capability not only allows field mapping but it also allows complex transformation using Excel-style functions to apply hundreds of formulas and operations. The choice of Excel-style function makes data mapping on Connect iPaaS a breeze for business users who are already well versed with Microsoft Excel formulas.

Example Scenario with Entra ID Trigger

In the example workflow, Entra ID is the trigger application. You can use attributes of user object for data mapping and transformation.

Figure 1. Data Mapping on Entra ID Application

As shown in Figure 1, we mapped parameters from Entra ID "User Created" trigger to the Salesforce Action of "Create Object" action. A new contact in Salesforce is configured using the Last Name, First Name, Email and Job Title attributes from Entra ID user object. You can also use Excel style functions in the mapping fields to perform logic based data mapping and transformation.