Query task execution times in WOs

get

https://app.fracttal.com/api/wo_execution_times/

This API can be used to query the detail of the times used for the execution of a task within a work order.

Input parameters

Parameter	Type	Required	Description
`id_work_order_task`	Number	Optional	Task ID in the work order. It can be checked here (parameter is id_works_orders_task).
`id_work_order`	Number	Optional	Work order ID. It can be checked here (parameter is id_work_order).
`start`	Integer	Optional	Number of records from which you want to start the query. All queries are limited to 100 records, when there are more than that amount you must use this parameter for pagination.
`limit`	Integer	Optional	Número de registro final que retornará la consulta .

Output parameters

Note: All dates returned by Fracttal web services are in UTC-0.

Parameter	Type	Description
`id_work_order_task`	Number	Task ID within the WO
`initial_date`	Text	Start date of task execution
`final_date`	Text	Date of completion of task execution
`id_wo_tasks_execution_types`	Integer	ID of the execution type assigned to the record. Returns null if no type was assigned.
`wo_tasks_execution_types_description`	Text	Description of the execution type. Returns null if no type was assigned or if the company does not have time categorization enabled.
`note`	Text	Note of the execution record. Returns null if no note was entered.
`name`	Text	Name of person who recorded the time
`id_account`	Integer	ID of the account that recorded the task execution
`id_personnel`	Integer	ID of the human resource (if the account is linked to a human resource)
`personnel_code`	Text	Code of the human resource (if the account is linked to a human resource)
`third_party_id`	Integer	ID of the third party (if the account is linked to a third party)
`third_party_code`	Text	Code of the third party (if the account is linked to a third party)
`third_party_contact_name`	Text	Contact name of the third party (if the account is linked to a third party)
`execution_events`	Array	Chronological array of events in the execution block. See structure in the table below.

Structure of each event in execution_events:

Parameter	Type	Description
`id`	Integer	Execution event ID
`action_type`	Integer	Action type: 0 = PAUSED, 1 = IN_PROGRESS
`action_type_description`	Text	Text description of the type: "PAUSED" or "IN_PROGRESS"
`id_wo_tasks_execution_types`	Integer	ID of the execution type assigned to the event; null if not applicable
`paused_reason_description`	Text	Pause reason description; null if not applicable
`initial_date`	Text	Event start date and time (UTC-0)
`final_date`	Text	Event end date and time (UTC-0)
`note`	Text	Event note; null if not entered
`duration_seconds`	Integer	Event duration in seconds

Example:

Request: (GET)https://app.fracttal.com/api/wo_execution_times/3259375

{
    "success": true,
    "message": "200",
    "data": [
        {
            "id": 8271217,
            "id_company": 1190,
            "id_work_order_task": 13951616,
            "initial_date": "2023-03-27T16:43:14.296123+00:00",
            "final_date": "2023-03-27T16:48:32.809057+00:00",
            "id_wo_tasks_execution_types": 3,
            "wo_tasks_execution_types_description": "Material search",
            "note": "Execution record note",
            "id_accounts_log": 58113,
            "id_account": 3,
            "name": "JOHN DOE",
            "id_personnel": 1539,
            "personnel_code": "RH-001",
            "third_party_id": null,
            "third_party_code": null,
            "third_party_contact_name": null,
            "execution_events": [
                {
                    "id": 100203,
                    "action_type": 1,
                    "action_type_description": "IN_PROGRESS",
                    "id_wo_tasks_execution_types": null,
                    "paused_reason_description": null,
                    "initial_date": "2023-03-27T16:46:30.000000+00:00",
                    "final_date": "2023-03-27T16:48:32.809057+00:00",
                    "note": null,
                    "duration_seconds": 122
                },
                {
                    "id": 100197,
                    "action_type": 0,
                    "action_type_description": "PAUSED",
                    "id_wo_tasks_execution_types": 3,
                    "paused_reason_description": "Material search",
                    "initial_date": "2023-03-27T16:45:00.000000+00:00",
                    "final_date": "2023-03-27T16:46:30.000000+00:00",
                    "note": "Missing supplies",
                    "duration_seconds": 90
                },
                {
                    "id": 100184,
                    "action_type": 1,
                    "action_type_description": "IN_PROGRESS",
                    "id_wo_tasks_execution_types": null,
                    "paused_reason_description": null,
                    "initial_date": "2023-03-27T16:43:14.296123+00:00",
                    "final_date": "2023-03-27T16:45:00.000000+00:00",
                    "note": null,
                    "duration_seconds": 106
                }
            ]
        }
    ],
    "total": 1
}

TEST It

Response

Language

Loading…