Let’s now add a data source to our virtual service.
In the virtual service editor, switch to the DataSources page. Click on the toolbar to create a new data source. In the subsequent dialog, select the data source name and click OK:
By default, the new data source will have the Excel type:
Click Browse and select the currency_converter_sample.xls file that you downloaded earlier to your computer.
After you selected the file, ReadyAPI will suggest importing properties. In ReadyAPI terms, data source properties are names of the columns that the data source exports. So, ReadyAPI suggests importing column names from the Excel file. Click Yes.
You will see the following dialog:
Here, you can select the worksheet for importing column names and the cell of the first column. Keep the default values and click OK to continue.
ReadyAPI will take the column names from the first row of the first worksheet it finds in the Excel file. You will see the property names on the DataSources page:
Now, we can include data into responses.