ServiceNow Parse JSON array

Example JSON response:

"task_instances": [

{

"dag_id": "create-federated-saml-app-poc-v1",

"dag_run_id": "manual__2024-11-06T10:33:28.822918+00:01",

"duration": 25.854218,

"end_date": "2024-11-06T10:34:00.243529+00:01",

}

{

"dag_id": "create-federated-saml-app-poc-v2",

"dag_run_id": "manual__2024-11-06T10:33:28.822918+00:02",

"duration": 25.854217,

"end_date": "2024-11-06T10:34:00.243529+00:02",

}

{

"dag_id": "create-federated-saml-app-poc-v3",

"dag_run_id": "manual__2024-11-06T10:33:28.822918+00:03",

"duration": 25.854216,

"end_date": "2024-11-06T10:34:00.243529+00:03",

}

],

"total_entries": 10

}

Code:

function retrieveDetailedErrorLogs(grIntegrationAlert) {

//--parameter: the u_integration_alerts entry where the error status was reported

var dag_run_id = grIntegrationAlert.u_transaction_id;

var DAG_ID = 'create-federated-saml-app-poc-v1';

var sReturn = '';

try {

var r = new sn_ws.RESTMessageV2('Glidepath', 'GlidePathTaskInstances');

r.setStringParameterNoEscape('dag_run_id', dag_run_id);

r.setStringParameterNoEscape('dag_to_run', DAG_ID);

//if the message is configured to communicate through ECC queue, either

//by setting a MID server or calling executeAsync, one needs to set skip_sensor

//to true. Otherwise, one may get an intermittent error that the response body is null

r.setEccParameter('skip_sensor', true);

var response = r.execute();

var responseBody = response.getBody();

var httpStatus = response.getStatusCode();

sReturn = httpStatus;

gs.print('httpStatus=' + httpStatus);

if (httpStatus == 200) {

var ojson = JSON.parse(responseBody);

var taskInstances = ojson.task_instances; //--looking for 'success'

gs.print('len=' + taskInstances.length);

for (var i = 0; i < taskInstances.length; i++) {

//var dag = jsonData.taskInstances[i];

//gs.print(dag.dag_id);

gs.print(taskInstances[i].dag_id)

}

}

} catch (ex) {

var message = ex.message;

//gs.logError(this.log_prefix + 'retrieveDetailedErrorLogs:ERROR::' + message + ', ' + grIntegrationAlert.u_servicenow_id.number);

}

return sReturn;

}