Application testing can require working with large data sets to verify the workflow execution and cover corner 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.
You can configure the data variation file to store up to 2Gb of data. The file is named
- Excel data tables (XLSX, XLSM)
- JSON files
- Open your workflow in Studio.
- In the Project panel, right-click a test case and select Add Test Data.
- 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.
- Select individual or all the 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.
You can debug or run your test case using selected or all of your test data.
- In the Design ribbon, click Run file with data variations or Debug file with data variations.
- 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.
The following table lists the actions that you can take for the test cases that contain data variation.
Update test data
Update the imported test data. You can use this when you have made any changes to the Excel file. Any new columns will be added as arguments to the test case.
Remove test data
Remove test data from the test case.
Modify test data JSON file
Update test data directly into the JSON file. The file is created after adding test data to the test case.
Updated 3 months ago