We are trying to create a json virtual service using data from database.
We thought about differents ways :
- using "SQL database execution" step, but we were not able to use the result on the next step (on workstation, testing SQL is working, testing filter is working, but on VSE the result is not available in "Virtual https responder" step)
- using "Read Rows from a JDBC Table" step (as described here : Hi, I need to capture JDBC result set into variable ), we need to implement/test it
- using "XSL transformation" as described here Perform JDBC Query to JSON Response but we didn't found the "XSL Transformation assertion"
What is the best way to achieve our aim ? Is there any tutorial available ?