Data-Driven Testing

Use DataSource, DataLoop, and DataSink steps to run tests with multiple data sets.

DataSource step setup

text
In a test case, right-click → Add Step → DataSource

Type: Excel (xlsx / xls)
File: test-data/users.xlsx
Worksheet: Sheet1
Columns: username, password, expectedRole

Or type: CSV
File: test-data/users.csv

DataLoop step

text
Right-click → Add Step → DataLoop
Start step: DataSource (your data source step)
End step: (last step before loop back)

This loops the steps between DataSource and DataLoop
for each row in the data file.

Use data in requests

text
In your request body use property expansion:
{
  "username": "${DataSource#username}",
  "password": "${DataSource#password}"
}

In assertions use:
JSONPath: $.role
Expected: ${DataSource#expectedRole}