Trying to get start and end times for each task from sp.json

[therealstein]

Hey i try to integrate with my other tools , i tried to write a simple script, that scans the synced sp.json. for tasks, that works well so far.
But furthermore i need to have also the start and end times for each tasks. I couldn't found out where i can collect these informations. so i appreciate any hint. thank you

n8n code node:

// Get the binary data from the previous node
const binaryData = items[0].binary.data;

// Convert the binary data to a string
const jsonString = Buffer.from(binaryData.data, 'base64').toString('utf8');

try {
  const jsonObject = JSON.parse(JSON.parse(jsonString));

  const processTasks = (
    taskArray,
    entities,
    outputArray,
    projects,
    isArchived,
  ) => {
    taskArray.forEach((task) => {
      const entity = entities[task];
      if (!entity) return;

      const { id, projectId = '', isDone, doneOn, title, created } = entity;
      outputArray.push({
        id,
        projectId,
        projectTitle: projectId
          ? projects.find((p) => p.id === projectId)?.title || ''
          : '',
        isDone,
        title,
        doneOn: doneOn ? new Date(doneOn).toISOString() : '',
        created: new Date(created).toISOString(),
        isArchived,
      });
    });
  };

  const processProjects = (projectArray, entities, outputArray) => {
    projectArray.forEach((project) => {
      const entity = entities[project];
      if (!entity) return;

      const { id, title } = entity;
      outputArray.push({ id, title });
    });
  };

  const projects = [];
  processProjects(
    jsonObject.project.ids,
    jsonObject.project.entities,
    projects,
  );

  const tasks = [];
  processTasks(
    jsonObject.task.ids,
    jsonObject.task.entities,
    tasks,
    projects,
    false,
  );
  processTasks(
    jsonObject.taskArchive.ids,
    jsonObject.taskArchive.entities,
    tasks,
    projects,
    true,
  );

  // Output the tasks array for the next node to use
  return tasks.map(task => ({ json: task }));

} catch (parseErr) {
  throw new Error(`Error parsing JSON: ${parseErr.message}`);
}

[johannesjo]

Hey there! As SP is synced over a single file, the model is kept as slim as possible. For that reason this data is not saved. There is just the stuff defined in: src/app/features/tasks/task.model.ts