ContributionsMost RecentMost LikesSolutionsRe: Valid HTTP code assertion doesn't provide what is expected and what is actual Thats pain, i recommend smartbear to have expected and actual displayed in the test result. Valid HTTP code assertion doesn't provide what is expected and what is actual In readyapi when i use Valid HTTP code assertion, when its failed due to mismatch with the response code why don't it gives you what is expected and what is actual. For example: if i am expecting a return code of 201 and its returning 200, readyapi gives me the following responses "Response status code 200 is not acceptable list of status codes" but if they provide with actual and expected , it will be easy to understand. "Response status code is :200 , doesn't match with the expected "201" SolvedConnecting SQL server 2014 using windows authentication Hi, I am trying to setup a jdbc connection to connect to SQL servere using windows authentication and query the database. I contacted support team but i couldn't get the help on this, which is supposed to be. i did following things but still getting the error 1)copied the ntlmauth.dll into bin folder 2)copied the jtds.jar file in ext folder 3)added new driver in File->option-.jdbc driver. but still getting the below error. java.sql.SQLException: Network error: IO Exception:Connection refused:connect. Can someone please help me.. Re: Reading from excel based on a condition i am aware of getting data from the datasoruce. but do you know how to filter the rows from the datasource after getting the all data from the table. Re: Reading from excel based on a condition Hi, i was trying this but it doesn't solve the problem. i will store all my testcasename and input data in an external excel file. whenever i execute a test case i will read the excel file and then look for matching testcase name and get the test data specific to that testcase. i gone through that document, but it doesn't server the purpose. how to i filter or match for the specific test casename in the datasource. If you could provide me the detailed steps..that would be great help Re: Get xls data in loop in groovy script can you please provide the steps how to do this Reading from excel based on a condition Hi, i have scenario like i have an external excel file which contains TestcaseId,Inputdata1,Inputdata2. i want to read the data from excel where testcase matches and get the inputdata corresponding to that testcases and pass thosse input to steps. I have been trying to read from excel using different helper jexcel and other ways and nothing works. Please can some one share the code to read from an excel file