Recent Discussions
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.
Unable 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 PhilipData 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 Philip
Data 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 appreciatedJDBC connection error indicating SSL issue
I have configured a MS SQL DB in my data source step. If i test it , the connection is successful. But while running the data source step alone, i am facing the following error: I have copied the latest MS SQL JDBC Drivers(12.4.1 and 12.4.0) into the ReadyAPI bin path. Kindly help me to resolve the same. Cannot get a connection for the specified properties com.microsoft.sqlserver.jdbc.SQLServerException: "encrypt" property is set to "true" and "trustServerCertificate" property is set to "false" but the driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption: Error: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target. ClientConnectionId:6f0f5b46-4e69-446f-80ee-866d05e2b8e2 I have added the following properties "encrypt" as false and "trustServerCertificate" as true in the database configuration.
Rest request attachments multipart form data for json file with parameterized json data
So I have been trying to do a scenario where i have two attachments for a rest request, one json file which i need to parameterize couple of fields from previous request. The problem with this is once you have cached the attachment you cannot modify it based on the previous test steps, So i have followed the following youtube linkhttps://www.youtube.com/watch?v=iL-zehJmtWw Used query parameter to use a locally store file of json to request but we are getting the error from response that application/octet-stream content type is not accepted ------=_Part_01_136051460.1696260652738 Content-Disposition: form-data; name="testFile" testFile:/Path/to/file/testFile.json I have used parameter like this testFile:${projectDir}/testFile.json What should I do in this caseJWT error - Failed to verify JWT due to invalid exp. exp (expiration) must be after iat (issued at)
Hi, All of sudden I see an error when I run my Test Suite. My credentials are correct and I get success when I test connection with client ID and secret. Has anybody seen this kind of error before? Any help/guidance is much appreciated. Thanks!
