Dataset will be reset when it is loaded in DevTest, which is when the VS is deployed. To reset a dataset for every transaction, create a subprocess test case and configure dataset in it. Then use the subprocess testcase with a Subprocess step inside the VSM.

The dataset should reset each time the subprocess is invoked.

How to reset a dataset for each transaction

All DevTest supported releases.

Instructions:

1. You will need to save the value, you will look for in the dataset, to a property. In this example, we want to save an argument value.

• It is possible to add the "Request Data Copier" DPH in the request side during the virtual service creation and configured it to copy the arguments key to the property "request_<argumentName>".

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKiyAAG" alt="Request Data Copier DPH Example" width="508" height="342">

• It is also possible to add a filter to the Listener step and save the argument value from the request payload during the VSM execution. For more details on how to save a value from execution to a property see the knowledge document - TEC1431274.

2. Add a Sub Process step to the VSM.

Add a Subprocess step to the VSM after the Router step:

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKj6AAG" alt="subprocess step in the VSM" width="1184" height="302">

The Subprocess step needs to be configured to run a subprocess test case. In the below image, test.tst is the subprocess.  

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKj2AAG" alt="subprocess details - testcase name" width="609" height="119">

If there is no test case, create a new test case and make it as a Sub Process. Select the check box "This is a subprocess" in the Test case information.  

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKj3AAG" alt="subprocess details - This is a Subprocess" width="251" height="209">

3.  Create a subprocess to run the Data Set.

 The Test Case, test.tst, was created and set as a subprocess:

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKj7AAG" alt="subprocess test Case" width="700" height="340"> 

The "Subprocess Input Parameters" will be the property that is coming from the VSM. In our case, "request_user" is the property from the VSM request payload that will be used in the subprocess.

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKj4AAG" alt="subprocess Input Parameters" width="290" height="129">

The sub process test case contains an "Output Log Message" step and a data set. That is all this sub process will use.

The data set is an Excel spreadsheet, but it can be a CSV file or database table.

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKj5AAG" alt="Subprocess Step and DataSet" width="328" height="163">

The data set needs to be set as "Local" and "At end of data,"  Execute: "End the test”.

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKj0AAG" alt="Subprocess DataSet Config" width="680" height="262">

The sample dataset contains userDS and pwdDS:

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKj1AAG" alt="Subprocess sample DataSet" width="149" height="101">

Add the "Ensure Properties Are Equal" assertion to the test step.

This assertion compares the value of "userDS", from the dataset, and "request_user", that comes from the VSM request.

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKizAAG" alt="Subprocess Assertion.png" width="282" height="274">

If the properties are equal, the assertion will return True and the test will be ended. 

When the test is ended, the result will be returned to the VSM. 

If the properties are not equal, the test will loop through all the data set rows and end.

4. Return the values from the subprocess execution to be used with the virtual service.

In the VSM, Subprocess step, select the "Result Properties" that returns from the sub process. For example, in the below image selected userDS and pwdDS.

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKj9AAG" alt="VSM Result Properties" width="679" height="259">

It is possible to use the properties returned from the sub process in the VSM and/or in VSI response:

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKj8AAG" alt="Using Subprocess Properties in the VSI" width="805" height="744">

 

For more details regarding Subprocess: Create a Subprocess Test Case, Subprocess Example, Execute Subprocess.