With this endpoint it's possible to get the information about material requests created between a date range.

Endpoint:

https://app.fracttal.com/api/material_requests/:code

Input parameters

Parameter

Type

Required

Description

code

Text

Optional

Warehouse code

warehouse_id

Integer

Optional

Warehouse Id

since

Text

Optional

Initial date of the consultation. Format: 'YYYY-MM-DDTHH:MM:SS-UTC' Example: '2016-07-12T20:00:00-03'.

until

Text

Optional

End date of the query. Format: 'YYYY-MM-DDTHH:MM:SS-UTC' Example: '2016-07-12T20:00:00-03'.

start

Integer

Optional

Initial record number that the query will show.

limit

Integer

Optional

Final record number that the query will return.

Output parameters

Parameter

Type

Description

id

Integer

Material request Id

id_company

Integer

Company Id

id_warehouse_target

Integer

Warehouse Id

warehouse_code

Text

Warehouse code

warehouses_description

Text

Warehouse Description

folio_target

Text

Request's consecutive in the warehouse

date_delivery

Date

Delivery date

date_create

Datetime

Creation date

document

Text

Reference

note

Text

Note

state

Integer

Request status Id

state_description

Text

State description

id_priority

Integer

Priority Id

priorities_description

Text

Priority description

id_responsible

Integer

Responsible request Id

responsible_code

Text

Responsible code

responsible_description

Text

Responsible description

details

Array JSON

Detail of items involved in the request (see request details table)

Request Details

Parameter

Type

Description

id_movements_details

Integer

Request detail Id

id_item

Integer

Resource Id

code

Text

Resource code

items_description

Text

Resource description

qty

Real

Quantity

qty_pending

Real

Quantity pending

units_description

Text

Unit description

units_code

Text

Unit code

Examples:

Example Request : https://app.fracttal.com/api/material_requests/FTTL

Answer :

{
"success": true,
"message": "200",
"data": [
{
"id": 84,
"id_company": 1190,
"id_warehouse_target": 1,
"warehouse_code": "FTTL",
"warehouses_description": "BODEGA FRACTTAL",
"folio_target": "7",
"date_delivery": "2019-12-03",
"date_create": "2019-12-03T13:27:00.232895+00:00",
"document": "SM-MRX-001",
"note": "Solicitud de prueba para verificación de orden de compra y entrada de material",
"state": 5,
"state_description": "IN_PURCHASE_ORDER",
"id_priority": 2,
"priorities_description": "HIGH",
"id_responsible": 1539,
"responsible_code": "RH-MRX-256",
"responsible_description": "MIR LONDOÑO",
"details": [
{
"id_movements_details": 123,
"id_item": 3286,
"code": "ACT.HERR-0003",
"items_description": "LLAVE TORQUE M1/2\\ 40-200NM S.RICHMONT M1/2\\ 40-200NM { ACT.HERR-0003 }",
"qty": 15,
"qty_pending": 0,
"units_description": "UNIDAD",
"units_code": null
},
{
"id_movements_details": 122,
"id_item": 3293,
"code": "ACT.HERR-0010",
"items_description": "ANALIZADOR VIBRACIONES AN-635985-9 FLUKE 810 { ACT.HERR-0010 }",
"qty": 25,
"qty_pending": 0,
"units_description": "UNIDAD",
"units_code": null
},
{
"id_movements_details": 121,
"id_item": 3291,
"code": "ACT.HERR-0008",
"items_description": "MEDIDOR AISLACION FLUKE 1507 { ACT.HERR-0008 }",
"qty": 60,
"qty_pending": 0,
"units_description": "UNIDAD",
"units_code": null
}
]
},
{
"id": 86,
"id_company": 1190,
"id_warehouse_target": 1,
"warehouse_code": "FTTL",
"warehouses_description": "BODEGA FRACTTAL",
"folio_target": "9",
"date_delivery": "2019-12-03",
"date_create": "2019-12-03T14:58:52.441928+00:00",
"document": "SM-MRX-002",
"note": "Otra prueba de solicitud de material con asignación para orden de compra",
"state": 4,
"state_description": "PARTIAL_DELIVERY",
"id_priority": 2,
"priorities_description": "HIGH",
"id_responsible": 1539,
"responsible_code": "RH-MRX-256",
"responsible_description": "MIR LONDOÑO",
"details": [
{
"id_movements_details": 127,
"id_item": 3286,
"code": "ACT.HERR-0003",
"items_description": "LLAVE TORQUE M1/2\\ 40-200NM S.RICHMONT M1/2\\ 40-200NM { ACT.HERR-0003 }",
"qty": 200,
"qty_pending": 0,
"units_description": "UNIDAD",
"units_code": null
},
{
"id_movements_details": 128,
"id_item": 3293,
"code": "ACT.HERR-0010",
"items_description": "ANALIZADOR VIBRACIONES AN-635985-9 FLUKE 810 { ACT.HERR-0010 }",
"qty": 150,
"qty_pending": 40,
"units_description": "UNIDAD",
"units_code": null
},
{
"id_movements_details": 129,
"id_item": 3291,
"code": "ACT.HERR-0008",
"items_description": "MEDIDOR AISLACION FLUKE 1507 { ACT.HERR-0008 }",
"qty": 120,
"qty_pending": 28,
"units_description": "UNIDAD",
"units_code": null
}
]
},
{
"id": 87,
"id_company": 1190,
"id_warehouse_target": 1,
"warehouse_code": "FTTL",
"warehouses_description": "BODEGA FRACTTAL",
"folio_target": "10",
"date_delivery": "2019-12-03",
"date_create": "2019-12-03T15:40:31.859066+00:00",
"document": "SM-MRX-003",
"note": "Otra prueba con impuesto",
"state": 5,
"state_description": "IN_PURCHASE_ORDER",
"id_priority": 2,
"priorities_description": "HIGH",
"id_responsible": 1539,
"responsible_code": "RH-MRX-256",
"responsible_description": "MIR LONDOÑO",
"details": [
{
"id_movements_details": 132,
"id_item": 3286,
"code": "ACT.HERR-0003",
"items_description": "LLAVE TORQUE M1/2\\ 40-200NM S.RICHMONT M1/2\\ 40-200NM { ACT.HERR-0003 }",
"qty": 35,
"qty_pending": 0,
"units_description": "UNIDAD",
"units_code": null
},
{
"id_movements_details": 131,
"id_item": 3293,
"code": "ACT.HERR-0010",
"items_description": "ANALIZADOR VIBRACIONES AN-635985-9 FLUKE 810 { ACT.HERR-0010 }",
"qty": 50,
"qty_pending": 0,
"units_description": "UNIDAD",
"units_code": null
},
{
"id_movements_details": 130,
"id_item": 3428,
"code": "0001010000100066",
"items_description": "ACEITE 20 W 50 (SM) COPEC { 0001010000100066 }",
"qty": 39,
"qty_pending": 0,
"units_description": null,
"units_code": null
}
]
},
{
"id": 1113772,
"id_company": 1190,
"id_warehouse_target": 1,
"warehouse_code": "FTTL",
"warehouses_description": "BODEGA FRACTTAL",
"folio_target": "29",
"date_delivery": "2022-03-19",
"date_create": "2022-03-18T14:32:33.931442+00:00",
"document": "MRX005",
"note": "MRX2",
"state": 5,
"state_description": "IN_PURCHASE_ORDER",
"id_priority": 3,
"priorities_description": "MEDIUM",
"id_responsible": 1539,
"responsible_code": "RH-MRX-256",
"responsible_description": "MIR LONDOÑO",
"details": [
{
"id_movements_details": 2383105,
"id_item": 12488380,
"code": "MRX-EN-2",
"items_description": "000 HERRAMIENTA PARA EXISTENCIA NEG MRX 2 { MRX-EN-2 }",
"qty": 2,
"qty_pending": 0,
"units_description": "C/U",
"units_code": "CODE"
},
{
"id_movements_details": 2383106,
"id_item": 3424,
"code": "0001010000100014",
"items_description": "ACEITE A-MOBIL GEAR 680(SM) 325659-985 MOBIL SHC { 0001010000100014 }",
"qty": 2,
"qty_pending": 0,
"units_description": "CAJA",
"units_code": "C-01"
},
{
"id_movements_details": 2383107,
"id_item": 3288,
"code": "ACT.HERR-0005",
"items_description": "EXTRACTOR RODAMIENTOS SKF EASYPULL TMMA80 { ACT.HERR-0005 }",
"qty": 2,
"qty_pending": 0,
"units_description": "UNIDAD",
"units_code": null
},
{
"id_movements_details": 2383108,
"id_item": 11639604,
"code": "SER-MRX-002",
"items_description": "HERRAMIENTA 3 VERIFICACIÓN DE SERIAL MRX { SER-MRX-002 }",
"qty": 3,
"qty_pending": 0,
"units_description": "KIT",
"units_code": "KIT"
}
]
}
],
"total": 4
}

Example Request with a range date:

Example Request: https://app.fracttal.com/api/material_requests/?since=2022-06-01T20:00:00-03&until=2022-06-13T20:00:00-03

Answer :

{
"success": true,
"message": "200",
"data": [
{
"id": 1452719,
"id_company": 1190,
"id_warehouse_target": 1410,
"warehouse_code": "MRX-004",
"warehouses_description": "ALMACÉN DE REPUESTOS 2",
"folio_target": "20",
"date_delivery": "2022-06-10",
"date_create": "2022-06-08T06:00:24.550131+00:00",
"document": "70285343",
"note": "ABC",
"state": 3,
"state_description": "WITH_OUT_PURCHASE_ORDER",
"id_priority": 3,
"priorities_description": "MEDIUM",
"id_responsible": 1540,
"responsible_code": null,
"responsible_description": "ALEXIS GARCIA",
"details": [
{
"id_movements_details": 2978195,
"id_item": 3286,
"code": "ACT.HERR-0003",
"items_description": "LLAVE TORQUE M1/2\\ 40-200NM S.RICHMONT M1/2\\ 40-200NM { ACT.HERR-0003 }",
"qty": 3,
"qty_pending": 3,
"units_description": "UNIDAD",
"units_code": null
}
]
}
],
"total": 1
}
Did this answer your question?