Skip to content

FinancialForce 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 FinancialForce Trigger

When FinancialForce is chosen as a trigger, you can use the attributes coming from the trigger in the "Trigger Data" area in your action to map data from trigger to Action fields.

As shown in the figure below, the workflow is to import the newly created or updated contact data from FinancialForce to HubSpot. The HubSpot fields "Email", "First Name" and "Last Name" are mapped directly from FinancialForce trigger data "Email", "Name - First Name" and "Name - Last Name".

Data Mapping on FinancialForce application

Figure 1. Data Mapping on FinancialForce Application