SAP C4 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 while making API calls.
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 easy for business users who are already well versed with Microsoft Excel formulas.
Example Scenario with SAP C4 Trigger¶
In the example workflow shown below, SAP C4 is the trigger application and the object Contact is synced from SAP C4 to Salesforce. You can access all the available attributes of Contact iPaaS from SAP C4 and apply these in any of the fields in your Salesforce action while designing your workflow.
For Salesforce field Name-Last Name and Email, you can directly map the value from the SAP C4 field LastName and Email. For the Salesforce field Department, you can map multiple values from SAP C4, and Connect iPaaS will concatenate these values together.
