Through this API you can consult the list of resources that were added to a task within a WO.

Filters can be made by: -WO ID (folio) -WO date range. It will be applied for the date of creation of the resource in the TO.

Input parameters

Parameters	Type	Required	Description
`folio`	Text	Optional	WO Id.
`since`	Text	Optional	Initial date of the query. Format: 'YYYYY-MM-DDTHH:MM:SS-UTC' Example: '2016-07-12T20:00:00-03'. (Default 30 days before)
`until`	Text	Optional	End date of the query. Format: 'YYYYY-MM-DDTHH:MM:SS-UTC' Example:'2016-07-12T20:00:00-03'. (Defaults to the current date.
`type_date`	Text	Optional	date_create': Date of creation of the resource
`ot_status`	Number	Optional	Status of WO. 1: In process, 2: Review, 3: Completed, 4: Cancelled
`code_location`	Text	Optional	Location code, where the asset is located or is part of the asset to which the TO was performed.
`type`	Number	Optional	Type of resource: 1 : Inventory 2 : Human Resources 3 : Services
`start`	Integer	Optional	Initial record number to be displayed by the query. It is used to do the record pagination. It is the number at which the pagination starts. By default it is 0
`limit`	Integer	Optional	Final record number to be returned by the query.

Output parameters

Parameter	Type	Description
`id_work_orders_tasks`	Text	id of the task in the work order
`id_resource`	Text	Id within the TO of the associated resource
`id_resource_original`	Text	Resource id (id associated with the spare parts, human resources or services catalog)
`description`	Text	Description of the resource
`source_description`	Text	Source of the resource
`source_code`	Text	Resource source code
`type`	Number	Type of resource 1: Inventory 2: Human Resources 3: Services
`type_description`	Text	Description of the type of resource
`qty`	Number	Quantity requested
`unit_cost`	Real	Unit cost
`total_cost`	Real	Total cost
`qty_delivered`	Real	Quantity Delivered
`real_qty_used`	Real	Actual amount used
`initial_date`	Real	TO start date
`final_date`	Real	TO end date
`code`	Text	Resource code
`units_description`	Text	Description of the unit
`units_code`	Text	Unit code
`id_status_work_order`	Number	Work order status
`costs_center_description`	Text	Cost center
`date_create`	Date	Date on which the resource was added
`wo_folio`	Text	WO ID
`external_source`	Text	Description of the external source (For when it is a non-catalogued resource)
`id_movements_details`	Text	Id of the movement detail that is associated to this resource (applies only to inventory type resources)
`complementary_info`	Json	Complementary information on overtime in human resources

Example:

Request: (GET)https://app.fracttal.com/api/wo_resources/OT-2956

{
    "success": true,
    "message": "200",
    "data": [
        {
            "id": "[10490581,2]",
            "id_work_orders_tasks": 27560467,
            "id_resource": 5897,
            "id_resource_original": 6599,
            "description": "Ingeniero IoT 4391",
            "id_source": 84699,
            "source_description": "MIR LONDOÑO",
            "source_code": "RH-MRX-256",
            "id_company": 1190,
            "id_task_log": 9636803,
            "id_task": 10001397,
            "type": 2,
            "type_description": "HUMAN_RESOURCES",
            "qty": 1,
            "unit_cost": 55000,
            "total_cost": 55000,
            "qty_delivered": 1,
            "real_qty_used": 1,
            "initial_date": "2024-06-25T21:46:39.627+00:00",
            "final_date": "2024-06-25T21:49:36.259+00:00",
            "code": "RH-MRX-256",
            "units_description": "HOUR",
            "is_offline": false,
            "id_status_work_order": 1,
            "id_work_order": 16491114,
            "id_account_offline": null,
            "costs_center_description": "",
            "date_create": "2024-06-25T21:51:25.317338+00:00",
            "units_code": "H",
            "wo_folio": "OT-2956",
            "external_source": "",
            "note": "",
            "id_movements_details": 0,
            "wo_final_date": null,
            "parent_description": "// ",
            "id_wo_resource": 10490581,
            "complementary_info": {
                "percentage": null,
                "extra_hours": false,
                "type_extra_time": null
            }
        },
        {
            "id": "[2164043,3]",
            "id_work_orders_tasks": 27560467,
            "id_resource": 971363,
            "id_resource_original": 17617,
            "description": "AAA LIMPIEZA DE ROTORES",
            "id_source": 2785,
            "source_description": "ACCUAPRODUCT S.A.C.",
            "source_code": "20505830319",
            "id_company": 1190,
            "id_task_log": 9636803,
            "id_task": 10001397,
            "type": 3,
            "type_description": "SERVICES",
            "qty": 1,
            "unit_cost": 125469,
            "total_cost": 125469,
            "qty_delivered": 1,
            "real_qty_used": 1,
            "initial_date": "2024-06-25T21:46:39.627+00:00",
            "final_date": "2024-06-25T21:49:36.259+00:00",
            "code": "",
            "units_description": "C/U",
            "is_offline": false,
            "id_status_work_order": 1,
            "id_work_order": 16491114,
            "id_account_offline": null,
            "costs_center_description": "",
            "date_create": "2024-06-25T21:51:25.317338+00:00",
            "units_code": "",
            "wo_folio": "OT-2956",
            "external_source": null,
            "note": "",
            "id_movements_details": 0,
            "wo_final_date": null,
            "parent_description": "// ",
            "id_wo_resource": 2164043,
            "complementary_info": null
        },
        {
            "id": "[5181683,1]",
            "id_work_orders_tasks": 27560467,
            "id_resource": 9595013,
            "id_resource_original": 3285,
            "description": "LLAVE TORQUE M1/2\\ 20-100NM  { ACT.HERR-0002 } S.RICHMONT M1/2\\ 20-100NM",
            "id_source": 2522,
            "source_description": "BODEGA AJUSTE DE INVENTARIO",
            "source_code": "ADI-001",
            "id_company": 1190,
            "id_task_log": 9636803,
            "id_task": 10001397,
            "type": 1,
            "type_description": "INVENTORY",
            "qty": 4,
            "unit_cost": 15,
            "total_cost": 0,
            "qty_delivered": 0,
            "real_qty_used": 0,
            "initial_date": "2024-06-25T21:46:39.627+00:00",
            "final_date": "2024-06-25T21:49:36.259+00:00",
            "code": "ACT.HERR-0002",
            "units_description": "UNIDAD",
            "is_offline": false,
            "id_status_work_order": 1,
            "id_work_order": 16491114,
            "id_account_offline": null,
            "costs_center_description": "80051 (  )",
            "date_create": "2024-06-25T21:51:25.317338+00:00",
            "units_code": null,
            "wo_folio": "OT-2956",
            "external_source": null,
            "note": "",
            "id_movements_details": 17745567,
            "wo_final_date": null,
            "parent_description": "// ",
            "id_wo_resource": 5181683,
            "complementary_info": null
        }
    ],
    "total": 3
}

200200