Skip to content

Magento2x 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 a breeze for business users who are already well versed with Microsoft Excel formulas.

Example Scenario with Magento 2.x Trigger

In the example workflow, Magento is the trigger application. You can access the following attributes of Magento event in any of the application actions while designing your workflow for Order entity:

  • FirstName - Customer first name.
  • Email - Customer email address.
  • LastName - Customer last name.
  • Total Paid - Total amount paid.
  • Refunded - Refunded amount.
  • Total Due - Total amount due.
  • Total Item Count - Total number of item.
  • Total Invoiced - Total invoiced amount.
  • Entity Id - Order ID.
  • Customer Id - Customer ID.

Data Mapping on Magento application

Figure 1. Data Mapping on Magento Application

As shown in the Figure above, we are mapping parameters from the Magento "Object Created" trigger to the Business Central of creating a new Sales Orders record. In this example, Customer Number of the sales order is constructed using Customer Id, Customer Name is constructed using FirstName and LastName, Total Amount Including Tax is constructed using "Total Paid" and Email is constructed using the Email attribute of the Magento 2.x Order entity.