Json Parsing

[Aishwarya Pulas]

In a variable called jsonRet , Servicenow Business rule called "Recalculate" on pm_project_task table stores the json object attached in the below file . 

I want to parse this object and get the value of 

"dv_schedule_end_date" under tasks array number 1. 

Please help me in how to achieve this 

My try:

var jsonRet = plannedTaskAPI.recalculateTaskWithPreviousGr(current, true, tasksToRecalculate, previous);

gs.log("jsonRet " + jsonRet);

var a = JSON.stringify(jsonRet);

var parser = new JSONParser();

 var parsed = parser.parse(a);

 var dvScheduleEndDate = parsed.tasks[1].dv_schedule_end_date;

  gs.log("dvScheduleEndDate " + dvScheduleEndDate);    

Logs me :

dvScheduleEndDate undefined  

[Anand Kumar P]

Hi @Aishwarya Pulas ,

Try below script

var jsonRet = plannedTaskAPI.recalculateTaskWithPreviousGr(current, true, tasksToRecalculate, previous);
gs.log("jsonRet " + jsonRet);

try {
var parsed = JSON.parse(jsonRet);
var dvScheduleEndDate = parsed.tasks[0].dv_schedule_end_date; 
gs.log("dvScheduleEndDate " + dvScheduleEndDate);
} catch (error) {
gs.log("Error parsing JSON: " + error);
}

Thanks,

Anand