cancel
Showing results for 
Search instead for 
Did you mean: 

How to connect jdbc to an Excel file to fetch data and compare it with XPath match in ReadyAPI

abhijitp26
Visitor

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.

Thanks in advance.
Abhijit

3 REPLIES 3
nmrao
Community Hero

Re: How to connect jdbc to an Excel file to fetch data and compare it with XPath match in ReadyAPI

Please check below video for data-driven test if that
https://www.youtube.com/watch?v=AFtyMUiD-5s
https://www.youtube.com/watch?v=gMzQLnG2ifA

I would suggest that to try out with simple cases and proceed with data-driven approach if you new.


Regards,
Rao.
richie
Community Hero

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.

Ta

Rich
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
ChrisAdams
Community Leader

Re: How to connect jdbc to an Excel file to fetch data and compare it with XPath match in ReadyAPI

Hi,

 

In addition to @nmrao and @richie points....

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.

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors