We set up our service using a request and response pair and are currently using the SQL Database Execution (JDBC) step to return database results. We want to take the results from the database and format them into the same JSON format as the response file we used to set up the service. However, I am very new to using CA DevTest and do not know if there is a way to do this.
I was thinking of using an Execute Script (JSR-223) step to format the JSON but am not sure if this is the most efficient way or how to import the database results as an array.
Is there functionality in DevTest that will take SQL database results and format them into a predetermined JSON format for response?
Thanks and let me know if you need any more details about my project.