Configure the tXMLMap component for your GET
request.
Procedure
- Double-click the tXMLMap_2 component to open the Map Editor.
-
In the main :getMovieById table on the left, select the
movieId column and drag and drop it in the
Exp.key field to the left of
movieId in the lookup table below.
Warning: Make sure that the type of the movieId element is the same in the main and lookup tables. In this example, the type should be Integer. You can see the types for the selected table in the Schema editor tab at the bottom of the window.
- In the movie table on the right, right-click the root node and click Rename, enter movies as the new name and click OK.
- Right-click the movies node and click Create Sub-Element, then name the element movie and click OK.
- Select all the columns in the lookup table, then drag and drop them on the movie node.
- In the dialog box that appears, select Create as sub-element of target node and click OK.
-
Right-click the movieId node and click As
loop element, then click OK.
- Click OK to close the editor.
- Save your service.
Results
GET
operation.