Update test data

Update the imported test data by choosing whether to create a new file or overwrite existing 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.

For Data Service entities, you can update the test case using new filter through the Query Builder.

1. Open Studio and navigate to your project.
2. In the Project panel, right-click a test case with data variations and select Update test data.
3. Select a data source from the Source dropdown list.

For Files (e.g., Excel), you need to browse for the file and select the Worksheet. You can select individual or all values from the file.

For Data Service, you need to select an entity.

4. (Optional) Select Update all test cases using the same test data to update all the test cases that use the test data that you are currently editing.
5. Click Import to save changes.

You can perform this action in Test Explorer by right-clicking a file, and then choosing Update Test Data.

Remove test data

Remove test data from the test case.

1. Open Studio and navigate to your project.
2. In the Project panel, right-click a test case with data variations and select Remove test data.

You can perform this action in Test Explorer by right-clicking a file, and then choosing Remove Test Data.

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.

Only for test data files.

1. Open Studio and navigate to your project.
2. Navigate to Project > Test Data and open the JSON file with a code editor.
   The JSON file name is stored as ExcelName_SheetNo.json.