Forum Discussion

AndrewGeorgiou's avatar
AndrewGeorgiou
Occasional Visitor
2 years ago

How to save to a file

I am using SoapUO 5.7.0 and i have a Execute query to get data.

 

I get the data but i need to automate this through a windows schedule and have it run to create a file for me on a daily basis.

 

Have any one done that where you can run it and create a file?

 

Any advice it would be greatly apprecited.

 

Thank you,

Andrew

Data-Driven Testing
Reporting
REST
Scripting
SOAP
  • nmrao's avatar
    nmrao
    2 years ago

    SoapUI installation also provides command line tools(%SOAPUI_HOME%/bin/testrunner.bat) to execute the SoapUI project / test suite / test case. Please check here

     

    And windows scheduler task allows to run the commands. So you are good.

     

    Coming to the actual problem, i think, saving the response xml of jdbc test step is easily possible with below script.

     

    Add this script as Script Assertion to the JDBC Request step itself: And provide the directory for path variable in the script.

    //Check if there is response
assert context.request, "Request is empty or null"

//Update the below value
def path = '/directory/path/to/store/responses'
def name_prefix = java.time.LocalDate.now().toString()

//Save the contents to a file
def saveToFile(file, content) {
    if (!file.parentFile.exists()) {
         file.parentFile.mkdirs()
         log.info "Directory did not exist, created"
    }
    file.write(content) 
    assert file.exists(), "${file.name} not created"
}

def f = new File("${path}/${name_prefix}_Response.xml")
saveToFile(f, context.response)

     

    Try to execute the SoapUI project using command line and ensure response is saved before putting that into windows scheduler.

    NOTE: the above script saves the response with today's date as prefix in its file name.

  • nmrao's avatar
    nmrao
    Champion Level 3
    2 years ago

    SoapUI installation also provides command line tools(%SOAPUI_HOME%/bin/testrunner.bat) to execute the SoapUI project / test suite / test case. Please check here

     

    And windows scheduler task allows to run the commands. So you are good.

     

    Coming to the actual problem, i think, saving the response xml of jdbc test step is easily possible with below script.

     

    Add this script as Script Assertion to the JDBC Request step itself: And provide the directory for path variable in the script.

    //Check if there is response
assert context.request, "Request is empty or null"

//Update the below value
def path = '/directory/path/to/store/responses'
def name_prefix = java.time.LocalDate.now().toString()

//Save the contents to a file
def saveToFile(file, content) {
    if (!file.parentFile.exists()) {
         file.parentFile.mkdirs()
         log.info "Directory did not exist, created"
    }
    file.write(content) 
    assert file.exists(), "${file.name} not created"
}

def f = new File("${path}/${name_prefix}_Response.xml")
saveToFile(f, context.response)

     

    Try to execute the SoapUI project using command line and ensure response is saved before putting that into windows scheduler.

    NOTE: the above script saves the response with today's date as prefix in its file name.