Forum Discussion

rakesh133's avatar
rakesh133
Occasional Contributor
7 years ago

JsonSlurplerGetting Error while Parsing the Json Response

I tried to create a groovy script to parse the JSON response to a variable using JsonSlurper. Though the response Json is in valid format, i am getting an error   def responseContent = testRunner.t...
Groovy
JsonSlurper
parse
REST
Scripting
rakesh133's avatar
rakesh133
Occasional Contributor
7 years ago

nmrao The Json response array is something like below. 

 

[
    {
        "AgreementType": "XXXX",
        "Code": "XXXX",
        "ShortName": "XXXX",
        "Name": "XXXX",
        "Description": "XXXX",
        "DocumentManagementStoreUrl": null,
        "IsActive": true,
        "EffectiveDate": "2013-12-10T00:00:00",
        "TerminationDate": null,
        "WasCreatedInError": false,
        "DataTimeStamp": "2018-05-04T13:34:01Z"
    },
    {
        "AgreementType": "XXXX",
        "Code": "XXXX",
        "ShortName": "XXXX",
        "Name": "XXXX",
        "Description": "XXXX",
        "DocumentManagementStoreUrl": null,
        "IsActive": true,
        "EffectiveDate": "2013-12-10T00:00:00",
        "TerminationDate": null,
        "WasCreatedInError": false,
        "DataTimeStamp": "2018-05-04T13:34:01Z"
    },
    {
        "AgreementType": "XXXX",
        "Code": "XXXX",
        "ShortName": "XXXX",
        "Name": "XXXX",
        "Description": "XXXX",
        "DocumentManagementStoreUrl": null,
        "IsActive": true,
        "EffectiveDate": "2013-12-10T00:00:00",
        "TerminationDate": null,
        "WasCreatedInError": false,
        "DataTimeStamp": "2018-05-04T13:34:01Z"
    },
    {
        "AgreementType": "XXXX",
        "Code": "XXXX",
        "ShortName": "XXXX",
        "Name": "XXXX",
        "Description": "XXXX",
        "DocumentManagementStoreUrl": null,
        "IsActive": true,
        "EffectiveDate": "2013-12-10T00:00:00",
        "TerminationDate": null,
        "WasCreatedInError": false,
        "DataTimeStamp": "2018-05-04T13:34:01Z"
    }
  • nmrao's avatar
    nmrao
    Champion Level 3
    7 years ago
    Should be simple:

    def json = new groovy.json.JsonSlurper().parseText(jsonString)
    log.info json.Code

    Demo
    https://ideone.com/Obt8TV