Skip to main content
GET
Retired assets with every field of the records each row points at: custodian, location, manufacturer, model, parent asset, site.

Headers

Range
string

Limiting and Pagination

Range-Unit
string
default:items

Limiting and Pagination

Prefer
enum<string>

Preference

Available options:
count=none

Query Parameters

id
string
asset_number
string
name
string
serial_number
string
asset_category_id
string
asset_category_code
string
asset_category
string
asset_category_ancestor_ids
string
asset_category_path
string
asset_category_root_code
string
asset_category_root
string
asset_class_id
string
asset_class_code
string
asset_class
string
asset_class_is_default
string
status
string
status_label
string
status_category
string
criticality
string
criticality_rank
string
criticality_response_minutes
string
site_id
string
site_code
string
site_name
string
location_id
string
location_name
string
latitude
string
longitude
string
parent_asset_id
string
parent_asset_number
string
manufacturer
string
model_code
string
model_name
string
purchase_date
string
installation_date
string
commissioning_date
string
warranty_expires_on
string
health_score
string
is_retired
string
custodian_user_id
string
custodian
string
custodian_email
string
custody_since
string
primary_image_file_id
string
custom_fields
string
row_version
string
created_at
string
created_by_id
string
created_by_name
string
created_source
string
updated_at
string
updated_by_id
string
updated_by_name
string
search_text
string
custom_text
string
search_all
string
retired_at
string
retired_by
string
custodian__email
string
custodian__username
string
custodian__sign_in_handle
string
custodian__name
string
custodian__phone
string
custodian__status
string
custodian__last_login_at
string
custodian__worker_number
string
custodian__worker_name
string
custodian__worker_type
string
custodian__worker_is_active
string
custodian__worker_teams
string
location__site_code
string
location__parent_name
string
location__location_type
string
location__level_hint
string
location__code
string
location__name
string
location__path
string
location__depth
string
location__latitude
string
location__longitude
string
location__is_active
string
location__allows_direct_filing
string
location__takes_filing
string
location__primary_location_head_name
string
location__alternate_location_heads
string
location__children
string
location__assets
string
location__assets_in_branch
string
manufacturer__code
string
manufacturer__name
string
manufacturer__website
string
manufacturer__support_email
string
manufacturer__support_phone
string
manufacturer__is_active
string
manufacturer__models
string
manufacturer__assets
string
model__manufacturer_name
string
model__asset_category_name
string
model__code
string
model__name
string
model__expected_life_months
string
model__specifications
string
model__is_active
string
model__assets
string
parent_asset__asset_number
string
parent_asset__name
string
parent_asset__serial_number
string
parent_asset__asset_category_code
string
parent_asset__asset_category
string
parent_asset__asset_category_ancestor_ids
string
parent_asset__asset_category_path
string
parent_asset__asset_category_root_code
string
parent_asset__asset_category_root
string
parent_asset__asset_class_code
string
parent_asset__asset_class
string
parent_asset__asset_class_is_default
string
parent_asset__status
string
parent_asset__status_label
string
parent_asset__status_category
string
parent_asset__criticality
string
parent_asset__criticality_rank
string
parent_asset__criticality_response_minutes
string
parent_asset__site_code
string
parent_asset__site_name
string
parent_asset__location_name
string
parent_asset__latitude
string
parent_asset__longitude
string
parent_asset__parent_asset_number
string
parent_asset__manufacturer
string
parent_asset__model_code
string
parent_asset__model_name
string
parent_asset__purchase_date
string
parent_asset__installation_date
string
parent_asset__commissioning_date
string
parent_asset__warranty_expires_on
string
parent_asset__health_score
string
parent_asset__is_retired
string
parent_asset__custodian
string
parent_asset__custodian_email
string
parent_asset__custody_since
string
parent_asset__custom_fields
string
parent_asset__created_at
string
parent_asset__created_by_name
string
parent_asset__updated_at
string
parent_asset__updated_by_name
string
site__code
string
site__name
string
site__timezone
string
site__is_active
string
site__company_name
string
site__business_unit_name
string
site__business_unit_parent_name
string
site__asset_count
string
reference_records
string
select
string

Filtering Columns

order
string

Ordering

offset
string

Limiting and Pagination

limit
string

Limiting and Pagination

Response

OK

asset_category
string<character varying>
Maximum string length: 200
asset_category_ancestor_ids
string[]
asset_category_code
string<character varying>
Maximum string length: 60
asset_category_id
string<uuid>

Note: This is a Foreign Key to asset_categories.id.

asset_category_path
string<text>
asset_category_root
string<character varying>
Maximum string length: 200
asset_category_root_code
string<character varying>
Maximum string length: 60
asset_class
string<character varying>
asset_class_code
string<character varying>
asset_class_id
string<uuid>
asset_class_is_default
boolean<boolean>
asset_number
string<character varying>
Maximum string length: 80
commissioning_date
string<date>
created_at
string<timestamp with time zone>
created_by_id
string<uuid>

Note: This is a Foreign Key to capex_invite_candidates.id.

created_by_name
string<character varying>
Maximum string length: 200
created_source
string<text>
criticality
string<character varying>
Maximum string length: 40
criticality_rank
integer<smallint>
criticality_response_minutes
integer<integer>
custodian
string<character varying>
custodian__email
string<public.citext>
custodian__last_login_at
string<timestamp with time zone>
custodian__name
string<character varying>
Maximum string length: 200
custodian__phone
string<character varying>
Maximum string length: 40
custodian__sign_in_handle
string<text>
custodian__status
string<character varying>
Maximum string length: 30
custodian__username
string<public.citext>
custodian__worker_is_active
boolean<boolean>
custodian__worker_name
string<character varying>
Maximum string length: 200
custodian__worker_number
string<character varying>
Maximum string length: 60
custodian__worker_teams
string<jsonb>
custodian__worker_type
string<character varying>
Maximum string length: 150
custodian_email
string<public.citext>
custodian_user_id
string<uuid>

Note: This is a Foreign Key to capex_invite_candidates.id.

custody_since
string<date>
custom_fields
string<jsonb>
custom_text
string<text>
health_score
number<numeric>
id
string<uuid>

Note: This is a Primary Key.

installation_date
string<date>
is_retired
boolean<boolean>
latitude
number<numeric>
location__allows_direct_filing
boolean<boolean>
location__alternate_location_heads
string<jsonb>
location__assets
integer<bigint>
location__assets_in_branch
integer<bigint>
location__children
integer<bigint>
location__code
string<character varying>
Maximum string length: 80
location__depth
integer<smallint>
location__is_active
boolean<boolean>
location__latitude
number<numeric>
location__level_hint
integer<smallint>
location__location_type
string<character varying>
Maximum string length: 150
location__longitude
number<numeric>
location__name
string<character varying>
Maximum string length: 200
location__parent_name
string<character varying>
Maximum string length: 200
location__path
string<text>
location__primary_location_head_name
string<character varying>
Maximum string length: 200
location__site_code
string<character varying>
Maximum string length: 50
location__takes_filing
boolean<boolean>
location_id
string<uuid>

Note: This is a Foreign Key to location_settings.id.

location_name
string<character varying>
Maximum string length: 200
longitude
number<numeric>
manufacturer
string<character varying>
Maximum string length: 200
manufacturer__assets
integer<bigint>
manufacturer__code
string<character varying>
Maximum string length: 60
manufacturer__is_active
boolean<boolean>
manufacturer__models
integer<bigint>
manufacturer__name
string<character varying>
Maximum string length: 200
manufacturer__support_email
string<public.citext>
manufacturer__support_phone
string<character varying>
Maximum string length: 40
manufacturer__website
string<character varying>
Maximum string length: 250
model__asset_category_name
string<character varying>
Maximum string length: 200
model__assets
integer<bigint>
model__code
string<character varying>
Maximum string length: 80
model__expected_life_months
integer<integer>
model__is_active
boolean<boolean>
model__manufacturer_name
string<character varying>
Maximum string length: 200
model__name
string<character varying>
Maximum string length: 200
model__specifications
string<jsonb>
model_code
string<character varying>
Maximum string length: 80
model_name
string<character varying>
Maximum string length: 200
name
string<character varying>
Maximum string length: 250
parent_asset__asset_category
string<character varying>
Maximum string length: 200
parent_asset__asset_category_ancestor_ids
string[]
parent_asset__asset_category_code
string<character varying>
Maximum string length: 60
parent_asset__asset_category_path
string<text>
parent_asset__asset_category_root
string<character varying>
Maximum string length: 200
parent_asset__asset_category_root_code
string<character varying>
Maximum string length: 60
parent_asset__asset_class
string<character varying>
parent_asset__asset_class_code
string<character varying>
parent_asset__asset_class_is_default
boolean<boolean>
parent_asset__asset_number
string<character varying>
Maximum string length: 80
parent_asset__commissioning_date
string<date>
parent_asset__created_at
string<timestamp with time zone>
parent_asset__created_by_name
string<character varying>
Maximum string length: 200
parent_asset__criticality
string<character varying>
Maximum string length: 40
parent_asset__criticality_rank
integer<smallint>
parent_asset__criticality_response_minutes
integer<integer>
parent_asset__custodian
string<character varying>
parent_asset__custodian_email
string<public.citext>
parent_asset__custody_since
string<date>
parent_asset__custom_fields
string<jsonb>
parent_asset__health_score
number<numeric>
parent_asset__installation_date
string<date>
parent_asset__is_retired
boolean<boolean>
parent_asset__latitude
number<numeric>
parent_asset__location_name
string<character varying>
Maximum string length: 200
parent_asset__longitude
number<numeric>
parent_asset__manufacturer
string<character varying>
Maximum string length: 200
parent_asset__model_code
string<character varying>
Maximum string length: 80
parent_asset__model_name
string<character varying>
Maximum string length: 200
parent_asset__name
string<character varying>
Maximum string length: 250
parent_asset__parent_asset_number
string<character varying>
Maximum string length: 80
parent_asset__purchase_date
string<date>
parent_asset__serial_number
string<character varying>
Maximum string length: 120
parent_asset__site_code
string<character varying>
Maximum string length: 50
parent_asset__site_name
string<character varying>
Maximum string length: 200
parent_asset__status
string<character varying>
Maximum string length: 60
parent_asset__status_category
string<character varying>
Maximum string length: 20
parent_asset__status_label
string<text>
parent_asset__updated_at
string<timestamp with time zone>
parent_asset__updated_by_name
string<character varying>
Maximum string length: 200
parent_asset__warranty_expires_on
string<date>
parent_asset_id
string<uuid>

Note: This is a Foreign Key to asset_contracts.asset_id.

parent_asset_number
string<character varying>
Maximum string length: 80
primary_image_file_id
string<uuid>
purchase_date
string<date>
reference_records
string<jsonb>
retired_at
string<timestamp with time zone>
retired_by
string<character varying>
Maximum string length: 200
row_version
integer<bigint>
search_all
string<text>
search_text
string<text>
serial_number
string<character varying>
Maximum string length: 120
site__asset_count
integer<bigint>
site__business_unit_name
string<character varying>
Maximum string length: 200
site__business_unit_parent_name
string<character varying>
Maximum string length: 200
site__code
string<character varying>
Maximum string length: 50
site__company_name
string<character varying>
Maximum string length: 200
site__is_active
boolean<boolean>
site__name
string<character varying>
Maximum string length: 200
site__timezone
string<character varying>
Maximum string length: 100
site_code
string<character varying>
Maximum string length: 50
site_id
string<uuid>

Note: This is a Foreign Key to entry_currencies.for_site_id.

site_name
string<character varying>
Maximum string length: 200
status
string<character varying>
Maximum string length: 60
status_category
string<character varying>
Maximum string length: 20
status_label
string<text>
updated_at
string<timestamp with time zone>
updated_by_id
string<uuid>

Note: This is a Foreign Key to capex_invite_candidates.id.

updated_by_name
string<character varying>
Maximum string length: 200
warranty_expires_on
string<date>