Virtualize : Use Database as datasource and parameterize SQL query
We are using excel as a datasource and parameterized the responder response.
Since excel has limitations on rows , I wanted to use Database as a datasource.
But, if i use database , the query needs to be parameterized since account number i use is unique every time.
Based on the account number i need to get the rows from the database and have to parameterize the responder response using the columns that are retrieved in result set.
Can someone help on this please ?