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.
-
Click Use a wizard.
-
The Build SQL Query wizard appears.
Browse through the database to find the necessary data.
-
Double-click to select Person > Tables > Address.
-
Select the City check box.
The data you selected appears in different views.
-
Click OK.
The SQL Query you have created appears in the test step.
ReadyAPI also automatically creates a matching Person_Address_City
property. You can use this property later to fetch the data from the data source.
Now, you can use the new query in requests.