Forum Discussion

PriyankaP's avatar
PriyankaP
Contributor
6 years ago
Solved

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? A...
  • jhanzeb1's avatar
    jhanzeb1
    6 years ago

    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
6 years ago

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}