How to connect jdbc to an Excel file to fetch data and compare it with XPath match in ReadyAPI
Hi Team, I am new to ReadyAPI. I need to fetch data from excel file and compare that with Xpath Match in ReadyAPI. (I tried to load excel file using data source, but that data source was not able to iterate using data source loop with return request.) How to connect jdbc to an Excel spreadsheet to fetch data and compare that with Xpath match in ReadyAPI response. I guess you are aware of this issue or requirement and you may have resolution ready. Could you please help me on his as soon as possible.
Re: How to connect jdbc to an Excel file to fetch data and compare it with XPath match in ReadyAPI
Just adding to Rao's comment: jdbc is used to connect to databases (stands for java database connectivity) so you dont need jdbc configured to extract data from a flat file.
if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta
I think where we should focus is "(I tried to load excel file using data source, but that data source was not able to iterate using data source loop with return request.)".
You must have the pro version to be able to configure a data source and you should be able to iterate over each row.
Can you share an excerpt of your data source and the structure of the test? When I first tried data driven tests, I had some trouble understanding the data source loop in that you have to bind it to the data source (to create the loop), then say which is the first step inside your loop.