-
Is it possible to call a batch file in SOA test using Jython
Hi Team, I tried to call a batch file(.bat), basically i am using the batch file to capture the logs. i have tried running a script in Jython import os os.system("C:\Logs\logs.bat") the extension tool gives success but i dont see the batch file opening. Can some one help on this issue Thanks.
-
How to parameterize the "Variable Condition" field in the "TestFlowLogic" of "Execution Options" tab
I want to parameterize the Variable Condition field present inside Scenario >> Execution Options >> Test Flow Logic >> Variable Condition. I want to take the value from "Environments" or "Data Sources". The traditional way of specifying "${some_variablename}" is NOT working
-
CSV file newly generated in a local folder , how can we use the latest sheet in subsequent step ?
Once a job is completed. A csv file will be loaded in a local folder like example : c drive. Latest transaction file should be picked up for the testing is the scenario under concern now. we should be able to pick the latest file on that particular day and time and use this data source in subsequent step.
-
Execute REST API based on DB Tool Output
My requirement is to read a database which will fetch 2 columns and can return more than 1 row. Then for each row of the DB output, an REST API has to be called. Ex: If DB rows return 3 rows, then REST API has to be called 3 times with 3 different set of values. Could you guide me how to achieve calling REST API based on…
-
Saving HTTP Response Code
Hi Parasoft, I am trying to figure out how to save response HTTP code (200, 500) and added a Header Data Bank output item, but I do see anything that looks it would be for the header code. . Here is what is returned: HTTP/1.1 200 Content-Type: application/json;charset=UTF-8 Date: Thu, 01 Nov 2018 16:22:46 GMT Vary:…
-
SOATest runtime error 'No browser set' even though it appears to be
Hi! I am setting up SOATest (2021.2) on Windows Server 2019 replacing the Windows Server 2012. I have a number of tests that run in a browser. On the old server and on my laptop, the tests run like they should using Microsoft Edge browser. The test are unchanged on the new server but when I try to run them, I get the below…
-
Need assistance accessing a Java Class
I could use some guidance on how to access a Java method within SOATest. I have built a pretty basic class to get LocalDate, add days, subtract days and return the Epoch date. When I select "script" for the element I select Java and put in the full path to the class. The methods appear but I can not figure out how I can…
-
Unable to configure MongoDB Query Tool in Parasoft SOA Test & Virtualize 9.10
Hello, per Parasoft guidelines I tried adding MongoDB Query tool jar to my Parasoft SOA Test & Virtualize 9.10 version. When I click on Add Jars button of System properties section, I see only mongo-java-driver under org.mongodb and didn't find mongo db Query Tool in available jars list. Any thoughts?
-
Does Parasoft have an application for Test Management? If not what apps do clients use?
I know CTP enables continuous testing and provides test database configuration, otherwise not real familiar with that product. On the database matter, I don't think that works well for my company because there are key dependencies within the product tested and outside that are subject to change from one release to the…
-
Executing Autosys through Putty
I have a scenario where i need to execute Autosys through putty. I need to enter connection string, Username, and Password in the putty and after that i need to give certain commands. Is the above scenario is possible via Parasoft SOA test? If Possible please let me know how to do it.
-
How to validate uniqueness of a field value in the JSON response.
Hello everyone, Can someone help me how to validate a field, if the value returned in response in unique and contains no duplication. E,g: In below JSON, id field occurs multiple times, I want to validate "id" is unique and it's not duplicated in the JSON response. { "merchantCategories": [{ "id": "0001", "description":…
-
I am tyring to access the results of SOA test from SOA API. I am getting the following 403 error.
HttpGET http://localhost:9080/soavirt/api/v6/status/health Response: Error: Forbidden { "message": "Access forbidden, server does not have appropriate license feature enabled. Both [Virtualize - Service Enabled] and [SOAtest - Server API Enabled] are needed.", "moreInfoUrl": "http://localhost:9080/soavirt/api", "status":…
-
Blank Spaces in Path in Linux Machine
Hi, I am using Windows Machine for our development work and ultimate deployment is with a Linux Machine. In my .tst file, I have below steps configured. 1) Get Project Location using absolutefilepath() 2) Execute a DB query and I am storing the results of query to XML Converter for converting them to CSV. Then I am taking…
-
/soavirt/api/v5/testExecutions - Example Request Payload
Can you share an example rest payload for /soavirt/api/v5/testExecutions
-
How to restore working directory from GIT
Hi, how are y'all doing? I have a question: while usiing Parsoft 9.10.6 for a workspace having a project containing the master test suite modules and a "runnable" project containing references to the test suites, all very basic still. I use GIT as source management/version control. My working directory (where I initially…
-
Extract REST API Output(Literal) to Databank without External File Usage
Team, I have a REST API which gives output just as a literal and not in JSON/XML output. I wrote into a file and then wrote a Python Script to get into JSON databank. Is there any way to get output in JSON/XML without writing into a file.
-
Passing External Excel Files Between .tst files being called from Bamboo
Hi, I have 2 .tst files. First, the .tst file will be reading DB and fetching some records which have to be provided as input to the 2nd .tst file. We cannot have these two .tst files merged together as they have to run in some time gap. These .tst files will be executed from the bamboo pipeline. Any reference to local…
-
com.parasoft.traffic.proxy - Bypass Certain URLs
I am using com.parasoft.traffic.proxy on a corporate network so my BAU web proxy is disabled when I am recording. Most traffic records fine, however I am seeing one set of requests where the endpoint is not being reached. Are there args I can pass to the proxy.jar to tell the proxy to bypass certain endpoints?
-
How to Send GraphQL Queries Using SOAtest
It is possible to use the REST and Messaging Clients in SOAtest to send GraphQL queries. You just need to configure the payload correctly. GraphQL queries resemble JSON a little bit, but they are not in JSON format (meaning you can't build or parse them as JSON). So what you'll want to do is encode the GraphQL query as a…
-
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…