Set the data source navigation properties

Relevant for: API testing only

This task describes how to set the navigation preferences for data stored in tables. You can set different navigation properties for each data source.

Add a data source to the Test Flow or test loop

  1. Associate the necessary data sources with your test.

  2. In the canvas, select the Test Flow or another test loop.

  3. In the Properties pane, select the Data Sources tab . The list of all currently associated data sources is displayed.

  4. In the Data Sources tab, click Add. The Attach Data Source to Loop Dialog Box .

  5. In the Attach Data Source to Loop dialog box, select the data source to add to the loop and click OK.

    The selected data source is now added to the loop and you can use it to link property values.

Back to top

Specify the navigation properties for the data source

  1. In the canvas, select the Test Flow or other test loop.

  2. In the Properties pane, open the Data Sources tab . The list of data sources associated with the current loop is displayed.

  3. In the Data Sources tab, click Edit. The Data Navigation Dialog Box opens.

  4. In the Data Navigation dialog box, specify the Start and End rows.

  5. Indicate the direction in which to move when retrieving data from the table, Forward or Backward, and the number of rows by which to advance for each iteration. Alternatively, you can indicate to move to a random row.

  6. Specify the action to do when reaching the last row- Wrap around or Keep using that row. Click OK.

  7. Back to top

Create a new child relation

This step enables you to specify parent-child data source relations between multiple data sources. You can use parent-child relations for Excel, Local Table, and Database type data sources.

  1. Add at least two or more Excel, Local Table, or Database data sources.

    Note: This can also be a single Excel file with two worksheets.

  2. In the Data pane, select the data source that you want to designate as a parent.

  3. In the Properties, open the Data Source Properties Tab (Properties Pane - API Testing) .

  4. Click the Add button. The Define New/Edit Data Relation Dialog Box opens.

  5. Specify the details of the new relation:

    • The data source to use as the child data source

    • The primary key - the data column in the parent data source

    • The foreign key - the data column in the child data source. This column is used in place of the primary key column in the parent data source when running the test.

    Click OK after specifying the data source details. The data relation is displayed in the Data Source Properties tab for the parent data source.

Back to top