Forum Discussion

PriyankaP's avatar
PriyankaP
Contributor
7 years ago

How to Parameter database value to the response xml?

Once I create the DataBase Connection in Servicev PRO that database table values should be parametarize to Response xml like we do using excel.

 

How to parametarize table value in response xml?

Also how to do data-manipulation queries in servicev db

  • Hi, 

     

    Once the connection has been created, you build the sql query and store that columns data in custom props (query builder does that for you automatically) so all you have to do is, choose the correct data source from your response and then ${#MockResponse#ColumnName} 

     

     

  • jhanzeb1's avatar
    jhanzeb1
    Frequent Contributor

    Hi, 

     

    Once the connection has been created, you build the sql query and store that columns data in custom props (query builder does that for you automatically) so all you have to do is, choose the correct data source from your response and then ${#MockResponse#ColumnName}