When I am testing a peice of functionality , the output is an XML with multiple rows in it. I want to assing each row to the data table at runtime, but when i run the program, my run time data table is getting only the first record in XML where as the XML has 100s of records.
how can i get multiple records onto data table
thanks for the help.
Hi Geeth,
Can you pls share the code that you have developed, so that we can give our inputs easly?
Here is the code
Code:
Set getLostRevenueLeads = WebService("EnergyRecoveryLeadService").getLostRevenueLeads(XMLWarehouse("getLostRevenueLeads"))
WebService("EnergyRecoveryLeadService").Output CheckPoint("getLostRevenueLeads_4")
I have given the expected XML
Code:
<getLostRevenueLeadsResponse>
<getLostRevenueLeads xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://lead.wsdl.energyrecovery.pgn.com">
<energyRecoveryLeadResp xmlns="">
<energyRecoveryLeads>
<score>0</score>
<leadType>String</leadType>
<leadDate>2009-08-20T10:29:11.8203834-07:00</leadDate>
<leadType_code>String</leadType_code>
<customerCode>0</customerCode>
<premiseCode>String</premiseCode>
<customerName>
<lastName>String</lastName>
</customerName>
<address>
<addressLine1>String</addressLine1>
</address>
<stockCode>String</stockCode>
<meterId>String</meterId>
<phase>String</phase>
<accountStatus>String</accountStatus>
</energyRecoveryLeads>
</energyRecoveryLeadResp>
</getLostRevenueLeads>
</getLostRevenueLeadsResponse>
-----------------------------------------
But the web service is returning number of similar nodes, how to capture them in the data table?
DataTable.Import "XMLFilename"