7. Use the Query Wizard

Applies to ReadyAPI 3.5, last modified on January 19, 2021

To get the database data, you need to prepare the query. You can write it manually, or use a Query Builder Wizard . For purposes of this tutorial, use the latter.

You can access the Query Builder in the data source test step window, below the SQL Query box.

  1. Click Use a wizard.

    ReadyAPI: Opening the Query Builder

    Click the image to enlarge it.

  2. The Build SQL Query wizard appears.

    ReadyAPI: The Build SQL Query wizard

    Click the image to enlarge it.

    Browse through the database to find the necessary data.

  3. Double-click to select Person > Tables > Address.

  4. Select the City check box.

    ReadyAPI: Finding the data in the SQL Query wizard

    Click the image to enlarge it.

    The data you selected appears in different views.

  5. Click OK.

The SQL Query you have created appears in the test step.

ReadyAPI: The data source test step with the SQL query

Click the image to enlarge it.

ReadyAPI also automatically creates a matching Person_Address_Cityproperty. You can use this property later to fetch the data from the data source.

Now, you can use the new query in requests.

Prev          Next

See Also

Microsoft SQL Databases as Data Sources

Highlight search results