Forum Discussion

satya_addepalli's avatar
2 years ago

Data Driven Test using Excel

 

I am using a SOAP request with a wsdl.  The data for the XML request is on an excel file. The data is split into 2 sheets.

"Sheet1" has all the authentication data (User ID, Correlation ID etc)  that is sent Soap Header.

"Sheet2" has  the actual data that should be sent to Soap Body.

 

How would i parameterize and use the data which is on 2 sheets of a same excel sheet in Ready API.

I am seeing  the error below,

platformErrorCD>0x00230001</v1:platformErrorCD>

 

Thanks in advance. 

 

  • when you go through the setup of the Data source, im pretty sure there is a part which asks you the worksheet that you are wanting to use