ServiceNow Building a JSON array (using ServiceNow AI - Now Assist for Code)

Below was mostly generated using Now Assist. The future is bright!

retrieveAPMs: function(bDelta) {

var APMs = [];

var responseObj = {

transaction_name: this.CONSTANTS.APM_FULL_IMPORT,

total_apms: '',

apm_list: []

};

var grAPM = new GlideRecord('cmdb_ci_business_app');

grAPM.addEncodedQuery(this.apmquery + this.apmAdditionalquery);

if (bDelta) {

grAPM.addEncodedQuery(this.apmdeltaquery);

responseObj.transaction_name = this.CONSTANTS.APM_DELTA_IMPORT;

}

grAPM.query();

responseObj.total_apms = grAPM.getRowCount();

while (grAPM.next()) {

var APMobj = {

apm_name: grAPM.getValue('name'),

apm_number: grAPM.getValue('number'),

apm_business_owner_euid: grAPM.owned_by.u_euid + '',

apm_business_owner_email: grAPM.owned_by.email + '',

apm_it_application_owner_euid: grAPM.it_application_owner.u_euid + '',

apm_it_application_owner_email: grAPM.it_application_owner.email + '',

apm_approval_group: grAPM.getValue('u_approval_group'),

apm_tech_lead_euid: grAPM.u_tech_lead.u_euid + '',

apm_tech_lead_email: grAPM.u_tech_lead.email + '',

application_services: []

};

var grCIrel = new GlideRecord('cmdb_rel_ci');

grCIrel.addEncodedQuery(this.appservicequery);

grCIrel.addQuery('parent', grAPM.sys_id);

grCIrel.query();

while (grCIrel.next()) {

var grAppService = new GlideRecord('cmdb_ci_service');

grAppService.addQuery('sys_id', grCIrel.child);

grAppService.query();

if (grAppService.next()) {

//gs.print('federated app service');

APMobj.application_services.push({

app_services_name: grAppService.getValue('name'),

app_services_tech_lead_euid: grAppService.u_tech_lead.u_euid + '',

app_services_tech_lead_email: grAppService.u_tech_lead.email + '',

app_services_environment: grAppService.getValue('environment')

});

}

}

responseObj.apm_list.push(APMobj);

//APMs.push(APMobj);

}

APMs.push(responseObj);

return (APMs);

},