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

In the example workflow shown below, Twilio is the trigger application. You can access the attributes of the Twilio trigger event in any of the actions while designing your workflow.

Figure 1. Data Mapping on Twilio Application

As shown in the Figure above, we are mapping parameters from Twilio "New SMS Received" trigger to the Smartsheet Action of adding a row to a sheet. In this workflow we add a new row to the selected sheet in Smartsheet based on data attributes from the Twilio trigger event.