How to get specific value from Json response using SOUPUI

Question

I am very new to SOUPUI, I am able to read the response for restapi and able to save to file, I struked at this place i want to store a value from the response. Please help.

My questions :

How can I store a random employeeId from the following response.(Pick any of the employeeId randomly)?
How to get specific employeeId using employee name(Like i want to get "employeeId" if "firstName" name is "Daitha")?
How can i read the employeeId using array (Like first , second ..employeeId)?

Following is the sample response:

{
    "response": {
        "stat": "SUCCESS",
        "result": {
            "employees": [{
                "employeeId": "7d58129a-5ca3-4acd-a601-11478ba47988",
                "firstName": "Daitha",
                "lastName": "shankar",
                "loginName": "xxxxx@xxx.com",
                "mobileNumber": "xxxxxxxxxxxx",
                "emailId": "xxxxxxx@xxxx.com",
                "rowStatus": "A",
                "assetCount": 3087,
                "canUseapp": "Y",
                "supportUserInd": "N"
            }, {
                "employeeId": "e2dec6de-8882-4c5b-a875-41fffe8e977f",
                "firstName": "john",
                "lastName": "deo",
                "loginName": "xxxx@yyy.com",
                "emailId": "xxxx@xxx.com",
                "rowStatus": "A",
                "assetCount": 0,
                "canUseapp": "Y",
                "supportUserInd": "N"
            }, {
                "employeeId": "9a9e7ff6-edb7-402a-bed2-27e9036a716f",
                "tenantBadgeId": "EMP11659824",
                "firstName": "suman",
                "lastName": "m",
                "loginName": "eeee@sfsdf.om",
                "mobileNumber": "xxxxxx",
                "emailId": "xxxxxx@xxxxxx.com",
                "rowStatus": "A",
                "designation": "software QA engineer",
                "assetCount": 0,
                "canUseapp": "Y",
                "supportUserInd": "N"
            }, {
                "employeeId": "9ecf7fc8-c06d-4e3c-a3a3-d2c50509c16b",
                "firstName": "vinay",
                "lastName": "B",
                "loginName": "xxxxxx@.dsfsd.com",
                "emailId": "xxxxx.@xxxx.com",
                "rowStatus": "A",
                "assetCount": 0,
                "canUseapp": "Y",
                "supportUserInd": "N"
            }]
        }
    }
}

Thanks in Advance

Suggest me any groovy script.. which can solve problem. – Shankar Daitha Jul 13 '16 at 04:47 — Shankar Daitha, Jul 13 '16 at 04:47

score 1 · Answer 1 · answered Aug 03 '16 at 10:06

<!DOCTYPE html>
<html>
<body>

<p>How to create a JavaScript object array.</p>

<p id="demo"></p>

<script>
var employees = '[{"employeeId": "7d58129a-5ca3-4acd-a601-11478ba47988","firstName": "Daitha","lastName": "shankar","loginName": "xxxxx@xxx.com","mobileNumber": "xxxxxxxxxxxx","emailId": "xxxxxxx@xxxx.com","rowStatus": "A","assetCount": 3087,"canUseapp": "Y","supportUserInd": "N"}, {"employeeId": "e2dec6de-8882-4c5b-a875-41fffe8e977f","firstName": "john","lastName": "deo","loginName": "xxxx@yyy.com","emailId": "xxxx@xxx.com","rowStatus": "A","assetCount": 0,"canUseapp": "Y","supportUserInd": "N"}, {"employeeId": "9a9e7ff6-edb7-402a-bed2-27e9036a716f","tenantBadgeId": "EMP11659824","firstName": "suman","lastName": "m","loginName": "eeee@sfsdf.om","mobileNumber": "xxxxxx","emailId": "xxxxxx@xxxxxx.com","rowStatus": "A","designation": "software QA engineer","assetCount": 0,"canUseapp": "Y","supportUserInd": "N"}, {"employeeId": "9ecf7fc8-c06d-4e3c-a3a3-d2c50509c16b","firstName": "vinay","lastName": "B","loginName": "xxxxxx@.dsfsd.com","emailId": "xxxxx.@xxxx.com","rowStatus": "A","assetCount": 0,"canUseapp": "Y","supportUserInd": "N"}]';

var arr = JSON.parse(employees);
    var i;
    var out = "<table>";

    for(i = 0; i < arr.length; i++) {

    if(arr[i].firstName=="Daitha")
    {
        out += "<tr><td>" +
        arr[i].employeeId +
        "</td><td>" +
        arr[i].firstName +
        "</td></tr>";
     }       
    }
    out += "</table>";
    document.getElementById("demo").innerHTML = out;
</script>

</body>
</html>

score 1 · Accepted Answer · answered Feb 08 '17 at 06:14

Shankar,

you can play around with below groovy script

import groovy.json.JsonSlurper
def responseContent = testRunner.testCase.getTestStepByName("Emp").getPropertyValue("response")
def r = new JsonSlurper().parseText(responseContent)
def employeesSize = r.response.result.employees.size()
//log.info "employee size:"+employeesSize
def list=new Object[4]
for(int i=0;i<employeesSize;i++)
{
    //log.info r.response.result.employees[i].firstName
    list[i] = r.response.result.employees[i].lastName
    log.info list[i]
}
//log.info(list[3])
//log.info "stat:"+r.response.stat
for(int i=0;i<list.size();i++)
{
    //list.each{log.info(it)}
    def p=list[i]
    if(p=="vinay")
    {
        //log.info "yes"
        log.info r.response.result.employees[i].employeeId
    }
    else
    {
        //log.info "no"
    }
}
//log.info r.response.result.employees[0].size()
def listempdata = r.response.result.employees[0]
//log.info listempdata
def k =new Object[r.response.result.employees[0].size()]
for(int j=1;j<r.response.result.employees[0].size();j++){
    //k[j]=listempdata.each{it}.toString().split(",")
    //listempdata.each{log.info (it)}
    //log.info listempdata.lastName 
}

How to get specific value from Json response using SOUPUI

2 Answers2