Want to fetch field value from response of GET REST message

[Vishwas Kulkarn]

Hi @Ankur Bawiskar 

I am calling GET method and fetching below response.

[{
    "expand": "description,lead,issueTypes,url,projectKeys,permissions,insight",
    "self": "https://.atlassian.net/rest/api/3/project/10013",
    "id": "10013",
    "key": "ACQINT",
    "name": "Acquisition Integrations",
    "avatarUrls": {
        "48x48": "https://.atlassian.net/rest/api/3/universal_avatar/view/type/project/avatar/10412",
        "24x24": "https://.atlassian.net/rest/api/3/universal_avatar/view/type/project/avatar/10412?size=small",
        "16x16": "https://.atlassian.net/rest/api/3/universal_avatar/view/type/project/avatar/10412?size=xsmall",
        "32x32": "https://.atlassian.net/rest/api/3/universal_avatar/view/type/project/avatar/10412?size=medium"
    },
    "projectTypeKey": "software",
    "simplified": false,
    "style": "classic",
    "isPrivate": false,
    "properties": {}
}, {
    "expand": "descrip

I want to show id, key and name three fields from above response.

Pls. find my code below

var r = new sn_ws.RESTMessageV2('JiraIntegrationEndpoint', 'Get Issue Details');
        r.setEndpoint("https://.atlassian.net/rest/api/3/project");
        var response = r.execute();
        var responseBody = JSON.parse(response.getBody());
        var httpStatus = response.getStatusCode();
        

        gs.print("responseBody Project:" + responseBody);
        gs.print("httpStatus Project:" + httpStatus);
  
        var ot = JSON.stringify(responseBody);

        gs.print("responseBody Project ID:" + ot);

        var name= [];
        var id = [];
        var key = [];
        for (var i = 0; i < ot.length; i++) {
            name.push('' + ot[i].name);
            id.push('' + ot[i].id);
            key.push('' + ot[i].key);
        }

        if (httpStatus == '200') {
            if (responseBody.length != 0) {

                gs.print("responseBody inside if Projects:" + ot);
}

}

Could you please help me in this?

[Ankur Bawiskar]

Hi,

please update as this and test

you need to parse the responsebody using JSON.parse

var r = new sn_ws.RESTMessageV2('JiraIntegrationEndpoint', 'Get Issue Details');
r.setEndpoint("https://.atlassian.net/rest/api/3/project");
var response = r.execute();
var responseBody = JSON.parse(response.getBody());
var httpStatus = response.getStatusCode();

var ot = JSON.parse(responseBody);

var name= [];
var id = [];
var key = [];
for (var i = 0; i < ot.length; i++) {
    name.push('' + ot[i].name);
    id.push('' + ot[i].id);
    key.push('' + ot[i].key);
}

gs.info("name"+name);
gs.info("id"+id);
gs.info("key"+key);

if (httpStatus == '200') {
    if (responseBody.length != 0) {
        gs.print("responseBody inside if Projects:" );
    }
}

Regards
Ankur

[Vishwas Kulkarn]

Hi @Ankur Bawiskar 

I am getting below output.

[Vishwas Kulkarn]

I got this.

I just wrote 

 var ot = responseBody; 

instead of 

var ot = JSON.parse(responseBody);

Thank you Ankur.

[Vishwas Kulkarn]

Hi @Ankur Bawiskar ,

can you please tell me how can I capture below response in custom table?

[Ankur Bawiskar]

Hi,

for each array iteration you can insert data into your custom table

Regards
Ankur