readyapi Database connection
in our project, when I add a datasource step and try to add, and choose JDBC as Data Source, and try to add connection I get a pop that says "Connection properties have changed. Do you want to build a query?", I choose Yes to see table like the screenshot below, since I want to select visually database and fields, but it takes very long time like 7 mins to see all databases, is this something expected to take that long, or is there any other solution for that? It is large database, so is there anyway maybe that readyapi does caching?? or any other solutions for large database.
Passing comma separated values for a property in Data driven test case
Hi, I am creating a grid data driven test case using Ready API. For one of the properties, I have to pass multiple comma separated values for a particular property in my REST request. I am not getting how to split the property value in request editor into multiple strings as otherwise the value is being passed to request as single value. Please guide if there is any direct support for processing such data or I need to use groovy script? The grid data looks like: The request snippet is as below:
How to disable "autocorrect/autofill" on SOAP requests
Using ReadyAPI to do a data driven test against a SOAP API. On each iteration, putting XML in the values for a properties test step. This is so that we can have some tests with missing elements, or other structural options. Using a placeholder in the SOAP request to grab those property values (see image). Whenever I save the project, ReadyAPI goes into my request, sees missing elements (because the placeholder puts them there during runtime) and "helps" me by shoving empty element tags in there for schema compliance. Next time I run the test, it fails because of extra tags... I have to remember to go into the request and delete the extra tags. One day I may forget and raise an embarrassing defect. Main Question: Is there a way to disable this "help" that keeps making things more complicated? (please support negative test cases - they're critical for robust testing) Thanks
How to build SQL query using strings whose value should be retrieved from TestCase property
Suppose i have the following properties defined in the Test Case Properties FromTime =2023-11-15 23:00:00 ToTime =2023-11-16 23:00:00 I want to replace the time given in the below query with the above test case property variables. How to do that in ReadyAPI JDBC datasource ? SELECT * FROM Table1 where TagId = 4314 and Time > '2023-11-15 23:00:00' and Time < '2023-11-16 23:00:00' I am able to retrieve integer values like TagId and use it by adding 'Prepared Properties' within the JDBC datasource window. But if i add the string and use it inside the query, data is not fetched as the string is not interpreted properly.
