Web Services Guide

10.4.0

Back Next

Transformation Output Mapping

When you show the output mapping on the

Ports

view, you can define the output ports by mapping nodes from the operation output to the transformation output groups.

The web service returns the following hierarchy in a web service response message:

Response
   Orders
      Order  
         Key_Order
         Order_ID
         Order_Date
         Customer_ID
         Total_Qty
         Order_Details 
            Order_Detail 
               Product_ID
               Description
               Qty
               Status

The web service returns multiple orders. Order is a multiple-occurring node in the Orders level. For each order, the web service can return multiple order details. Order_Detail is a multiple-occurring node in the Order_Details level.

The Developer tool adds the Key_Order node in the user interface. You can map the key to output groups to define relationships between groups. For this example, the Order_ID is the primary key in Order, and it is the foreign key in Order_Details.

Create the following output groups in the

Ports

area:

Order
    Order_ID
    Order_Date
    Customer_ID
    Total_Qty

Order_Detail
    Order_ID
    Product_ID
    Description
    Qty
    Status

The Data Integration Service writes a row from the Order group whenever the value of Order_ID changes.

The Data Integration Service writes a row from the Order_Detail group whenever the values of Order_ID and Product_ID change.

Rename Saved Search

Table of Contents

Web Services Guide

Web Services Guide

Transformation Output Mapping

Transformation Output Mapping