Ask a Question

how to read endpoint and xml request data from Excel

SOLVED
ns214
Regular Visitor

how to read endpoint and xml request data from Excel

Hello 

 

I am seeking help with how to accomplish the following goal:

I have an excel file that lists webservice connections to be tested, the xml request to be sent and the expected validation response. I would like to know if it's possible for SoapUI Pro to read the excel worksheet and cycle through each endpoint and xml request and validate against the response column? 

Or if I have to set up each endpoint manually as a soap request first, is it possible to cycle through each XML request listed in the excel file?

I've tried setting it up with a datasource step but I am having trouble getting it configured properly to read either the endpoint or the xml request from the file. Any help to be provided would be great. Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
TanyaYatskovska
Community Manager

Re: how to read endpoint and xml request data from Excel

Hi @ns214,

 

I suggest that you go through the following tutorial - it may help you configure the test step to read data from an Excel file: Excel Files as Data Sources

---------
Tanya Yatskovskaya
SmartBear Community and Education Manager


Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️

View solution in original post

1 REPLY 1
TanyaYatskovska
Community Manager

Re: how to read endpoint and xml request data from Excel

Hi @ns214,

 

I suggest that you go through the following tutorial - it may help you configure the test step to read data from an Excel file: Excel Files as Data Sources

---------
Tanya Yatskovskaya
SmartBear Community and Education Manager


Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️

View solution in original post

cancel
Showing results for 
Search instead for 
Did you mean: