Data Pane (API Testing)

For details about the GUI testing Data Pane interface, see Data Pane (GUI Testing). For details about the BPT Data Pane interface, see Data Pane (BPT in UFT One).

Relevant for: API testing only

The Data pane enables you to add, view, and edit data sources for use as property values when running tests. Supported data sources include:

  • Excel spreadsheets

  • Local data tables

  • XML files

  • Results of a database query

Tip: If you use ALM, use a different data resource for each run iteration, or use the same data resource in multiple tests.

To access
  1. Ensure that an API test or component is in focus in the document pane or selected in the Solution Explorer.

  2. Select View > Data or select the Data pane tab.

Important information

Click a node in the left pane to view the contents of a data source.

  • Excel data with column headers beginning with digits or containing symbols (such as !, @, or # ) are not supported.

  • XML data sources: .xml files that use XSL are not supported.

Relevant tasks

Add data sources to an API test

Assign data to API test/component steps

Navigate within a data source

See also

Data Usage in API Tests

User interface elements are described below (unlabeled elements are shown in angle brackets):

UI Element


<data source tree>

A hierarchy of the data sources and their subnodes, displayed in the left pane.

For Excel files, each sheet represents another set of properties.

<data source content>

The data associated with the selected node, including calls to another test or action with its own data source, displayed in the right pane.

To view data from other tests or actions, click the node in the original location of the data, and enable the Allow other tools to override the data option.

New Data Source. Creates a new a data source.

Remove. Removes the selected data source from the Data pane.

Go back. Returns to the previous view.

Go to start. Returns to the first row.

Go to the previous row. Navigates to the previous row (one row up).


The current row number out of the total rows, such as 1/3. Use the drop down to move to the desired row.


A title for the row currently displayed.

Go to the next row. Navigates to the next row (one row down).

Go to end. Navigates to the last row.

Import data from an XML file. Loads data from an XML file.

Export data from an XML file. Exports the current data to an XML file.

Move up. Moves the current row forwards.

Move down. Moves the current row backwards.

Adds a new empty row.

Duplicates the current row.

Deletes the current row.

Refresh. Updates the data from the database.

Count. Opens a message box with a row count.

By default the Data pane shows the first ten rows of the query data. To change the number of displayed rows, use the General Pane.