Stay organized with collections Save and categorize content based on your preferences.

See the supported connectors for Application Integration.

Data mapping overview

The Data Mapping task lets you perform variable assignments within your Application Integration. You can use the Data Mapping functions to further transform the data into meaningful variables to make them accessible to other tasks or triggers in your integration.

With the Data Mapping task, you can:

  • Define variable mapping for single or nested variables.
  • Transform variables from one data type to another data type. The Data Mapping task lets you apply multiple mapping functions (including nested functions) to transform the variable data.
For information about configuring a Data Mapping task, see Data Mapping task.

Data Mapping Editor

The Data Mapping task provides a Data Mapping Editor for mapping the variables. The editor provides a visual overview of how the following elements are used in the mapping:

  • Variables: Displays the following types of variables that are available to the integration.
    • Inputs. Input variables of the integration.
    • Outputs. Output variables of the integration.
    • Local Variables. Variables that exist within the scope of the integration.

    If no variables are listed, click Add + to configure a new variable.

    Click (Expand) to expand each variable and view the available subfields of that variable. To search for any variable or its subfield from the available variable list, click (Search variables).
  • Input: Displays the source variables passed to the integration. You can specify a literal value or select a reference variable. To add an input variable to the data mapping, click and drag a variable from the Variables list to the Input field.
  • Output: Displays the corresponding target variables returned to the integration. To add an output variable, click and drag a variable from the Variables list to the Output field.

For more information about variables in Application Integration, see Using variables in Application Integration.

The following image shows a sample layout of the Data Mapping Editor:

image showing data mapping editor image showing data mapping editor

Mapping order

Mappings specified in the Data Mapping Editor are run in sequence from top to bottom. That is, if an input variable A is mapped to an output variable B in the first row, then the variable B is available for mapping in the subsequent rows.

Data mapping examples

The following images show examples of mappings in the Data Mapping Editor:

Mapping of string variables

image showing data mapping of string variables image showing data mapping of string variables

Mapping of integer and double variables

image showing data mapping of integer and double variables image showing data mapping of integer and double variables

Mapping of JSON, string, and integer variables

image showing data mapping of JSON, string, and integer variables image showing data mapping of JSON, string, and integer variables