Through this API you can query the information of the work orders and the tasks that are associated to the work order.
It can be queried by a given date range.
EndPoint
https://app.fracttal.com/api/work_orders/:folio
Input Parameters
Parameter | Field type | Required | Description |
folio | Text | Optional | TO ID. |
ot_status | Number | Optional | Status of the TO. 1: Process, 2: Review, 3: Closed, 4: Canceled |
code_asset | Text | Optional | Code of the asset that has the task associated with it (The asset can be a location, equipment or tool). |
since | Text | Optional | Initial date of the query. Format: ‘YYYY-MM-DDTHH:MM:SS-UTC’ Example:’2016-07-12T20:00:00-03′. |
until | Text | Optional | By default, no date filter is applied. |
type_date | Text | Optional | Query end date. Format: ‘YYYY-MM-DDTHH:MM:SS-UTC’ Ejemplo:’2016-07-12T20:00:00-03′. |
code_location | Text | Optional | Location code |
id_work_order_task | Number | Optional | Id of the task in the 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 | Final record number that the query will return. |
Output parameters
Note: All dates returned by Fracttal web services are in UTC-0.
Parameter | Field type | Description |
wo_folio | Text | TO ID |
creation_date | Text | WO creation date |
duration | Integer | Work order duration |
id_work_orders_tasks | Integer | Task ID |
id_work_orders_tasks | Integer | Task ID |
id_status_work_order | Número | 1: WO in Process 2: WO in Review 3: WO Closed 4: Cancelled TO |
final_date | Text | End date of task |
completed_percentage | Text | Percentage of work order completed |
created_by | Text | Work Order Generator Name |
code | Text | Asset Code |
items_log_description | Text | Description of the asset |
done | Text | True if the task is already completed and False if the task is not completed. |
description | Text | Task description |
id_request | Text | Id of the request, if the task comes from a request |
stop_assets | Text | True if the asset is stopped and False in case the asset is NOT stopped |
stop_assets_sec | Integer | Asset stop time (seconds) |
tasks_log_task_type_main | Text | Task type |
parent_description | Text | Location of the asset |
resources_hours | Text | Total hours of inhouse personnel used |
trigger_description | Text | Activator Type |
resources_inventory | Text | Inventory type resources in the task |
resources_human_resources | Text | Inhouse Personnel in the task |
cal_date_maintenance | Text | Calculated date of the task |
real_duration | Integer | Actual duration of the task |
date_maintenance | Text | Scheduled date of the task |
user_assigned | Text | Assigned User |
note | Text | Work Order Note |
details_signature | Text | Work order signature details |
first_date_task | Text | Start date of task nearest to completion |
costs_center_description | Text | Cost center of the asset |
tasks_duration | Text | Estimated duration of task |
total_cost_task | Text | Total cost of the WO |
requested_by | Text | Unscheduled task requestor |
groups_description | Text | Asset 'Type' information |
groups_1_description | Text | Asset classification 1 |
groups_2_description | Text | Asset classification 2 |
has_children | Text | True if the TO has child TOs |
real_stop_assets_sec | Text | Actual downtime of the asset |
wo_final_date | Text | End date of the work order |
tasks_log_types_description | Text | Task Ranking 1 |
tasks_log_types_2_description | Text | Task Ranking 2 |
rating | Text | TO Rating |
code_responsible | Text | Code of the person responsible for the TO |
work_orders_status_custom_description | Text | Reason for cancellation |
types_description | Text | Type of failure |
causes_description | Text | Fault Cause |
detection_method_description | Text | Fault detection method |
severiry_description | Text | Severity of failure |
damages_types_description | Text | Type of damage caused |
Output parameters
Example:
Example Request: https://app.fracttal.com/api/work_orders/702
Example Response:
{
"success": true,
"message": "200",
"data": [
{
"id_work_order": 694,
"id_work_orders_tasks": 1048,
"id_status_work_order": 3,
"wo_folio": "702",
"creation_date": "2016-11-03T22:03:24.306526+00:00",
"duration": 18600,
"initial_date": "2016-11-03T16:54:15+00:00",
"id_priorities": 1,
"final_date": "2016-11-03T22:04:15+00:00",
"completed_percentage": 100,
"created_by": "Laura Marcela Peña Jaramillo",
"signature": null,
"personnel_description": "ADOLFO BELTRAN",
"personnel_path_image": ".images/dut7mtlgufidwpuk3locqivswh13l1mquwcjlu7tionurl8h.png",
"code": null,
"items_log_description": " ELECTROGENIC GROUP Nº01 ",
"done": true,
"description": " EQUIPMENT REPAIR ",
"id_request": null,
"stop_assets": true,
"stop_assets_sec": null,
"tasks_log_task_type_main": " CORRECTIVE ",
"parent_description": "// CCICSA/ ",
"trigger_description": "NO_SCHEDULE_TASK",
"resources_hours": 2,
"resources_inventory": null,
"resources_human_resources": "ADOLFO BELTRAN",
"resources_services": null,
"cal_date_maintenance": "2016-11-03T03:00:00+00:00",
"real_duration": 18600,
"date_maintenance": "2016-11-03T03:00:00+00:00",
"user_assigned": "ADOLFO BELTRAN",
"note": null,
"details_signature": null,
"responsible_path_signature": "classic/resources/images/background-img.png",
"validator_path_signature": ".images/x2pe12213f740oee8567inxm81prwxsq63m1ak43xfvtph.png",
"first_date_task": "2016-11-03T03:00:00+00:00",
"costs_center_description": "",
"tasks_duration": 18600,
"total_cost_task": 8888,
"requested_by": "MIGUEL",
"groups_description": " ELECTROGENIC GROUPS ",
"groups_1_description": "PLANT",
"groups_2_description": " GENERAL ELECTRICAL SUBSTATION PLANT", "id_parent_wo": null,
"has_children": false,
"real_stop_assets_sec": null,
"wo_final_date": null,
"is_offline": null,
"tasks_log_types_description": null,
"tasks_log_types_2_description": null,
"code_create_by": null,
"event_date": "2016-11-03T17:08:01+00:00",
"rating": null,
"enable_budget": null,
"work_orders_status_custom_description": null,
"review_date": null,
"code_responsible": null,
"id_parent": 24517,
"id_failure_type": 2,
"types_description": "MEMORY PROBLEM",
"id_failure_cause": 9,
"causes_description": " LACK OF FUEL ",
"id_failure_detection_method": 1,
"detection_method_description": "VISUAL INSPECTION",
"id_failure_severity": 1,
"severiry_description": "VERY_HIGH",
"id_damage_type": 1,
"damages_types_description": "NEITHER",
"caused_damage": null,
"id_group_task": null,
"id_company": 133
}
],
"total": 1
}