Forum Discussion

Scripter's avatar
Scripter
Occasional Contributor
8 years ago

parsing json via Groovy in soapui

The JSON Data is a response of a rest service(list_files) {"Files": [ {"filepath": "input/file_29112017d.csv"}, {"filepath": "input/file_29112017d.log"}, {"filepath": "input/file_29112017d....
Groovy
json
  • HKosova's avatar
    HKosova
    8 years ago

    Hi Scripter,

     

    SoapUI 5.3.0 uses an older version of the JSONPath library (v0.9.1) which does not seem to support the regex match operator (=~).

     

    Try JsonSlurper instead:

    import groovy.json.JsonSlurper
    ...

    def json = new JsonSlurper().parseText(response)
def csvpath = json.Files.find { it.filepath.endsWith(".csv") }.filepath
log.info csvpath
nmrao's avatar
nmrao
Champion Level 3
8 years ago

Scripter,

 

Looks like you are trying to work it out using JSONPath. But I'am not really good at. Instead here is the solution using Script Assertion for the rest request test step.

 

 

//Check if the response is not empty
assert context.response, 'Response is empty or null'

def json = new groovy.json.JsonSlurper().parseText(context.response)

//Retrieve the filepath needed
def filePath = json.Files.collect { element -> element.find{it.value.endsWith('csv')} }.findAll{it}.first().value
log.info filePath

 

You can also try it quickly online demo with the above given json.