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
}
Did this answer your question?