To restrict entering null values in JSON object

aks4
Tera Contributor

I have created a Script Include method to fetch fields and corresponding values of a user record from User table. I am trying to build a JSON object for the records without an empty values. I am getting JSON object output with null values as well which I want not to include while building. Can anyone help.

 

getCreatedBy: function(taskRecord) {
var userArray = [];
var taskUser = new GlideRecord('sys_user');
taskUser.addQuery('sys_id', '35f8c8932f8068100d5aa85df699b62c');
taskUser.query();
if (taskUser.next()) {
var fields = new GlideRecordUtil().getFields(taskUser);
var fieldName = '';
for (var i = 0; i < fields.length; i++) {

fieldName = fields[i];
var obj={};

if(taskUser.getDisplayValue(fieldName) != '');
obj[fieldName]=taskUser.getDisplayValue(fieldName);
userArray.push(obj);
}
}




gs.log(JSON.stringify(userArray));
return userArray;
},

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

update as this

getCreatedBy: function(taskRecord) {
    var userArray = [];
    var taskUser = new GlideRecord('sys_user');
    taskUser.addQuery('sys_id', '35f8c8932f8068100d5aa85df699b62c');
    taskUser.query();
    if (taskUser.next()) {
        var fields = new GlideRecordUtil().getFields(taskUser);
        var fieldName = '';
        for (var i = 0; i < fields.length; i++) {

            fieldName = fields[i];
            var obj = {};
            if(taskUser.getDisplayValue(fieldName) != ''){
                obj[fieldName]=taskUser.getDisplayValue(fieldName);
                userArray.push(obj);
            }
        }
    }

    gs.log(JSON.stringify(userArray));
    return userArray;
},

 

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

2 REPLIES 2

aks4
Tera Contributor

@Ankur Bawiskar Could you please help me with this case.

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

update as this

getCreatedBy: function(taskRecord) {
    var userArray = [];
    var taskUser = new GlideRecord('sys_user');
    taskUser.addQuery('sys_id', '35f8c8932f8068100d5aa85df699b62c');
    taskUser.query();
    if (taskUser.next()) {
        var fields = new GlideRecordUtil().getFields(taskUser);
        var fieldName = '';
        for (var i = 0; i < fields.length; i++) {

            fieldName = fields[i];
            var obj = {};
            if(taskUser.getDisplayValue(fieldName) != ''){
                obj[fieldName]=taskUser.getDisplayValue(fieldName);
                userArray.push(obj);
            }
        }
    }

    gs.log(JSON.stringify(userArray));
    return userArray;
},

 

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader