Procedure
-
Double-click the tFileInputXML component to
open its Basic settings view.
-
Click the [...] button next to Edit schema to open the Schema dialog box.
- Click the [+] button to add a column, give it a name, getCountryName in this example, and select Document from the Type list. Then, click OK to close the dialog box.
-
In the File name/Stream field, enter the path
to the input XML file that contains the SOAP message to be used, or browse to the
path by clicking the [...] button.
The input file contains the following SOAP message and you can see that the given country code is IR:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:web="http://www.webserviceX.NET"> <soapenv:Header/> <soapenv:Body> <web:GetCountryByCountryCode> <web:CountryCode>IR</web:CountryCode> </web:GetCountryByCountryCode> </soapenv:Body> </soapenv:Envelope>
-
In the Loop XPath query field, enter
"/"
to define the root as the loop node of the input file structure. -
In the Mapping table, fill the XPath query column with
"."
to extract all data from context node of the source, and select the Get Nodes check box to build a Document type data flow.