Problem reading datasource information from a saved Excel file
I am having a problem reading the information that i have written to an Excel spreadsheet for gathered information, and i am hoping that someone has an answer for the problem that i am seeing. I am doing the following:
1)Create a test step that runs a search for all new records added to a database using a WSDL.
2) added a Datasource test step to search for new requests in a webservice; the Source step was set to search, and the source Property was set to response. i selected the Row Xpath value to search the reuest results for 4 values which i defined in my Column Xpaths.
3) Created a Datasink test step (set the datasink value to Excel) that would write the 4 values to an excel spreadsheet, i added the property and set teh get data to teh datasource in step 2.
4) Created a Datasource test step that will be called by second webservic to read the information that was written to the Excel file for the 4 values.
5) Add Second Webservice that will input the information from the Excel spreadsheet into the template and save that information to the database.
6) Created a loop that will keep running until all of the created Excel lines are read.
The 4 values are correctly being written to the Excel spreadsheet, but the retrieve information step to populate the values into my second webservice is giving me the following error:
Step[retrieve_info] ran with status fail, failed due to missing data.
I set the following options on the datasource:
Restart Datasource when step is run
PreLoads available data if possible
Fails this datasource if no data is available
Am i missing something??? i am stumped.......
1)Create a test step that runs a search for all new records added to a database using a WSDL.
2) added a Datasource test step to search for new requests in a webservice; the Source step was set to search, and the source Property was set to response. i selected the Row Xpath value to search the reuest results for 4 values which i defined in my Column Xpaths.
3) Created a Datasink test step (set the datasink value to Excel) that would write the 4 values to an excel spreadsheet, i added the property and set teh get data to teh datasource in step 2.
4) Created a Datasource test step that will be called by second webservic to read the information that was written to the Excel file for the 4 values.
5) Add Second Webservice that will input the information from the Excel spreadsheet into the template and save that information to the database.
6) Created a loop that will keep running until all of the created Excel lines are read.
The 4 values are correctly being written to the Excel spreadsheet, but the retrieve information step to populate the values into my second webservice is giving me the following error:
Step[retrieve_info] ran with status fail, failed due to missing data.
I set the following options on the datasource:
Restart Datasource when step is run
PreLoads available data if possible
Fails this datasource if no data is available
Am i missing something??? i am stumped.......