Query an Asset

Through this API you can query asset information. You can query a specific asset or filter by dates, asset types, among others.

Through this API you can query asset information. You can query a specific asset or filter by dates, asset types, among others.

The "code" parameter in the URL is used to get the details of an asset. It can be obtained from this same endpoint (code field).

Input Parameters

You can filter information using the following query_params:

ParameterTypeRequiredDescription
codeTextOptionalCode of the asset to be obtained. Can be obtained from this same endpoint (code field).
idIntegerOptionalAsset ID in Fracttal. Can be obtained from this same endpoint (id field).
item_typeTextOptionalFilter by asset type. Available options are: 1: Locations, 2: Equipment, 3: Tools, 4: Spare Parts and Supplies, 5: Digital
location_codeTextOptionalCode of the parent location-type asset from which you want to query its children. Can be obtained from this same endpoint (location_code field).
activeBooleanOptionalIndicates whether the asset is active or not
availableBooleanOptionalIndicates whether the asset is in service or not
field_1TextOptionalDepends on asset type (see output parameters by asset type)
field_2TextOptionalDepends on asset type (see output parameters by asset type)
field_3TextOptionalDepends on asset type (see output parameters by asset type)
field_4TextOptionalDepends on asset type (see output parameters by asset type)
field_5TextOptionalDepends on asset type (see output parameters by asset type)
field_6TextOptionalDepends on asset type (see output parameters by asset type)
startIntegerOptionalRecord number from which the query will start. Default is 0. All queries are limited to 100 records, when there are more than that amount, this parameter should be used for pagination.
limitIntegerOptionalNumber of records that the request will show. Default value is 100.
is_treeBooleanOptionalWhen set to true, it returns all descendants in the full hierarchy. When set to false or omitted, it returns only direct children (default).

Output Parameters

Output parameters by asset type:

ParameterTypeLocations (id_type_item = 1)Equipment (id_type_item = 2)Tools (id_type_item = 3)Spare Parts and Supplies (id_type_item = 4)Digital (id_type_item = 5)
field_1TextNameNameNameNameName
field_2TextAddressManufacturerPart numberPart numberManufacturer
field_3TextCityModelManufacturerManufacturerSerial number
field_4TextArea codeSerial numberModelModelVersion
field_5TextDepartment / State / RegionOther 1Other 1Other 1
field_6TextCountryOther 2Other 2Other 2
ParameterTypeDescription
idIntegerAsset ID in Fracttal
activeBooleanIndicates whether the asset is active or not
codeTextAsset code
descriptionTextAsset description
id_type_itemIntegerAsset type. Can be: 1 - Location, 2 - Equipment, 3 - Tools, 4 - Spare Parts and Supplies, 5 - Digital
notesTextNotes
weightTextWeight
is_serial_controlBooleanIndicates if it's a serial-controlled asset
items_types_descriptionTextAsset type name
groups_descriptionTextType
groups_1_descriptionTextClassification 1
groups_2_descriptionTextClassification 2
custom_fields_groups_descriptionTextName of the custom fields group associated with the asset
units_descriptionTextUnit description
priorities_descriptionTextPriority
parent_descriptionTextLocated in or part of
purchase_dateTextPurchase date
total_costTextTotal cost
anual_depreciationTextAnnual depreciation percentage
startup_dateTextStart date for depreciation
total_replacement_costTextTotal linear depreciation cost
salvage_valueTextReplacement value (depreciation)
costs_center_descriptionTextCost center description
budgets_descriptionTextBudget
cost_averageTextAverage cost
latitudeTextLatitude
longitudTextLongitude
groups_tasks_descriptionTextTask plan it belongs to
units_codeTextUnit code
visible_to_allBooleanTrue if the asset can be viewed by all people in the company
id_parentIntegerLocation ID
hours_average_daily_useIntegerAverage daily use hours (Time in seconds, default is 86400 = 24 hours)
availableBooleanTrue when the asset is available, false otherwise
initial_date_out_of_serviceUTC-0 DateInitial out-of-service date (Applies when the asset is not available)
last_final_date_availableUTC-0 DateFinal date of the last out of service
item_urlTextAsset URL within Fracttal. Used to generate the QR code
id_companyTextCompany ID
barcodeTextQR code
min_stock_warningIntegerMinimum expected quantity of the asset
location_codeTextCode of the parent location-type asset

Example

Request: (GET) https://app.fracttal.com/api/items/654545445354

{
  "success": true,
  "message": "200",
  "data": [
    {
      "id": 28859188,
      "active": true,
      "code": "PPC.T.CA8.006",
      "description": " Cadena de sujeción de 3/8\\ G8 de 8m { PPC.T.CA8.006 }",
      "id_type_item": 4,
      "barcode": null,
      "field_1": "Cadena de sujeción de 3/8\\ G8 de 8m",
      "field_2": null,
      "field_3": null,
      "field_4": null,
      "field_5": null,
      "field_6": null,
      "notes": null,
      "min_stock_warning": false,
      "weight": null,
      "is_serial_control": false,
      "lead_time": null,
      "items_types_description": "SPARE_PARTS_AND_SUPPLIES",
      "groups_description": null,
      "groups_1_description": null,
      "groups_2_description": null,
      "custom_fields_groups_description": null,
      "units_description": "UND",
      "priorities_description": null,
      "parent_description": "// ",
      "purchase_date": null,
      "total_cost": null,
      "anual_depreciation": null,
      "startup_date": null,
      "total_replacement_cost": null,
      "salvage_value": null,
      "costs_center_description": "",
      "budgets_description": "",
      "cost_average": null,
      "latitude": null,
      "longitud": null,
      "id_group_task": null,
      "groups_tasks_description": null,
      "units_code": "UND",
      "custom_fields_values": null,
      "third_parties_name": null,
      "id_parent": null,
      "visible_to_all": false,
      "hours_average_daily_use": null,
      "available": true,
      "initial_date_out_of_service": null,
      "last_final_date_available": null,
      "item_url": "https://apps.fracttal.com/#inventories/28859188",
      "id_company": 1190,
      "location_code": "LOC01"
    }
  ],
  "total": 1
}

Test It

Test It

Language