-
GraphQL Support?
Is additional support for graphql coming to the next release of soatest? Typing out literal requests is quite difficult. I typically use a 3rd party application to construct the requests using the graphql schema and intellisense, and copy pasting what I have constructed into a literal JSON request. Would be nice to have a…
-
GraphQL SDL tips
The SOAtest GraphQL Client has a Form GraphQL view that can be constrained to the fields defined in a GraphQL Schema Definition Language (SDL) document. This simplifies building queries, where the Form GraphQL view is populated with controls to select and configure the available fields, arguments, etc. A GraphQL SDL may be…
-
Bamboo Pipeline calling .TST File - not able to perform DB Query
Dear All, I have .tst file where I use DB tool to Query DB2 Database. While setting up DB tool connectivity, I refer to the db connection properties file and I am able to execute it successfully. As part of Automation, currently Bamboo Pipeline is calling our .tst file and it fails at the DB step. How to give the DB2…
-
Invalid XML input:Content is not allowed in prolog
I am trying to assert some fields from Writable Source in Extension tool using Jython and writing the assertion response to a excel file. When running the script, it gives me error like 'Invalid XML input: Content is not allowed in prolog'. But the Output excel file is written. I have enclosed the test suite information.…
-
Executing .tst file using Command Prompt
I am trying to execute my .tst file from command prompt and I am getting the below error message and need your guidance to resolve this. C:\Program Files\Parasoft\SOAtest & Virtualize\2022.1>soatestcli.exe -config "C:\Users\bharatarun.radhakris\Bharat\Parasoft\MATF" -resource "BatchValidationPrcfd750Regression.tst"…
-
Interdependent conditional csv validation in SOAtest
Hi, I have a got a csv report which has fields (e.g. column 5) containing today's timestamp, for rows with only certain values in the first column. The csv client is used to convert it to xml. I have been struggling with xml databank, writable datasource and custom assertion to get this show on the road, but the result is…
-
Is there a standard Github Actions for soavirt?
Below is one for CTP https://github.com/marketplace/actions/execute-job We are looking for a similar setup for soavirt
-
Execution is failing for specified -resource (.tst) thru command-line
I've couple of .tst files under my project, say smoke.tst and regression.tst. I just want to run the tests have in smoke.tst so I modified my command-line by adding -resource ${project-path}/ProjectName/FolderName/smoke.tst. But while executing, it's failing stating - ERROR: Missing Resources: The following…
-
Post SOATest Results to Jira using Zephyr
We have a lot existing API Tests using SOATest, now wanted to post execution results to Jira (for further graphical representation) using Zephyr. We have many Tests under Scenarios and many Scenarios under TestSuite, like - I find to post results per Jira Test Id using Test Flow Logic after every Test, but it's weigh…
-
Use two different .tst files for single assertion
Hi Team, We have a scenario in which we have to query the DB just before to Batch Job run and store the results in a data bank. Then after the batch is completed using the previously queried results, we have to check the DB for processed results. Can we write 2 different .tst for these and can we refer to the previous .tst…
-
For a XML response, how can i do a data type assertion validation?
I have started using xml assertions for the response validation. I am looking for sharp answer than generic ones saying try assertions from output. 1) I want to validate data type for the response. ( String or int or text etc) 2) I need to do data length validation 3) i need to validate actual response to the expected…
-
Corrupted responses when running test concurrently within a suite
When turning on the "Tests run concurrently" Execution Mode under Execution Options -> Test Execution, I am seeing corrupted responses. As a result, current assertions or status code validations fail due to the jumbled data. Has anyone else experienced issues with this apparent common setting? Here are a couple of the…
-
How to write DB Response to Internal Spread sheet table ?
My Requirement is to Query table 1 which may return N rows. For Each of the row, I have to query 3 other tables and do some assertions. I wrote the Table 1 response to a CSV file and created a data source out of that and used that as an input to my other 3 tables. But I have been asked now instead of writing to a CSV file,…
-
How to pass Variable to Extension Tool ?
I am using Jython Script for extension tool with an excel databank as Datasource. In addition to this, I need a variable which is defined in the test suite to be passed to the extension tool. Please do let me know how to achieve this?
-
Execute Different Test Scenarios based on Excel Sheet Value
I have an excel which has a field (Regression/Functional). Based on this field, different Test Scenario tests have to be executed. If R, Execute Test Scenario 1 and If F, execute Test Scenario 2. Is it possible to achieve this?
-
Chrome does not allow this extension to change proxy settings.
I work in an env where browser configuration policy is managed by the company. I get the error shown in the title when I try to enable API Traffic for Parasoft SOAtest. It prevents me from being able to record. I tried the following workaround but it did not work. Is there another way around this? I confirmed that my local…
-
soa doesnt recognise oauth token generated as string
Oauth token is generated in a string format. But the element cannot be captured as a element to be used for the following tests. How to read this token in string format and make it use for following test cases. Any approach to be followed??
-
DB Validation at Row Level
Hi Team, I am reading DB with a query and the results I am storing in an XML data bank. Each Row will have 6 columns and one of which is a status column. I need to check for all rows if status column is a fixed value( say., 'S'). I created tests as enclosed. When i am trying to assert, the assertion doesn't shows the…
-
Date Format Editing
Hi All, I am calling an API which will give me back the mainframe Job details like Run Date, Run time, Status, Job ID etc in an array. I need to take the Date and Time from the very first occurrence. The format I am receiving is YYYY/MM/DD and HH:MM:SS. I am storing these 2 values in a JSON databank. I am creating a JSON…
-
SOAtest Quality Tasks cannot not always show differences
Hi, After running a test in Parasoft SOAtest 2021.x I want to analyse the results and eventually adapt the excepted results of e.g. the Diff Tool (XML mode). Sometimes, when there are (maybe too many) differences, SOAtest does not show the differences anymore, but instead a dialogue (Compare) is shown stating that "There…
-
Extract Data from Excel and use that in SQL Query to execute
Hi all, I am using Excel sheet as Input, so I have kept that as Data Source. Each Line in Excel sheet is a Test Case. I have Data in a specific column in the format like this ::: ::: . . ::: I have to extract the Value 1, Value 2. Value n (This Value is the 6th one with separator as :) and then use that to Execute a SQL…
-
Dependency on Previous API Tests
In Our API Test Suite, Test 1 submits a mainframe job and this will give back Job ID, Job Name and Return Code. I am storing that in JSON databank. Based on the Return Code value of Test 1 (If 0), I need to execute Test 2. Please help me how to set this up.
-
Can we introduce wait period between two tests in a test suite ?
We have a test suite with multiple tests. Test 1 calls an API which submits a job in mainframes and doesn't wait till the job gets completed and will give a success condition once the job is submitted. Test 2 reads a file that is created by the submitted job. Sometimes the job might take some time and as Test 2 runs…
-
SOAtest, Virtualize, and CTP 2022.2 PRODUCT RELEASE ANNOUNCEMENT
Parasoft is pleased to announce the release of SOAtest, Virtualize, and CTP version 2022.2, 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…
-
Trying to access a Selenic Junit test from SOATest
I posed this question before and while I apparently got it to work, I have since lost all of the source code for the Junit test and SOATest. So, my apologies. Anyway, I have a simple Junit test of a web app. This test will search on a entered identifier number and then display some information that was found. This runs…
-
How to run SQL with a variable
I am trying to insert a record into our DB2 database and one of the columns contains a CLOB so to pick up the text file it is included as a variable (for example, ${data1-10||C:\workspace\DownloadFiles\EXPORT_DATA\dbvis-9421411203761954562.txt||TextData||noshow vl=file}$) which was exported from DBVisualizer. Currently,…
-
How to write generated data to a file
Hi Everyone, We are using data generator tool to generate random values, could anyone please help how to extract / write those generated values to a file. Thanks in advance..
-
FTP Virtualize
Hi Everyone, We are trying to generate a .csv file and transfer a file to the target location (SFTP) on daily scheduled time using SOA test. * How to generate a .csv file with different random values with at least 10 rows. for ex: BOFSTXXXXS , julian_date , curr_date , WM003 2459816190742,11192897,3503217,EA * Once it is…
-
Reading Parquet Files
Is it possible to read parquet files using SOA Test.
-
how to compare 2 XML files
Both XMS are request and can be fetched from database as well. I want to compare these 2 in SOA test
-
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������������������…