-
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 do I convert XML data into an excel.
I want to fetch data from XML and put it into an excel. My XML data is like: ABC 123 I want to convert these data in Excel in table format
-
Avoid blank values in excel while validating
Hi Team, How to avoid blank values in data sheet while validating or during assertion. example : Attached an excel. I need to skip the blank cells in excel while testing. Note : I cannot edit the datasheet.
-
how to create CSV files (editable in Microsoft Excel) from Data extracted from tests
Often you will want to extract values that are returning from a test and write them into an excel file. This could be useful when building data sources dynamically from previous tests. SOAtest does not have a native interface to create Microsoft Excel files, however we can easily create CSV files that can be read by our…
-
Saving Dynamic JSON output in CSV in Columns
hi is there any way to save complete dynamic JSON output in csv in columns . right now i used write file and saved in CSV but it is saving in one row. my expectation is to save all json values in csv with 2 columns , field name and field value. i cant use data bank because json file is dynamic, one file might have 10 field…
-
Export Test scenarios with details
I am using Parasoft SOA 9.10 version. Is there a way to export the test scenarios to excel (.csv or .xlsx) ?
-
How to iterate to get column count and each column name from Datasource (DS as Table)
I was trying to write a piece of java code to loop thru each column and respective values. Using context i could see that i can read all the values (using context.getValues) of one column or can get one value using (context.getValue). However, I would need to know how do I read the coulmn count and their names ? So that i…
-
Fetch data from a specific row in excel based on a value
I would like to fetch a row value from excel sheet (data source). Need to fetch one row value and use it to assert the response. Scenario: Create a data source of Excel type. Associate a file to it . The excel file has 30 rows(for eg). I need to fetch the row data corresponding tp one key value. Eg. I have an excel sheet…
-
Excel data source location respective to project
How do I have to set the path for an excel file that I use as a data source so that it is always respective to the project? I have been using it in my desktop while I was trying to figure out how to work with it, but now that I am planning on checking my code in, I would like to configure it so that anyone that works on…
-
How to enter datetime in Excel Data Source
I am using an excel data source to import data to generate complex structures, I have managed to work with creating relationships between the different sheets, but the one thing that I can't figure out how to do is how to enter dates so that I don't get an invalid datetime error. Anyone has done this and knows the correct…
-
Parasoft SOA test is getting hanged when i try to invoke a 2MB size excel file into data source?
Hello, I am using Parasoft SOA test 9.9. * Create a .tst. * trying to add a excel sheet to data source (excel file size is almost 2MB). everytime I import the excel , I am getting an error that Parasoft is not responding or the tool get freezed. I will have to go to Task manager to end the process. Is there any limit in…
-
Retrieval date format
Is there a way to validate the retrieval date format: yyyy-MM-dd'T'HH:mm:ssZ – Ex. 2017-06-26T01:00:
-
how to create Excel files from Data extracted from tests
My use case is generate excel file from data extracted from tests like DB Tool or Extension tool. Can someone help?
-
how to update content of an Excel file from Data extracted from tests
My Use case is, i have an excel file in which i would like to update the content of certain column data with actual values from Database using DB Tool or Extension Tool. Can someone help?
-
Creating a Data Source for a request that contains an array
I have a request that contains an array of account numbers that differs on every request (so it will not always be two account numbers sent), how to i store these values in a excel data source and set up the correlation? Here is the sample request: { "accounts" : [ { "accountNumber" : "55555" }, { "accountNumber" : "66666"…
-
Iterate the datasource values
I have requirment to read a column - all the rows of an excel data source and send in my response. How to iterate over all the rows and fetch the value in the excel data source. Pl. help
-
Dynamically generating response schema and data on the fly
Choice type parameterizaton is not supported currently in SOA/Virt but there is a way that you can work around this. You can dynamically build request/response structure (Schema) and data using a data source. Define the Data Source Here is an example of a datasource where I am defining the name of a choice Element and…
-
Importing Excel files Into a Repository
Parasoft: Importing Excel Files Into a Repository Description: To import data from an Excel Spreadsheet into a data repository, we will need to use the Data Repository Tool. The Data Repository tool specifies what data to import, how to structure it, and what repository data source should include the imported data. The…