Through this API you can query the out-of-service history of locations and equipment.
You can perform the query with the asset code to obtain the specific history of an asset.
You can also perform a date filter to query the out-of-service occurred in that time. The default is to query the out of service that occurred 1 month ago.
Endpoint with asset filter:
https://app.fracttal.com/api/items_availability/:code_asset
Input parameters
Parameter | Type | Required | Description |
|---|---|---|---|
code | Text | Optional | Code of the asset |
since | Text | Optional | Initial date of the query. Format: |
until | Text | Optional | End date of the query. |
type_date | Text | Optional | Type of date by which the filter will be performed.
|
start |
| Optional | Record number from which the query will start, by default it starts at item 0. |
limit |
| Optional | Final record number to be returned by the query. By default 100 records are returned (Maximum value). |
Output parameters
Parameter | Type | Location (id_type_item = 1) |
|---|---|---|
description | Text | Description of asset |
code | Text | Asset code |
creation_date | Text | Date of creation of the out of service |
initial_date | Text | Date on which the out-of-service began |
final_date | Date | Date on which the out-of-service was terminated |
out_of_service_sec | Number | Duration in seconds of out of service |
Example:
Petition: (GET)https://app.fracttal.com/api/items_availability/?since=2020-01-01T00:00:00-05&until=2020-04-30T23:59:00-05&code=222-GXC
{
"success": true,}
"message": "200",
"data": [
{
"id": 162,
"id_company": 133,
"id_item": 5008,
"creation_date": "2020-04-20T13:41:09.950329+00:00",
"initial_date": "2020-04-20T13:39:49.511+00:00",
"final_date": "2020-04-23T19:30:46+00:00",
"out_of_service_sec": 280256,
"description": "AUTOMOVIL TOYOTA Hotwheels Double { 222-GXC } HILUX V8",
"code": "222-GXC"
},
{
"id": 142,
"id_company": 133,
"id_item": 5008,
"creation_date": "2020-03-06T16:55:57.927531+00:00",
"initial_date": "2020-03-01T16:52:00+00:00",
"final_date": "2020-03-06T16:57:07+00:00",
"out_of_service_sec": 432307,
"description": "AUTOMOVIL TOYOTA Hotwheels Double { 222-GXC } HILUX V8",
"code": "222-GXC"
},
{
"id": 148,
"id_company": 133,
"id_item": 5008,
"creation_date": "2020-03-18T18:01:52.896563+00:00",
"initial_date": "2020-03-18T17:58:44.213+00:00",
"final_date": "2020-04-07T13:35:17.484273+00:00",
"out_of_service_sec": 1712193,
"description": "AUTOMOVIL TOYOTA Hotwheels Double { 222-GXC } HILUX V8",
"code": "222-GXC"
},
{
"id": 160,
"id_company": 133,
"id_item": 5008,
"creation_date": "2020-04-15T17:57:49.416216+00:00",
"initial_date": "2020-04-14T16:20:00+00:00",
"final_date": "2020-04-15T18:50:05+00:00",
"out_of_service_sec": 95405,
"description": "AUTOMOVIL TOYOTA Hotwheels Double { 222-GXC } HILUX V8",
"code": "222-GXC"
}
],
"total": 4
}Test iT