Test Data File

Overview

Application testing can require working with large data sets to verify workflow execution and cover edge cases. Instead of creating multiple test cases for each data set, you can import and use your data sets with your projects. The test data is imported to your project as a JSON file. You can find this file under Project > Test Data.

Conditions

You can configure the data variation file to store up to 2Gb of data. The file is named Package.VariationFile.MaxSizeInKBytes.

Supported files

• Excel data tables (XLSX, XLSM)
• CSV
• JSON files

Adding file test data

1. Create a new test case with test data, or add test data to an existing test case.
2. Click Source and select File from the dropdown list.
3. Select the columns that you want to add.

   Browse for your XLSX or CSV file and then select the Worksheet. If you have an updated JSON file, you can select that from the dropdown list.

4. Select individual or all values from your data file.

The data is imported from the Excel file as InArgument together with its associated values, as you can see in the following screenshot with the workflow and Excel file side-by-side.

Tip: Check out the following additional actions:

• Add test data when creating test case.
• Verify Expression with Operator. You can use this to compare the workflow values with those imported from the Excel file.
• Add test data using the Test Explorer contextual menu.

Run/debug file with data variations

You can debug or run your test case using selected or all of your test data.

1. In the Design ribbon, click Run file with data variations or Debug file with data variations.

2. Select the data that you want to use and confirm your action.

   
   

   

   
   

If you use a Verify Expression with Operator activity for your test case, the execution is performed once for each selected data set.

Related articles

Update or remove test data