how can I get value from json object in groovy

user_9376668 0
Viewed 11193
def RawRecordsDateRangeResponse = context.expand('${getRawRecordsForDateRange#Response}')   
    log.info RawRecordsDateRangeResponse

My response is:

{"2018-09-03":"https://dhap-dconnect-telemetry-data-dev2.s3.amazonaws.com/ULT/d83350d2-af56-11e8-b612-0242ac11001118/temperature/raw-2018-09-03.json"}

Here I want to get the value from the json response key as date.

soapui groovy
2 Answers

Your response represents JSON document and it stores it in variable of type String. You can parse it using groovy.json.JsonSlurper class. Consider following example:

import groovy.json.JsonSlurper

def RawRecordsDateRangeResponse = context.expand('${getRawRecordsForDateRange#Response}')

def json = new JsonSlurper().parseText(RawRecordsDateRangeResponse)

def url = json.'2018-09-03'

println url

Output:

https://dhap-dconnect-telemetry-data-dev2.s3.amazonaws.com/ULT/d83350d2-af56-11e8-b612-0242ac11001118/temperature/raw-2018-09-03.json
user_21944700

If it's just the key of the JSON message you need rather than the value, you could use something like:

import groovy.json.JsonSlurper

def rawRecordsDateRangeResponse = '''{"2018-09-03":"https://dhap-dconnect-telemetry-data-dev2.s3.amazonaws.com/ULT/d83350d2-af56-11e8-b612-0242ac11001118/temperature/raw-2018-09-03.json"}'''
def json = new JsonSlurper().parseText(rawRecordsDateRangeResponse)

def date = json.collect({it.key})
print date

This produces [2018-09-03].

user_7516210
Related