Forum Discussion

SuperSingh's avatar
SuperSingh
Contributor
9 years ago
Solved

Saving request and response to an external file for "JDBC Request" and "Groovy Scripts"

I have script that saves Request and Response XML's (to an external file) for my regular REST calls in SoapUI.   However, I want to save the Request and Response of the following 1. JDBC Step (Req...
  • SuperSingh's avatar
    SuperSingh
    9 years ago

    I got it . The following is the difference and it works.

     

    def ResFile ="C:/Testing Lab/Soap TestBed/Response Data/Response1.xml"
    def Res = context.expand( '${Rate#ResponseAsXml}' )
    def j = new File(ResFile)
    j.write(Res, "UTF-8")

     

    Thanks all for the help !

     

    Thanks,

    PredatorSingh

SuperSingh's avatar
SuperSingh
Contributor
9 years ago

I've shared the script you've asked for. I tried fitting my JDBC in that script, but doesn't work.

Appreciate any help here.

 

Thanks,

Predator.

nmrao's avatar
nmrao
Community Hero
9 years ago
SuperSingh,

Have you tried the same context.expand( '${JDBCTestStep#Request}' ) - change the test step name in place of JDBCTestStep and the same for response as well.

If you have already tried that and still did not work? then quite strange.
  • SuperSingh's avatar
    SuperSingh
    Contributor
    9 years ago

    nmrao I did try that step. But it doesn't work.

    It creates a file with no data in it. I tried changing the file formats to .txt but no luck . :(

    • nmrao's avatar
      nmrao
      Community Hero
      9 years ago
      Can show the the raw request and response of jdbc step?
    • SuperSingh's avatar
      SuperSingh
      Contributor
      9 years ago

      I got it . The following is the difference and it works.

       

      def ResFile ="C:/Testing Lab/Soap TestBed/Response Data/Response1.xml"
      def Res = context.expand( '${Rate#ResponseAsXml}' )
      def j = new File(ResFile)
      j.write(Res, "UTF-8")

       

      Thanks all for the help !

       

      Thanks,

      PredatorSingh