In this video we will talk about Test Data. During an API load test we can use test data from the local Datatable,... Or we can reference an external data source. To do this we need to open the Test Settings dialog,.. And here we need to select the Test Data option and click the Configure Test Data button. To do the same thing in the LOAD module, we just need to select the Custom Datasource checkbox for the vuser group, and click the Configure Test Data button. To select a data source file we need to click the Browse button, and navigate to the file in the File System. ZAPTEST supports Excel or CSV file formats. For an Excel file we can select a worksheet. Like in the datatable, columns in a test data file must correspond to parameters. The first row values must represent parameter names. And the list of parameters must match parameters used in the test script. Let's review all the options available on the Test Data dialog. The Sequential Order Data Selection Mode will assign same set of data to all virtual users, Iteration of the data rows will be done in a normal or sequential order. With this data selection mode we can specify any of the Data Range Policies - , Run through all data rows, Run through specific range of rows, or Run through all data rows starting from a specific one. For the Out of Values Policy, the Stop Test option will stop the virtual user once it iterates through all assigned data rows. The Cycle option in turn allows reusing the assigned data for as long as the test will continue to run. The "Sequential Any" Data Selection Mode will assign same set of data to all virtual users, But Iteration of the data rows will be done in random order with using each row only once in a cycle. This mode provides better test data coverage, especially for big data sets when order of accessing data is not important. With this mode we can specify any Data Range Policy, or any Out of Values Policy. The Random Data Selection Mode will assign same set of data to all virtual users, Iteration of the data rows will be done in true random order without a reference to cycles. With this mode we can specify any Data Range Policy, The Out of Values Policy is not relevant for the Random mode. The Unique Data Selection mode will divide the test data into equal portions and distribute them between virtual users. With this mode we can allow Automatic Allocation based on maximum number of virtual users in a group; Or we can divide test data manually by specifying number of rows for each virtual user. With this mode we can specify any Data Range Policy, The Out Of Values Policy will always stop a virtual user when it runs out of its allocated test data. Once we configured the usage of a Test Data, we will click the OK button. The datatable iteration controls can not be applied to an external test data and they become disabled in the Test Settings. The external test data now will be used in the 1SCRIPT, Multi-Run, and LOAD test executions. The Datatable with show simulation of the test data ... as data rows used can be different from the displayed in case of the Sequential Any or Random Data Selection Modes.