About this task
The tXMLMap in the output flow will convert the response message from the XML format to the row/column structure.
Procedure
- In the design workspace, double-click the tXMLMap component in the output flow to open the Map Editor.
- In the input table, right-click the root node and select Rename from the contextual menu. Enter IsValidEmailResponse in the dialog box that appears.
- Right-click the IsValidEmailResponse node and select Set A Namespace from the contextual menu. Enter http://www.webservicex.net in the dialog box that appears.
- Right-click the IsValidEmailResponse node again and select Create Sub-Element from the contextual menu. Enter IsValidEmailResult in the dialog box that appears.
- Right-click the IsValidEmailResult node and select As loop element from the contextual menu.
-
On the lower right part of the map editor , click [+] to add a row of
String
type to the output table and name it response. -
Click the IsValidEmailResult node in the input table
and drop it to the Expression column in the
row of the response node in the output table.
- Click OK to validate the mapping and close the Map Editor.