Clarity

Expand all | Collapse all

How to get the values without double quotes from JSON response

  • 1.  How to get the values without double quotes from JSON response

    Posted Dec 07, 2017 09:32 AM

    Hi,

     

    Am getting the below JSON response.  Can Someone Suggest How can we get the values without double quotes for the fields startDate & releaseDate in gelscript. Thanks !

     

    [
    {
    "self": "https://abc.xyz.com/rest/api/2/version/11400",
    "id": "11400",
    "description": "November 2017",
    "name": "November",
    "archived": false,
    "released": false,
    "startDate": "2017-10-24",
    "releaseDate": "2017-11-20",
    "overdue": true,
    "userStartDate": "24/Oct/17",
    "userReleaseDate": "20/Nov/17",
    "projectId": 11219
    },
    {
    "self": "https://abc.xyz.com/rest/api/2/version/11929",
    "id": "11929",
    "description": "December 2017 - Ph1",
    "name": "December 2017",
    "archived": false,
    "released": false,
    "startDate": "2017-12-01",
    "releaseDate": "2017-12-12",
    "overdue": false,
    "userStartDate": "01/Dec/17",
    "userReleaseDate": "12/Dec/17",
    "projectId": 11219
    },
    {
    "self": "https://abc.xyz.com/rest/api/2/version/11930",
    "id": "11930",
    "description": "December Ph 2 - 2017",
    "name": "December - 2 2017",
    "archived": false,
    "released": false,
    "startDate": "2017-12-13",
    "releaseDate": "2017-12-22",
    "overdue": false,
    "userStartDate": "13/Dec/17",
    "userReleaseDate": "22/Dec/17",
    "projectId": 11219
    },
    {
    "self": "https://abc.xyz.com/rest/api/2/version/11931",
    "id": "11931",
    "description": "December Ph3 - 2017",
    "name": "December-3 2017",
    "archived": false,
    "released": false,
    "startDate": "2017-12-23",
    "releaseDate": "2017-12-31",
    "overdue": false,
    "userStartDate": "23/Dec/17",
    "userReleaseDate": "31/Dec/17",
    "projectId": 11219
    },
    {
    "self": "https://abc.xyz.com/rest/api/2/version/11932",
    "id": "11932",
    "description": "January 2018",
    "name": "January 2018",
    "archived": false,
    "released": false,
    "startDate": "2018-01-01",
    "releaseDate": "2018-01-24",
    "overdue": false,
    "userStartDate": "01/Jan/18",
    "userReleaseDate": "24/Jan/18",
    "projectId": 11219
    }
    ]



  • 2.  Re: How to get the values without double quotes from JSON response
    Best Answer

    Posted Dec 08, 2017 04:43 AM

    Hi Rajkumar_Saminathan ,

     

    Please refer to a sample code for extracting data from Json in gel scripting.

     

                <!-- Get JSONArray from response string -->
                <core:new className="org.json.JSONArray" var="J_ProjectInfo" ><core:arg type="java.lang.String" value="${JiraProjectInfo}" /></core:new>

               
    <!-- Set length for Result Array -->

                <core:set var="len_jarrResults" value="${J_ProjectInfo.length()}"/>
                <core:set var="i" value="${J_ProjectInfo.length()-1}"/>
                <core:set var="Count" value="${J_ProjectInfo.length()-i}"/>

               
    <core:while  test="${i >= 0}">

                    <!-- Get the Status JSON Object -->
                    <core:set var="jsonWorklog"             value="${J_ProjectInfo.get(i)}"/>

                   
    <!-- Get the values from response -->

                        <core:set var="releaseDate"     value="${jsonWorklog.get('releaseDate')}"/>
                        <core:set var="startDate"       value="${jsonWorklog.get('startDate')}"/>
                    <core:set var="i" value="${i-1}"/>
                    <core:set var="Count" value="${Count+1}"/>
                </core:while>


  • 3.  Re: How to get the values without double quotes from JSON response

    Posted Dec 08, 2017 09:36 AM

    Thank you so much Prashank !

     

    It helps me a lot !