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.
The SQL Query you have created appears in the test step.
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.