Skip to main content
GET
Tools with every field of the records each row points at: manufacturer, owner, site, tool room.

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
tool_number
string
name
string
tool_type
string
tool_type_name
string
tool_category
string
status
string
status_label
string
is_available_for_booking
string
condition
string
condition_blocks_use
string
serial_number
string
site_id
string
site_code
string
tool_room_location_id
string
owner_worker_id
string
quantity
string
requires_calibration
string
calibration_interval_months
string
last_calibrated_on
string
next_calibration_on
string
calibration_state
string
held_by
string
primary_image_file_id
string
custom_fields
string
is_active
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
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
owner__worker_number
string
owner__name
string
owner__worker_type
string
owner__max_concurrent_work_orders
string
owner__is_active
string
owner__open_work_orders
string
owner__active_work_orders
string
owner__overdue_work_orders
string
owner__planned_minutes_outstanding
string
owner__skills
string
owner__email
string
owner__phone
string
owner__user_email
string
owner__user_status
string
owner__employment_status
string
owner__employment_start_date
string
owner__can_travel
string
owner__travel_radius_km
string
owner__track_location
string
owner__site_code
string
owner__site_name
string
owner__department_name
string
owner__team_name
string
owner__is_team_lead
string
owner__availability
string
owner__valid_certifications
string
owner__certifications_expiring
string
owner__certifications_lapsed
string
owner__next_certification_expiry
string
owner__performance_period_start
string
owner__performance_period_end
string
owner__utilisation_rate
string
owner__first_time_fix_rate
string
owner__sla_compliance_rate
string
owner__completed_in_period
string
owner__custom_fields
string
owner__created_at
string
owner__created_by_name
string
owner__updated_at
string
owner__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

calibration_interval_months
integer<integer>
calibration_state
string<text>
condition
string<character varying>
Maximum string length: 40
condition_blocks_use
boolean<boolean>
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>
held_by
string<jsonb>
id
string<uuid>

Note: This is a Primary Key.

is_active
boolean<boolean>
is_available_for_booking
boolean<boolean>
last_calibrated_on
string<date>
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>
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
name
string<character varying>
Maximum string length: 200
next_calibration_on
string<date>
owner__active_work_orders
integer<bigint>
owner__availability
string<text>
owner__can_travel
boolean<boolean>
owner__certifications_expiring
integer<bigint>
owner__certifications_lapsed
integer<bigint>
owner__completed_in_period
integer<integer>
owner__created_at
string<timestamp with time zone>
owner__created_by_name
string<character varying>
Maximum string length: 200
owner__custom_fields
string<jsonb>
owner__department_name
string<character varying>
Maximum string length: 200
owner__email
string<public.citext>
owner__employment_start_date
string<date>
owner__employment_status
string<character varying>
Maximum string length: 30
owner__first_time_fix_rate
number<numeric>
owner__is_active
boolean<boolean>
owner__is_team_lead
boolean<boolean>
owner__max_concurrent_work_orders
integer<smallint>
owner__name
string<character varying>
Maximum string length: 200
owner__next_certification_expiry
string<date>
owner__open_work_orders
integer<bigint>
owner__overdue_work_orders
integer<bigint>
owner__performance_period_end
string<date>
owner__performance_period_start
string<date>
owner__phone
string<character varying>
Maximum string length: 40
owner__planned_minutes_outstanding
integer<integer>
owner__site_code
string<character varying>
Maximum string length: 50
owner__site_name
string<character varying>
Maximum string length: 200
owner__skills
string<jsonb>
owner__sla_compliance_rate
number<numeric>
owner__team_name
string<character varying>
Maximum string length: 200
owner__track_location
boolean<boolean>
owner__travel_radius_km
integer<integer>
owner__updated_at
string<timestamp with time zone>
owner__updated_by_name
string<character varying>
Maximum string length: 200
owner__user_email
string<text>
owner__user_status
string<character varying>
Maximum string length: 30
owner__utilisation_rate
number<numeric>
owner__valid_certifications
integer<bigint>
owner__worker_number
string<character varying>
Maximum string length: 60
owner__worker_type
string<character varying>
Maximum string length: 40
owner_worker_id
string<uuid>

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

primary_image_file_id
string<uuid>
quantity
number<numeric>
reference_records
string<jsonb>
requires_calibration
boolean<boolean>
row_version
integer<bigint>
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.

status
string<character varying>
Maximum string length: 40
status_label
string<character varying>
Maximum string length: 150
tool_category
string<character varying>
Maximum string length: 60
tool_number
string<character varying>
Maximum string length: 60
tool_room_location_id
string<uuid>

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

tool_type
string<character varying>
Maximum string length: 60
tool_type_name
string<character varying>
Maximum string length: 200
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