How to create JSON array in following format.

[Para5]

I have following requirement.

I want Json array such that :

"UserandRoles":[  

                      {  

                            "name":"Abel",

                            "role":"admin"

                      },

                      {  

                            "name":"Abel",

                            "role":"security_admin"

                      },

                       {  

                            "name":"John",

                            "role":"itil"

                      }

                ]

Script is as below:

var info = [];

var Information = {};

var gr = new GlideRecord('sys_users');

gr.addQuery('sys_id',  usersys);

gr.query();

if( gr.next()){

info.name = gr.name.getDisplayValue();
info.Roles = gr.u_roles.getDisplayValue(); // u_role field contain roles in folllowing format role1, role2, role3....

info .push(Information );

}

Thanks,

[jaheerhattiwale]

@Para5 Tried and tested solution.

var mainObject = {

    "UserandRoles" : []

}

var gr = new GlideRecord('sys_user_has_role');

gr.addQuery('user',  usersys);

gr.query();

while( gr.next()){

    var infoObject = {};

    infoObject.name = gr.user.getDisplayValue();

    infoObject.role = gr.role.getDisplayValue();

    mainObject["UserandRoles"].push(infoObject);

}

gs.info(JSON.stringify(mainObject));

Please mark as correct answer if this solves your issue.