-
Write to output file from XML transformer into different worksheets under same workbook in EXCEL?
Example: "12345" is the answer from a XML transformer of a field called "ABC". Now I want this ABC field to be written into CSV file using "write tool" feature. Its writing , but instead of saving it as different csv files , every time I run it has to either go to next row in the same excel [ basically appending] or write…
-
How to activate community edition license on linux/Ubuntu?
hi, i am new here and just start to learn I have install parasoft community edition on Ubuntu 18.04 cat localsettings.properties - soatest.license.use_network=false cat license license.autoconf.timeout=20 license.network.auth.enabled=false license.network.use.specified.server=false license.pref.autoconf=false…
-
Git merges for compressed xml files
We are looking to try and implement git support within parasoft, but given that tst files are typically compressed xmls, due to their size, we are curious if the push/pulls address the compressing to account for the diff between files or if the update is an overwrite? Git setup for parasoft -…
-
Using concat in xpath to node that occurs more than once
I need to prepend and append brackets [] to my xpath result in a JSON databank. Below is what I am trying to do but it errors as the occurrence is more than once. The result I would like would look like this [434389]. I would take this result and put in writable. What is best way to handle this?…
-
JVM crashed while launching the soatest 2022.1 from linux virtual server.
JVM crashed while launching the soatest 2022.1 from linux virtual server. And Navigate from parasoft >>preferences ... jvm crashed open jdk 1.8 and 11 .. either way it is not working...
-
Jython Imort Error when Runnig SOA test scripts from Jeninkins using CLI
Hi, I am seeing this error on Jenkins reports when trying to use Jython script to generate random string. The error is: Error during script execution. View Details for more information. Traceback (most recent call last): File "", line 1, in ImportError: No module named random I am using Jython scripts and using "import…
-
Is there a limit to XPath complexity in SOATest?
I have the following json response from a call that I am looking to evaluate certain fields on before making the second call, but when I build out the xpath with more than 3 conditional checks, the viewer for that databank bank entry fails to evalute or open again, once closed { "txnId" :…
-
Multiple variables showing in dropdown list
I believe this has been discussed previously, but I could not find the post. Is there a way to remove duplicate variables from the dropdown list?
-
Validation of static html files using SOAtest
Hi, I would like to know what the best way is to validate an html file within SOAtest. It are basically reports stored on my local file system. Here is a snippet: Deelwaarneming rapportage Normenkader 3.3ID: 2376Naam: UWVTestStart: 16 June 2022 09:33Status: VerwerktAantal berichten: 1Aantal volledige berichten: 1…
-
Data Time Difference
Error Message: DataSource: DataSource-IR1 (row 1): DateTime Difference Assertion: Actual value, 2020-12-16T09:00:00.000Z, was not different from 2020-12-15T17:58:37.000Z by 1 day(s), 8 hour(s) Additional Details: Actual value, 2020-12-16T09:00:00.000Z, was not different from 2020-12-15T17:58:37.000Z by 1 day(s), 8 hour(s)
-
Unrecognizing 'env_var' variable in 'Classpath Entry' in 'System Properties'
I've mongodbquerytool tests, which were working since long, but suddenly they all gone (grey out) stating - MongoDB Query Tool (implementation not found) I've observed, if I provide actual path of .jar file location like C:\Test\mongodbquerytool.jar . It works. But, if provides using env_var for replacing chars '\' like -…
-
Validate REST in XML response format with DB Values
I have used the XML Assertor to validate the XML response and DB Values. I have used JSON assertor to validate the JSON and DB Values. For few of the fields in DB has null values and JSON response has empty. For which i have edited the element in configuration with replace(/root/item/element_name/text(),"null",""). But in…
-
Question regarding Time Stamp comparison with SLA
Scenario : I have this run time data saved using write file in a variable, eg: submission TZ : 2022-06-02T16:31:06.1880147Z and I have SLA which is also captured during runtime and saving it using write file in a variable. Now, I have to compare these 2 TZ and say if submission time stamp is > reported SLA then my message…
-
Is it possible to use two database account at the same time?
I want to get the data from two tables using SQL query but the tables exist in two different database account. Is there any way and how to connect these two databases?
-
Additional settings file in Kafka message client
What is the format of the additinal settings file which needs to be used when security protocol is SASL_PLAINTEXT and SASL_SSL. I tried creating a file with extension as .config with following values in the file , KafkaClient { org.apache.kafka.common.security.plain.PlainLoginModule required username="admin"…
-
Cannot convert XPath value to Java object: required class is org.w3c.dom.NodeList;
Trying to run this XPath for $index in (1 to count(/root ) ) return ( if (exists ( /root/items[$index]/item[]/sport[1] ) ) then /root/items[$index]/item[]/sport[1]/text() else ( if (exists ( /root/count[$index] ) ) then concat('Record Count = ' ,//root/count[$index]/text()) else "N/A ")) or this one for $index in (1 to…
-
Jython Crypto Coding for hmacSHA256
Can anyone help me get the right imports to attempt the below using Jython in SOAtest? Execute Anonymous: String digestTime = string.valueOf(system.currentTimeMillis());//This is standard Execute Anonymous: String digest = EncodingUtil.base64Encode(Crypto.generateMac('hmacSHA256', Blob.valueOf(digestTime),…
-
SOAtest, Virtualize, and CTP 2022.1 PRODUCT RELEASE ANNOUNCEMENT
Parasoft is pleased to announce the release of SOAtest, Virtualize, and CTP version 2022.1, for API and web application testing as part of our award-winning Continuous Quality platform. This update is available at no cost to customers on an active subscription or maintenance contract. Parasoft SOAtest automates thorough…
-
Is there any more detailed documentation for setting up kerberos authentication in SOAtest?
The only documentation I could find is this - https://docs.parasoft.com/display/SOA20212/Additional+Preference+Settings so I simply filled out the Security preference but clicking on Check Ticket gives me the error shown. I've tried different formats in different ways for the service principal, kerberos realm, and KDC…
-
Quality tasks from Diff tool and special characters (UTF8)
Hi, I am encountering problems with the Quality tasks from Diff tool (XML mode, literal XML) parsing special characters. E.g. DOSSIERNAAM!@#$%^&*()_+?{}|[]<>,./ gets in quality task converted to: Changed element text content value from the expected "DOSSIERNAAM?????????????????? ????X" to "DOSSIERNAAM������������������…
-
Is there a way to save all the traffic from all my tests without having to go into each test?
I have a full test suite generated from a swagger with 50+ tests created from all the endpoints - by default the traffic data will go away as soon as I close the project. I see from the documentation (https://docs.parasoft.com/display/SOA20212/Traffic+Viewer) that I can save the taffic data by checking the Save Traffic…
-
Question about XMLUtil.serialize()
Hello! I'm using a scripted response in my virtualization whose get a XML request, make some calculations and return. I'm using XMLUtil.buildDocumentFromString() to convert the text to a document and XMLUtil.serialize() to return a valid XML response. The problem is that XMLUtil.serialize() takes a long time to convert the…
-
How can I add value assertions for my JSON payload that has root element
I've simplified my actual JSON response from my traffic viewer to make this example easier. Let's say I want to add assertions to validate that the first number returned is 111 and the second number is 222 (they are strings). I added a JSON Assertor but the only element that shows up is "root", so I tried manually editing…
-
How to update an excel file used as a data source?
I am using an excel file as a data source in my test suite. Now, once the execution is over I want to update a particular column under the same excel file.
-
How to get current data source row number?
Hi Team, I came across a situation where i need to get data source current row number in xpath reg-ex. Let me know how to fetch it?? Thanks Udaya
-
Test Suite vs. Scenario...
I do not see Scenario as an option, where did it come from?Hi, I have a TestSuite that contains TestSuite's and Scenarios... my question is where the heck did the Scenario come from? I just noticed it... what is it? I don't see Scenario's in the SOATest Documentation... visually it appears to be the same thing as a…
-
Unable to retrieve values which are in XML data bank in extension tool
I am storing the DB tool output to the XML data bank. In other test (where i am using Extension tool) i am trying to retrieve the value using the below code. but it's returning NULL. import com.parasost.api; public void getData(input,sc){ String value =sc.getValue("Custom column name"); Application.showMessage("The value…
-
Capture current Environment being tested
Within a run of a test, is there a way to capture the current Environment that the test is being executed against? I know I can add a variable to each environment with it's name, but that is not ideal for our 40+ environments across multiple test suites. Looking for something like scriptingContext.getEnvironmentName or…
-
DB output converting to excel
I have a scenario where i need to convert DB output to a Excel. I have tried out "write file" with the below details Target name : filename.xlsx Target Directory: path A xlsx file is created in the path, but i am unable to open it. It is showing file format is invalid or corrupted. Can some one help me on this
-
How can I integrate parasoft with event-driven microservice architecture model(pub/sub)?
Hello Team, We are using event-driven microservice architecture model(Pub/Sub) for my project and planning to integrate Parasoft SOAtest and Virtualize. can you please help me on this integration. we are using RabbitMQ as message broker. Pls share if you have any link for reference
-
How to know whether my SOATest script is failed or passed through Extension tool scripting?
I would like to know whether my test is failed or passed through scripting (groovy). As on failure, I need to run some logics through scripting only.
-
Unable to read environment variables in extension tool
I have declared some environment variables and trying to read them in the extension tool. When i am trying to execute throwing the below error. Error:No Signature of the method: org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.$() is applicable for argument types. Below is the code i have used. import com.parasoft.api,*;…
-
Column is not a valid date
While I am testing REST API I get such kind of error messages: I don't want Parasoft to validate if date format is valid. I want to switch off this in Parasoft. Is it possible? If yes, how? What I want - everything as input should be interpreted in Parasoft as a string. And then endpoint will decide, if the input string is…
-
How to access/get last value from XPath result
I'm querying the db and later added a JSON Assertor to verify a last row value of specified column. XPath: Result: Question: How to get the last value in the list? i.e. Honda
-
How to access active environment name in localsettings.properties file
I've multiple environments (like QA, SIT, UAT) where test suites executed. I'm getting the report in my inbox, but I need to have active environment name in subject line, like report.mail.subject= API Execution Report - {Environment name where it executed} I tried these but won't fetching the environment name - env_name,…
-
I need to pass jython code to java
I have doubts when passing this jython code to java code in Extension Tool "def ObtieneXML(input,context): entrada = context.getValue("Generated Data Source","DNI"); entrada = entrada.strip(); context.setValue("DNI2",entrada); context.getValue("DNI2");" if someone knows how to pass that code to java, please help.
-
Dynamic request payload generation for different test cases
I have a requirement where I need to generate the payload dynamically before sending the request to a service. Here, I have total 30 test cases where the structure of the payload is different for each test cases. Our main XML payload: <?xml version="1.0"?><catalog><book id="bk101"><author>Gambardella,…
-
How to take key which defined in json data bank's custom column name box in the groovy script?
I want to use variable in groovy script which I have defined in json data bank's custom column name section.
-
Is there a way to extract all the elements of a xml using condition in select xpath
I have an xml as input and I retrieve the values in xml databank But I am not able to retrieve it if for all elements at one go For Fist element I get Passed if (/testsuites/testsuite[1]/testcase[1]/failure[1]/text() ) then "Failed" else "Passed" but If kepts as if (/testsuites/testsuite[1]/testcase/failure/text() ) then…
-
Web app dropdown fields not populating
Problem populating dropdown fields in web app using SOATest 9.10.8. I have a web app that I created a number of tests in SOATest using Parasoft Recorder running in Chrome. After I imported it into SOATest I replaced the Fixed data that is input into the screen with Parameterized data from a data source table defined in…
-
Data Range Assertion
my xml file has a execution date " 26-11-2021T11:59:59" my expected output date is Trade Date + 1 so something like this 28-11-2021T11:59:59 How can i validate this logic and how can i assert this ? And this will vary for various trade events . Can some one help me please?
-
Python or Jython script to change a value in XML file and update to a new value and use as data
My scenario: I want to execute a query and get XML , store in output file, picked up in python and changing few values inside XML and again using it as data for subsequent story
-
Request timed out when hitting parasoft.com:8080/examples/servlets/Echo
Hi, I am trying to hit http://ws1.parasoft.com:8080/examples/servlets/Echo to echo my request (which has parameterized values ) and get a plain response. I am using the Mentioned end point from the past 3 months and now from last week I am getting a time out message on hitting the endpoint. Please help me with this issue.…
-
Groovy script to read test case name in parasoft
Hi, I am using groovy script for reading of parameter from the data source and creating of folder at the same location. I am able to do this much but now I want my folder name to be same as my test case name. Therefore can you please tell me what should be the groovy script **to read the **test case name from my test suite…
-
Using Data Sources
I have one excel file as a Data Sources I have two Test Steps added under 1 Scenario. * Test number 1: I must pass the ID value (Valid) on the Payload - Happy Path * The ID Value that I need to pass on the Payload is mentioned on the 1st Row of the Data Sources (excel file) under ID Column * Test number 2: I must pass the…
-
Usage of sqlplus commands within DBTool of SOAtest
Hi, Is it in anyway possible to use SQLPLUS commands from the DB Tool within SOAtest (2021.1)? When I use e.g. spool ref_stamgegevens.sql set sqlformat insert select * from scalaref.ref_stamgegevens; spool off with radio button set to Separate Statements by Magic Token I keep getting an ORA-00900: Invalid SQL-statement:…
-
How to read the writable datasource and write to excel file
Am looking for script to read the writable source and write to csv file.
-
Sort values in json databank column
How to sort the values in json databank column array. Need help
-
Send mail with attachment
I need to send from SoaTest, an email with an attachment in PDF format, and I am trying to do it through a Message Client with SMTP protocol. but the document does not appear as an attachment, but as the content of the email. How could I send an attachment in an email?
-
Error in executing Java code with method arguments Object input & ExtensionToolContext context
I have a scenario where the xml file stored in local should be passed in one of the element of the SOAP Request in string format. Steps followed to achieve this task: 1. Added SOAP Request 2. Selected correct Data Source in SOAP Request 3. Written a Java code to read file from local & pass it in request tag 4. Xml file…