Skip to main content
GET
Found items with every field of the records each row points at: found at, found by, matched report, site, stored at.

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
reference
string
status
string
site_id
string
site_code
string
site_name
string
found_location_id
string
found_location_name
string
found_location_detail
string
found_at
string
handed_in_at
string
found_by_name
string
found_by_kind
string
found_by_phone
string
found_by_user_id
string
lost_found_category_id
string
category
string
requires_signature
string
item_description
string
brand
string
colour
string
serial_number
string
distinguishing_marks
string
quantity
string
estimated_value
string
estimated_value_currency_id
string
is_valuable
string
storage_location_id
string
storage_location_name
string
storage_detail
string
stored_by_user_id
string
stored_by
string
hold_until
string
days_held
string
hold_expired
string
lost_item_report_id
string
lost_reference
string
owner_name
string
owner_phone
string
owner_email
string
matched_at
string
matched_by_user_id
string
match_notes
string
collected_by_name
string
collected_by_id_type
string
collected_by_id_number
string
collected_by_signature
string
collection_signed
string
collected_at
string
released_by_user_id
string
released_by
string
collection_notes
string
disposed_at
string
disposal_method
string
disposal_notes
string
notes
string
standing
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
found_by__email
string
found_by__username
string
found_by__sign_in_handle
string
found_by__name
string
found_by__phone
string
found_by__status
string
found_by__last_login_at
string
found_by__worker_number
string
found_by__worker_name
string
found_by__worker_type
string
found_by__worker_is_active
string
found_by__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
lost_item_report__reference
string
lost_item_report__status
string
lost_item_report__site_code
string
lost_item_report__site_name
string
lost_item_report__location_name
string
lost_item_report__last_seen_detail
string
lost_item_report__lost_at
string
lost_item_report__reported_at
string
lost_item_report__reported_by
string
lost_item_report__owner_name
string
lost_item_report__owner_kind
string
lost_item_report__owner_id_type
string
lost_item_report__owner_id_number
string
lost_item_report__owner_phone
string
lost_item_report__owner_email
string
lost_item_report__category
string
lost_item_report__item_description
string
lost_item_report__brand
string
lost_item_report__colour
string
lost_item_report__serial_number
string
lost_item_report__distinguishing_marks
string
lost_item_report__estimated_value
string
lost_item_report__cctv_available
string
lost_item_report__cctv_camera
string
lost_item_report__cctv_from
string
lost_item_report__cctv_to
string
lost_item_report__cctv_reviewed
string
lost_item_report__cctv_findings
string
lost_item_report__notes
string
lost_item_report__matched_at
string
lost_item_report__closed_at
string
lost_item_report__closure_notes
string
lost_item_report__found_reference
string
lost_item_report__found_description
string
lost_item_report__found_storage_detail
string
lost_item_report__collected_at
string
lost_item_report__collected_by_name
string
lost_item_report__standing
string
lost_item_report__custom_fields
string
lost_item_report__created_at
string
lost_item_report__created_by_name
string
lost_item_report__updated_at
string
lost_item_report__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
storage_location__site_code
string
storage_location__parent_name
string
storage_location__location_type
string
storage_location__level_hint
string
storage_location__code
string
storage_location__name
string
storage_location__path
string
storage_location__depth
string
storage_location__latitude
string
storage_location__longitude
string
storage_location__is_active
string
storage_location__allows_direct_filing
string
storage_location__takes_filing
string
storage_location__primary_location_head_name
string
storage_location__alternate_location_heads
string
storage_location__children
string
storage_location__assets
string
storage_location__assets_in_branch
string
reference_records
string
select
string

Filtering Columns

order
string

Ordering

offset
string

Limiting and Pagination

limit
string

Limiting and Pagination

Response

OK

brand
string<character varying>
Maximum string length: 80
category
string<character varying>
Maximum string length: 150
collected_at
string<timestamp with time zone>
collected_by_id_number
string<character varying>
Maximum string length: 60
collected_by_id_type
string<character varying>
Maximum string length: 30
collected_by_name
string<character varying>
Maximum string length: 150
collected_by_signature
string<jsonb>
collection_notes
string<text>
collection_signed
boolean<boolean>
colour
string<character varying>
Maximum string length: 40
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>
custom_fields
string<jsonb>
days_held
integer<integer>
disposal_method
string<character varying>
Maximum string length: 30
disposal_notes
string<text>
disposed_at
string<timestamp with time zone>
distinguishing_marks
string<text>
estimated_value
number<numeric>
estimated_value_currency_id
string<uuid>

Note: This is a Foreign Key to asset_cost_to_keep.currency_id.

found_at
string<timestamp with time zone>
found_by__email
string<public.citext>
found_by__last_login_at
string<timestamp with time zone>
found_by__name
string<character varying>
Maximum string length: 200
found_by__phone
string<character varying>
Maximum string length: 40
found_by__sign_in_handle
string<text>
found_by__status
string<character varying>
Maximum string length: 30
found_by__username
string<public.citext>
found_by__worker_is_active
boolean<boolean>
found_by__worker_name
string<character varying>
Maximum string length: 200
found_by__worker_number
string<character varying>
Maximum string length: 60
found_by__worker_teams
string<jsonb>
found_by__worker_type
string<character varying>
Maximum string length: 150
found_by_kind
string<character varying>
Maximum string length: 20
found_by_name
string<character varying>
Maximum string length: 150
found_by_phone
string<character varying>
Maximum string length: 40
found_by_user_id
string<uuid>

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

found_location_detail
string<character varying>
Maximum string length: 200
found_location_id
string<uuid>

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

found_location_name
string<character varying>
Maximum string length: 200
handed_in_at
string<timestamp with time zone>
hold_expired
boolean<boolean>
hold_until
string<date>
id
string<uuid>

Note: This is a Primary Key.

is_valuable
boolean<boolean>
item_description
string<text>
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>
lost_found_category_id
string<uuid>

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

lost_item_report__brand
string<character varying>
Maximum string length: 80
lost_item_report__category
string<character varying>
Maximum string length: 150
lost_item_report__cctv_available
boolean<boolean>
lost_item_report__cctv_camera
string<character varying>
Maximum string length: 120
lost_item_report__cctv_findings
string<text>
lost_item_report__cctv_from
string<timestamp with time zone>
lost_item_report__cctv_reviewed
boolean<boolean>
lost_item_report__cctv_to
string<timestamp with time zone>
lost_item_report__closed_at
string<timestamp with time zone>
lost_item_report__closure_notes
string<text>
lost_item_report__collected_at
string<timestamp with time zone>
lost_item_report__collected_by_name
string<character varying>
Maximum string length: 150
lost_item_report__colour
string<character varying>
Maximum string length: 40
lost_item_report__created_at
string<timestamp with time zone>
lost_item_report__created_by_name
string<character varying>
Maximum string length: 200
lost_item_report__custom_fields
string<jsonb>
lost_item_report__distinguishing_marks
string<text>
lost_item_report__estimated_value
number<numeric>
lost_item_report__found_description
string<text>
lost_item_report__found_reference
string<character varying>
Maximum string length: 40
lost_item_report__found_storage_detail
string<character varying>
Maximum string length: 200
lost_item_report__item_description
string<text>
lost_item_report__last_seen_detail
string<character varying>
Maximum string length: 200
lost_item_report__location_name
string<character varying>
Maximum string length: 200
lost_item_report__lost_at
string<timestamp with time zone>
lost_item_report__matched_at
string<timestamp with time zone>
lost_item_report__notes
string<text>
lost_item_report__owner_email
string<character varying>
Maximum string length: 255
lost_item_report__owner_id_number
string<character varying>
Maximum string length: 60
lost_item_report__owner_id_type
string<character varying>
Maximum string length: 30
lost_item_report__owner_kind
string<character varying>
Maximum string length: 20
lost_item_report__owner_name
string<character varying>
Maximum string length: 150
lost_item_report__owner_phone
string<character varying>
Maximum string length: 40
lost_item_report__reference
string<character varying>
Maximum string length: 40
lost_item_report__reported_at
string<timestamp with time zone>
lost_item_report__reported_by
string<character varying>
Maximum string length: 200
lost_item_report__serial_number
string<character varying>
Maximum string length: 80
lost_item_report__site_code
string<character varying>
Maximum string length: 50
lost_item_report__site_name
string<character varying>
Maximum string length: 200
lost_item_report__standing
string<text>
lost_item_report__status
string<character varying>
Maximum string length: 20
lost_item_report__updated_at
string<timestamp with time zone>
lost_item_report__updated_by_name
string<character varying>
Maximum string length: 200
lost_item_report_id
string<uuid>

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

lost_reference
string<character varying>
Maximum string length: 40
match_notes
string<text>
matched_at
string<timestamp with time zone>
matched_by_user_id
string<uuid>

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

notes
string<text>
owner_email
string<character varying>
Maximum string length: 255
owner_name
string<character varying>
Maximum string length: 150
owner_phone
string<character varying>
Maximum string length: 40
primary_image_file_id
string<uuid>
quantity
integer<integer>
reference
string<character varying>
Maximum string length: 40
reference_records
string<jsonb>
released_by
string<character varying>
Maximum string length: 200
released_by_user_id
string<uuid>

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

requires_signature
boolean<boolean>
row_version
integer<bigint>
serial_number
string<character varying>
Maximum string length: 80
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
standing
string<text>
status
string<character varying>
Maximum string length: 20
storage_detail
string<character varying>
Maximum string length: 200
storage_location__allows_direct_filing
boolean<boolean>
storage_location__alternate_location_heads
string<jsonb>
storage_location__assets
integer<bigint>
storage_location__assets_in_branch
integer<bigint>
storage_location__children
integer<bigint>
storage_location__code
string<character varying>
Maximum string length: 80
storage_location__depth
integer<smallint>
storage_location__is_active
boolean<boolean>
storage_location__latitude
number<numeric>
storage_location__level_hint
integer<smallint>
storage_location__location_type
string<character varying>
Maximum string length: 150
storage_location__longitude
number<numeric>
storage_location__name
string<character varying>
Maximum string length: 200
storage_location__parent_name
string<character varying>
Maximum string length: 200
storage_location__path
string<text>
storage_location__primary_location_head_name
string<character varying>
Maximum string length: 200
storage_location__site_code
string<character varying>
Maximum string length: 50
storage_location__takes_filing
boolean<boolean>
storage_location_id
string<uuid>

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

storage_location_name
string<character varying>
Maximum string length: 200
stored_by
string<character varying>
Maximum string length: 200
stored_by_user_id
string<uuid>

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

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