After you define the resource, the Developer tool creates a resource mapping that contains a REST Output transformation. The REST Output transformation structure defines the response message that the web service returns to the client. Add a Read transformation and a Lookup transformation to the mapping.
The following image shows the resource mapping to create:
The mapping contains the following objects:
Read_Customer
The Read_Customer transformation reads the customer table. The transformation returns all the customer rows in the table.
Orders_Lookup
The Lookup transformation retrieves the orders for each customer.
Output
The REST Output transformation receives customer information from the Read_Customer transformation. It receives order information from the Orders_Lookup transformation. The REST Output transformation generates a hierarchical JSON file that lists the orders for each customer.
The resource mapping does not contain a Filter transformation to limit the customers to retrieve from the customer table.
The Data Integration Service filters the output data based on any filter in the client request.