Skip to content

List Planned Tasks Todo By Items

Output model for querying pending planned tasks and related work request information, with data flattened according to the official schema.


General information:

Module Category
Task Read

Molecule details

Input parameters:

No input parameters

Output parameters:

No output parameters

Input schema:

Field Type Required Description Default value Examples

Usage example:

{
  "id": 1,
  "code": "TK-2025-001",
  "description": "Tarea planificada de mantenimiento preventivo",
  "date_maintenance": "2025-12-10",
  "cal_date_maintenance": "2025-12-09",
  "delay": 2,
  "duration": 120,
  "event_date": "2025-12-08T09:00:00Z",
  "group_task_description": "Grupo de tareas A",
  "id_company": 5,
  "id_group_task": 3,
  "id_item": 100,
  "id_request": 200,
  "id_task": 1,
  "is_active": true,
  "item_description": "Compresor principal",
  "last_date_maintenance": "2025-11-10",
  "notes": "Revisar presión",
  "num_resources": 4,
  "parent_description": "Planta principal",
  "id_priorities": 2,
  "priorities_description": "Alta",
  "replay_counter": 1,
  "replay_counter_cycles": "Mensual",
  "requested_by": "Juan Pérez",
  "task_failure": "Ninguna",
  "task_note": "Verificar checklist",
  "tasks_types_2_description": "Eléctrico",
  "tasks_types_description": "Mantenimiento",
  "tasks_types_main_description": "Preventivo",
  "trigger_description": "Programado",
  "visible_to_all": true,
  "work_request_accounts_email": "cuenta1@empresa.com",
  "work_request_accounts_name": "Cuenta 1",
  "work_request_code_item": "IT-100",
  "work_request_date": "2025-12-01",
  "work_request_date_incident": "2025-11-30",
  "work_request_date_maintenance": "2025-12-10",
  "work_request_date_solution": "2025-12-11",
  "work_request_date_status": "2025-12-11",
  "work_request_description": "Solicitud de trabajo relacionada",
  "work_request_email_requested_by": "juan.perez@empresa.com",
  "work_request_geolocation": "4.710989,-74.072092",
  "work_request_id_account": 10,
  "work_request_id_code": 501,
  "work_request_id_company": 5,
  "work_request_id_contacts_log": 300,
  "work_request_id_group_task": 3,
  "work_request_id_item": 100,
  "work_request_id_item_log": 101,
  "work_request_id_personnel_log": 201,
  "work_request_id_priority": 2,
  "work_request_id_requests_x_status": 401,
  "work_request_id_status": 1,
  "work_request_id_type": 1,
  "work_request_id_type_1": 10,
  "work_request_id_type_2": 20,
  "work_request_id_user": 99,
  "work_request_id_work_order": 1001,
  "work_request_identifier": "REQ-2025-001",
  "work_request_is_urgent": false,
  "work_request_items_description": "Compresor principal",
  "work_request_observation": "Sin novedades",
  "work_request_parent_description": "Planta principal",
  "work_request_priorities_description": "Alta",
  "work_request_rating": "5",
  "work_request_rating_notes": "Excelente atención",
  "work_request_requested_by": "Juan Pérez",
  "work_request_requests_x_key_words_descriptions": "mantenimiento, compresor",
  "work_request_requests_x_key_words_id_key_words": "1,2",
  "work_request_requests_x_status_accounts_name": "Cuenta 1",
  "work_request_requests_x_status_description": "Cerrada",
  "work_request_requests_x_status_notes": "Resuelta a tiempo",
  "work_request_status_path_image": "https://empresa.com/imagenes/estado.png",
  "work_request_types_1_description": "Correctivo",
  "work_request_types_2_description": "Eléctrico",
  "work_request_types_color": "#FF0000",
  "work_request_types_description": "Mantenimiento",
  "work_request_visible_to_all": true,
  "work_request_wo_folio": "WO-2025-001"
}

Notes:

Use this model to query pending scheduled tasks and related requests, flattening the data according to the JSON schema.