Skip to content

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

Workday converts CSV data from directed CSV file into separate Object/Record which then can be used by subsequent action(s). Below are the figures describing the Data Mapping and Transformation.

In Figure 1, all of the CSV column headers along with its data type are defined in the Workday trigger. Inserting Column Header Fields in Workday

Figure 1. Inserting Column Header Fields in Workday

In Figure 2, you will see that the column headers inserted as triggers are present as objects which then can be mapped to action fields. Column Headers present as Object to be mapped

Figure 2. Column Headers present as Objects to be mapped