Auto-Populate Data Generator "Value from set" values
Is there anyway to automatically populate the values list in the "Value from set" option in the Data Generator section of the Data Source step? Digging through the API definition for the DataGenerator DataSource step https://support.smartbear.com/readyapi/apidocs/3.0.0/pro/com/eviware/soapui/impl/wsdl/teststeps/datasource/DataGenerator/UI/DataGeneratorDataSource.html I could probably do this with a call to setConfig but was wondering if I was missing something easier? We need to run some load tests on a system to do some troubleshooting. Each request needs to submit one of a selection of id's. This would be simple and not a problem except that these id's change on a daily basis.We also want these to run with minimal need for user intervention. RegardsSolved23Views0likes1Commentreadyapi 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.65Views0likes4CommentsPassing 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:Solved474Views0likes10CommentsHow 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) Thanks72Views0likes0CommentsHow 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.368Views1like7CommentsUnable to write to excel using groovy script in Test Engine
Hi, I am trying to read/write to an excel file using Groovy script. It works perfectly in my local ReadyAPI. However, when I run it on Test Engine, I get the below error: Error. java.security.AccessControlException: access denied ("java.io.FilePermission" "\Data\XXXXX_E2E_Functional_003.xls" "read") I get this error on the below line of code: Workbookwb=Workbook.getWorkbook(newFile("\\Data\\XXXXX_E2E_Functional_003.xls")); I updated theReadyAPITestEngine.vmoptionsfile in Test Engine and added the line at the end: "-Dgroovy.allow.all=true" as mentioned in the documentation link below: https://support.smartbear.com/testengine/docs/admin/config.html#groovy However, I still get the access denied error. Appreciate any help or lead into fixing this error. Thanks! B PhilipSolved221Views0likes2CommentsData Sink always updates the 1st row in excel sheet
Hi Team, With the latest version of ReadyAPI (4.39.0), the Data Sink will always write to the first row of the excel sheet when the row is selected by dynamically assigning the cell value for "Start at Cell" parameter of Data Sink. I define a Custom Property called "prop_StartAtCell" in "Custom_Props" Properties step and give an initial value of A1 In groovy script, I dynamically change the value from A1 to A2 or A3 based on certain conditions. In the Data Sink step, I select Excel as the Data Sink, and assign the "Start at Cell" parameter as ${Custom_Props#prop_StartAtCell}. So, while running the test case, it will dynamically assign A2 or A3. However, the Data Sink will always write the data to A1, not to A2 or A3. Looking for a solution or fix for this issue. Thanks!! B PhilipSolved262Views0likes2CommentsData Validation after Running a POST Request
I'm quite new to Ready API and API testing, but need help with needing to validate that after running a post request that the request has been successfully inserted into the database and fetch the status column from the db, which I will use with assertions The db is running on GCP... Any help is greatly appreciatedSolved312Views0likes2Comments