Variables in DB Table (query) variable
Would be nice if I could add a variable in the DB query variable, so it would be more flexible. Because now I need to build the entire script if I only want to add variable in the query or I need to add many DB Table variables if I only need to change one parameter in the query. Example in the screenshot.
Script Test - Show Usage/references
When we create reusable script routines to serve some common purposes, and use the same in different script files, and functions, TestComplete should have the ability to find and show all the usage / references of the reusable function, like the other standard IDEs.
TestComplete - DB Table local variable not refreshing
Hi, I have a test case where I manage the status of a request, and everything works fine when I run it individually. The issue appears when I execute it as part of a test set: I need to use that case multiple times, but the local variable (which is a DB Table type) does not refresh. It keeps the same value from the first execution instead of updating with the new query result. At the end of the first case, the request status changes. In my query, I filter requests so that it only returns those with a specific status (for example, status = 1). Therefore, once the status changes, the same request should no longer be returned. Has anyone faced this situation? How can I force a local DB Table variable to refresh its data every time the test case runs inside a test set?
Reuse adapted xml file and send in REST
Hi SmartBear, Long time ago that I was here (under a different name :-) ). Glad to be back though ;-) So, my question: We want to send a file as Query, cached, multipart/form-data. After sending we need to adapt, e.g. the vinnumber, save the file and send again with REST request. For the moment I have this: import groovy.xml.XmlParser import groovy.xml.XmlUtil // 1 Generate VIN def chars = "ABCDEFGHJKLMNPRSTUVWXYZ0123456789" def random = new Random() def generatedVin = (1..17).collect { chars[random.nextInt(chars.length())] }.join() log.info "Generated VIN: " + generatedVin // 2 Get file path from test case level -->wll fetch it from folder project def filePath = context.expand('${#TestCase#file}') def file2 = new File(filePath) log.info "File path: " + filePath // 3 Parse XML def xml = new XmlParser().parse(file) // 4 Update VIN xml.Body.VehicleTransportOrder.Line.Vehicle.VehicleID[0].value.generatedVin // 5 Write updated XML def writer = new FileWriter(file2) XmlUtil.serialize(xml, writer) writer.close() log.info "VIN replaced successfully" The original file came with the composite testproject as everybody needs to be able to reach that file. We don't know if this would be better put in a folder because we will have different files from different clients. But this is what we came up to. The file is read correctly, the vinnumber = generated, but the new number can't be put in that attached file anymore. Anybody an idea on what should be the best steps now? Thanks in advance, AABChecking API Status in TestComplete
Introduction I first saw the need to verify the state of an API several years ago with an application that used an address validation API in several of it's operations. If this API was down or did not respond in a timely manor, many of the automated test cases would run and fail. In this case, and in others, I have found that doing a simple call to the API to check the returned status code allowed me to skip, fail or log a warning with a logical message instead of allowing the application to fail with another less direct error message due to the API issue. The aqHttp Object The TestComplete aqHttp object and it's methods are very useful for performing simple checks like this and are also useful for other more complex tasks like leveraging an API to return a test data set or even verifying a certain data is returned prior to running tests against the UI that depend on the data. Sending and Receiving HTTP Requests From Script Tests More Complete API Testing Most proper API testing should be done using a tools like ReadyAPI or SoapUI. Both of these tools will integrate with TestComplete or can be used alone and will provide much more capabilities and automation options. Integration With ReadyAPI and SoapUI Code Example Here I have provided a working example of how to code a Get request using 'aqHttp.CreateRequest' to confirm an API returns a status code of 200 and it will log the returned records. function sendGetRequest() { let resourcePath ="https://restcountries.com/v3.1/all" let resourceQuery = "?fields=name,capital"; let url = resourcePath + resourceQuery; try { // Send GET request let response = aqHttp.CreateRequest("GET", url, false).Send(); // Check for successful response if (response.StatusCode === 200) { // Parse JSON response let allData = JSON.parse(response.Text); Log.Message("Total records received: " + allData.length); // Process each record allData.forEach((record, index) => { Log.Message("Record " + (index + 1) + ": " + JSON.stringify(record)); }); return true; // Send a bool back to the calling function. } else { throw new Error("Failed to fetch data. Status code: " + response.StatusCode); } } catch (error) { Log.Error("Error during request or data processing: " + error.message); } } Enhancements You could accept parameters for the resourcePath and resourceQuery. Parameterize the logging loop run or remove it. Return the JSON to the calling function for use. Perform other tasks based on the return code. Conclusion With the growing use of API calls in desktop applications and the fact that APIs are almost the foundation of any web site checking an API before a test case run is almost a requirement for consistent test runs and good error logging. This small script can bring big rewards to your test runs and reports. Cheers! I hope you find it as useful as I have! If you find my posts helpful drop me a like! 👍 Leave a comment if you want to contribute or have a better solution or an improvement. 😎 Have a great day
Running ReadyAPI Suite via Command Line / C# took ~ 30 sec to initiate
Hi, I'm currently executing the Ready API suite using C# by triggering testrunner.bat. The execution works as expected; however, it takes approximately 30 seconds to initiate the run. Is there any way to optimize or speed up this startup time? I’d appreciate any suggestions. Below is the command I’m using: string soapCommandLine = $"-s {suiteName} " + $" -c {caseName} {readyAPIprojectPath} ";
RunTestCase input and return proeprties of the same name
Hello! I have a test case module that loads a set of around 100 properties from multiple databases, performs some logic with the data and then outputs the whole set into the testcase properties. I want to have the option to input some of the properties into the test case when I use a Run Test Case test step and if my logic detects the input, it won't load those specific properties from database. What I am struggling with is that if I set the Run test case step properties as Return properties, it ignores the data i put into the Run test case properties, and if I don't set them as return properties, the empty input properties don't get overwritten with the DB loaded data. Do you have any tips how I could achieve to have shared input and return properties?Data Source test step doesn't output arrays into properties
Hello! I am using Ready Api GUI 3.57.0 and I am trying to setup a modular, data-driven general testcase. I am using GUI only to setup the test, and now I encountered a strange situation when using Data Source test step I have a nested array and I am currently trying to use JSON DataSource to iterate over the root array and save the nested array into a property. And I am failing to do so. When I point to the Array I want to save into the property, if saves Null. When I point to the first member (i = 0) of the array, it shows the data properly. Could anybody please help me check if I am the one who's doing something wrong, or it is ReadyApi being moody? To make the situation more specific: This is my JSON data source: { "name": "Get_PC", "toTest": true, "templatesDirectoryPath": "I:/Testing/AutotestSourceDataFiles/P1/Get_PC", "a_webServiceDefinition":[ { "name":"2018/05", "toTest": true, "webServiceUri": "/P1/2018/05", "o_nameSpaceDefinitions": [ {"nsName": "soapenv", "nsUrl": "http://schemas.xmlsoap.org/soap/envelope/"}, {"nsName": "ns", "nsUrl": "http://www.data.com/2013/08"}, {"nsName": "ns1", "nsUrl": "http://ws.com/2018/05"} ] }, { "name":"2023/09", "toTest": true, "webServiceUri": "/P1/2023/09", "o_nameSpaceDefinitions": [ {"nsName": "soapenv", "nsUrl": "http://schemas.xmlsoap.org/soap/envelope/"}, {"nsName": "ns", "nsUrl": "http://www.data.com/2023/04"}, {"nsName": "ns1", "nsUrl": "http://ws.com/2023/09"} ] } ] } My DataSource test steps configuration is: Data Source Type: JSON Step and property points to the aforementioned JSON string Row Path: $['a_webServiceDefinition'] Column Path: ['o_nameSpaceDefinitions'] According to JSON PATH documentation and validators, the JSON PATH: $['a_webServiceDefinition'][0]['o_nameSpaceDefinitions'] should return the array I want, but it is returning NULL. Also, when I modify column Path to ['o_nameSpaceDefinitions'] [0], it correctly returns the first object in the array. Is there a problem on my side?
Problem with generated data table and keyword test
Dear Community, I have a problem with a created table type project variable. Here is my script, I checked data inside the generated table and everything is OK for the table. function CreateTestExecutionDataTable(){ // Create a table variable if it doesn't exist if(!Project.Variables.VariableExists("TestExecDataTable")) Project.Variables.AddVariable("TestExecDataTable", "Table"); // Get a reference to the variable var t = Project.Variables.VariableByName("TestExecDataTable"); // Add columns to the table t.AddColumn("Test Execution"); t.AddColumn("Environment"); t.AddColumn("Build Type"); t.AddColumn("Team"); // Create rows TestExecutionData.testExecutionList.length-2 t.RowCount = testExecutionList.length-2; Log.Message("Length of the execution table "+t.RowCount) for(let i = 0; i < t.RowCount; i++){ t.$set("Item","Test Execution", i, testExecutionList[i+2]); t.$set("Item","Environment", i, environmentList[i+2] ); t.$set("Item","Build Type",i, buildTypeList[i+2] ); t.$set("Item","Team", i, teamList[i+2]); } } Then I want to integrate a Data driven loop that will perform actions for each item in the table var. The problem occurs when I want to choose some values and perform actions, because I don't see anything. I don't have any idea about how to use this generated table in my keyword test. Does anyone have an idea? Thank you for your help.
