Configuring the service to get a list of movies

Configure your Job to use an operation to get a list of movies from your database.

1. Double-click the tXMLMap component to open the Map Editor.
2. In the movies table in the top right corner, click the tXmlMap settings icon and change the value of the All in one property to true.

   

3. Right-click the root node and click Rename, then enter movies as the new name and click OK.
4. Right-click the movies node and click Create Sub-Element, then name the element movie and click OK.
5. Right-click the movie node and click As loop element, then click OK.
6. Select all the columns in the top left corner, then drag and drop them on the movie node.
7. In the dialog box that appears, select Create as sub-element of target node and click OK.

   

8. Click OK to close the editor.
9. Save your service.