Parse JSON using groovy script (using JsonSlurper)

Question

I am just two days old to groovy, I need to parse a json file with below structure. My actual idea is I need to run a set of jobs in different environments based on different sequences, so I came up with this format of json as a input file to my groovy

{
    "services": [{
        "UI-Service": [{
            "file-location": "/in/my/server/location",
            "script-names": "daily-batch,weekly-batch,bi-weekly-batch",
            "seq1": "daily-batch,weekly-batch",
            "seq2": "daily-batch,weekly-batch,bi-weekly-batch",
            "DEST-ENVT_seq1": ["DEV1", "DEV2", "QA1", "QA2"],
            "DEST-ENVT_seq2": ["DEV3", "DEV4", "QA3", "QA4"]
        }]
    }, {
        "Mobile-Service": [{
            "file-location": "/in/my/server/location",
            "script-names": "daily-batch,weekly-batch,bi-weekly-batch",
            "seq1": "daily-batch,weekly-batch",
            "seq2": "daily-batch,weekly-batch,bi-weekly-batch",
            "DEST-ENVT_seq1": ["DEV1", "DEV2", "QA1", "QA2"],
            "DEST-ENVT_seq2": ["DEV3", "DEV4", "QA3", "QA4"]
        }]
    }]
}

I tried below script for parsing the json

        def jsonSlurper = new JsonSlurper()
        //def reader = new BufferedReader(new InputStreamReader(new FileInputStream("in/my/location/config.json"),"UTF-8"))
        //def data = jsonSlurper.parse(reader)
        File file = new File("in/my/location/config.json")
        def data = jsonSlurper.parse(file)

        try{
            Map jsonResult = (Map) data;
            Map compService = (Map) jsonResult.get("services");
            String name = (String) compService.get("UI-Service");
            assert name.equals("file-location");

        }catch (E){
            println Exception
        }

I need to first read all the services (UI-service, Mobile-Service, etc..) then their elements and their value

tim_yates · Accepted Answer · 2017-03-06 15:32:52Z

3

Or you could do something like:

new JsonSlurper().parseText(jsonTxt).services*.each { serviceName, elements ->
    println serviceName
    elements*.each { name, value ->
        println "    $name = $value"
    }
}

But it depends what you want (and you don't really explain in the question)

answered Mar 6, 2017 at 15:32

tim_yates

172k29 gold badges359 silver badges354 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mowgli Over a year ago

From the user I am getting only envt name(ex: DEV2 or QA3) as input, based on that I need to retrieve data, #1 - Need to find which DEST-ENVT_seq group that belongs to(ex:DEST-ENVT_seq2) and then based on the groupname I need to find the seq(ex: seq2) and copy those file from file-location and execute

Tidhar Klein Orbach · Accepted Answer · 2017-03-05 11:29:04Z

2

Example for reading from JsonParser object:

def data = jsonSlurper.parse(file)
data.services.each{ 
    def serviceName = it.keySet()
    println "**** key:${serviceName}  ******"
    it.each{ k, v ->
        println "element name: ${k}, element value: ${v}"
    }
}

other options:

println data.services[0].get("UI-Service")["file-location"]
println data.services[1].get("Mobile-Service").seq1

answered Mar 5, 2017 at 11:29

Tidhar Klein Orbach

2,9842 gold badges34 silver badges49 bronze badges

Collectives™ on Stack Overflow

Parse JSON using groovy script (using JsonSlurper)

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related