Skip to content

AWS S3 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 functions makes data mapping on Connect iPaaS a breeze for business users who are already well versed with Microsoft Excel formulas.

Example Scenario with AWS S3 Trigger

In the example workflow, shown below, AWS S3 is the trigger application. You can access the following attributes of AWS S3 "Object created" event in any application actions while designing your workflow.

  • Object Name Extension - Extension of the object. For example pdf, txt etc.
  • Object Creation Time - Time when the object was created
  • Object Name Without Extension - File name without extension. For example, if an object test.txt is created or deleted in the bucket. This attribute will map test.
  • Object Size - Size of the object in bytes.

  • Attachments - One or more attachments received from the trigger event. You can also map individual attributes of the attachment like File Name, Mime Type, or File Size.

Data Mapping on AWS S3 application

Figure 1. Data Mapping on AWS S3 Application

As shown in the Figure above, we are mapping parameters from the AWS S3 "Object Created" trigger to the AWS S3 action of uploading the object. We can map the fields from the trigger data. In this example, Object data is built using a text string, trigger data, and the excel function NOW().