Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to get last sys id value in the array

AnilM99
Tera Expert

Hi team,

I need help in below script:

var responseBody = [{"title":"Videos","sysid":"2eiej589eady9e6aesblo52"},{"title":"Sales","sysid":"25ic5ej589eady9e6aesblo87oed3"},{"title":"Enablement","sysid":"d9e3seady9e6aesblo525eplse36"}];

I want last 'sysid' of responseBody

this is only example i have 500 sysids in responseBody

 

Thanks

anil

1 ACCEPTED SOLUTION

Amit Pandey
Kilo Sage
var responseBody = [{"title":"Videos","sysid":"2eiej589eady9e6aesblo52"},{"title":"Sales","sysid":"25ic5ej589eady9e6aesblo87oed3"},{"title":"Enablement","sysid":"d9e3seady9e6aesblo525eplse36"}];

var lastItem = responseBody[responseBody.length - 1];

var lastSysId = lastItem.sysid;

gs.info("Last 'sysid' of responseBody:" +lastSysId);

 

AmitPandey_0-1712665729828.png

 

Please mark my answer helpful and correct.

 

Regards,
Amit

 

View solution in original post

7 REPLIES 7

Community Alums
Not applicable

Hi @AnilM99 ,

Please refer to this Sample Script , which can help you :

var GetMoreInfoUpdatedChangeTickets = Class.create();
GetMoreInfoUpdatedChangeTickets.prototype = {
    initialize: function() {
    },
    getSysIds:  function() {
        var sysIdArray = [];
        var grApprovalGroup = new GlideRecord('sysapproval_group');
        grApprovalGroup.addQuery('parent.sys_class_name', 'change_request');
        grApprovalGroup.query();

        while (grApprovalGroup.next()) {
            sysIdArray.push(grApprovalGroup.getValue('sys_id'));
        }
        return sysIdArray;
    },
    type:       'GetMoreInfoUpdatedChangeTickets'
};

 

 

dgarad
Giga Sage

Hi @AnilM99 

 you can try the below code.

var responseBody = ['sysid','sysid','sysid','sysid','sysid','sysid','sysid','sysid','sysid','sysid','sysidlast'];

gs.info(responseBody.slice(-1));

 

If my answer finds you well, helpful, and related to the question asked. Please mark it as correct and helpful.

Thanks
dgarad

dgarad
Giga Sage

Hi @AnilM99 

 

Try the below code.

var responseBody = [{"title":"Videos","sysid":"2eiej589eady9e6aesblo52"},{"title":"Sales","sysid":"25ic5ej589eady9e6aesblo87oed3"},{"title":"Enablement","sysid":"d9e3seady9e6aesblo525eplse36"}];


var lastElement = responseBody[responseBody.length-1].sysid;

gs.info(lastElement);

 

If my answer finds you well, helpful, and related to the question asked. Please mark it as correct and helpful.

Thanks
dgarad

Amit Pandey
Kilo Sage
var responseBody = [{"title":"Videos","sysid":"2eiej589eady9e6aesblo52"},{"title":"Sales","sysid":"25ic5ej589eady9e6aesblo87oed3"},{"title":"Enablement","sysid":"d9e3seady9e6aesblo525eplse36"}];

var lastItem = responseBody[responseBody.length - 1];

var lastSysId = lastItem.sysid;

gs.info("Last 'sysid' of responseBody:" +lastSysId);

 

AmitPandey_0-1712665729828.png

 

Please mark my answer helpful and correct.

 

Regards,
Amit