Skip to main content
GET
Work order parts with every field of the records each row points at: part, substituted part, warehouse, work order.

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
work_order_id
string
part_id
string
part_number
string
part_name
string
warehouse_id
string
warehouse_code
string
warehouse_name
string
substituted_part_id
string
substituted_part_number
string
quantity_required
string
quantity_reserved
string
quantity_issued
string
quantity_consumed
string
quantity_returned
string
quantity_shortfall
string
quantity_used
string
quantity_outstanding
string
unit_cost
string
unit_cost_currency_id
string
currency_code
string
line_cost
string
is_warranty_covered
string
notes
string
row_version
string
part__part_number
string
part__name
string
part__description
string
part__part_category
string
part__unit_of_measure
string
part__criticality
string
part__tracking_mode
string
part__is_stocked
string
part__is_consumable
string
part__is_active
string
part__on_hand_quantity
string
part__reserved_quantity
string
part__available_quantity
string
part__on_order_quantity
string
part__reorder_point
string
part__at_or_below_reorder_point
string
part__lead_time_days
string
part__open_recommendations
string
part__shortages_12m
string
part__shortages_that_stopped_work
string
part__created_at
string
part__created_by_name
string
part__updated_at
string
part__updated_by_name
string
substituted_part__part_number
string
substituted_part__name
string
substituted_part__description
string
substituted_part__part_category
string
substituted_part__unit_of_measure
string
substituted_part__criticality
string
substituted_part__tracking_mode
string
substituted_part__is_stocked
string
substituted_part__is_consumable
string
substituted_part__is_active
string
substituted_part__on_hand_quantity
string
substituted_part__reserved_quantity
string
substituted_part__available_quantity
string
substituted_part__on_order_quantity
string
substituted_part__reorder_point
string
substituted_part__at_or_below_reorder_point
string
substituted_part__lead_time_days
string
substituted_part__open_recommendations
string
substituted_part__shortages_12m
string
substituted_part__shortages_that_stopped_work
string
substituted_part__created_at
string
substituted_part__created_by_name
string
substituted_part__updated_at
string
substituted_part__updated_by_name
string
warehouse__code
string
warehouse__name
string
warehouse__site_code
string
warehouse__site_name
string
warehouse__warehouse_type
string
warehouse__keeper_name
string
warehouse__allows_negative_stock
string
warehouse__is_active
string
warehouse__bins
string
warehouse__parts_stocked
string
warehouse__units_on_hand
string
warehouse__negative_rows
string
work_order__work_order_number
string
work_order__title
string
work_order__description
string
work_order__remarks
string
work_order__work_order_type
string
work_order__work_order_type_name
string
work_order__is_planned
string
work_order__is_emergency
string
work_order__priority
string
work_order__priority_name
string
work_order__priority_rank
string
work_order__status
string
work_order__status_label
string
work_order__status_category
string
work_order__is_open
string
work_order__allows_technician_edit
string
work_order__allows_parts_consumption
string
work_order__allows_labour_entry
string
work_order__allows_sla_extension
string
work_order__origin
string
work_order__reported_by_user_name
string
work_order__asset_number
string
work_order__asset_name
string
work_order__site_code
string
work_order__planned_start_at
string
work_order__planned_end_at
string
work_order__due_at
string
work_order__response_due_at
string
work_order__resolution_due_at
string
work_order__actual_start_at
string
work_order__actual_end_at
string
work_order__actual_duration_minutes
string
work_order__closed_at
string
work_order__readiness_score
string
work_order__is_ready
string
work_order__requires_permit
string
work_order__permit_required
string
work_order__safety_instructions
string
work_order__safety_briefing
string
work_order__problem_code
string
work_order__failure_code
string
work_order__resolution_code
string
work_order__resolution_code_name
string
work_order__resolution_notes
string
work_order__is_warranty_covered
string
work_order__sla_breached
string
work_order__sla_source
string
work_order__sla_target_name
string
work_order__estimated_duration_minutes
string
work_order__total_cost
string
work_order__labour_cost
string
work_order__parts_cost
string
work_order__vendor_cost
string
work_order__status_is_terminal
string
work_order__assigned_vendor_name
string
work_order__assigned_team_name
string
work_order__vendor_technician
string
work_order__vendor_technician_phone
string
work_order__assignees
string
work_order__cc
string
work_order__task_count
string
work_order__mandatory_tasks_outstanding
string
work_order__custom_fields
string
work_order__is_unassigned
string
work_order__age_days
string
work_order__turnaround_minutes
string
work_order__turnaround_running
string
work_order__checked_in_minutes
string
work_order__checked_in_since
string
work_order__is_overdue
string
work_order__sla_breached_now
string
work_order__created_at
string
work_order__created_by_name
string
work_order__updated_at
string
work_order__updated_by_name
string
select
string

Filtering Columns

order
string

Ordering

offset
string

Limiting and Pagination

limit
string

Limiting and Pagination

Response

OK

currency_code
string<character varying>
Maximum string length: 3
id
string<uuid>

Note: This is a Primary Key.

is_warranty_covered
boolean<boolean>
line_cost
number<numeric>
notes
string<text>
part__at_or_below_reorder_point
boolean<boolean>
part__available_quantity
number<numeric>
part__created_at
string<timestamp with time zone>
part__created_by_name
string<character varying>
Maximum string length: 200
part__criticality
string<character varying>
Maximum string length: 20
part__description
string<text>
part__is_active
boolean<boolean>
part__is_consumable
boolean<boolean>
part__is_stocked
boolean<boolean>
part__lead_time_days
integer<integer>
part__name
string<character varying>
Maximum string length: 250
part__on_hand_quantity
number<numeric>
part__on_order_quantity
number<numeric>
part__open_recommendations
integer<bigint>
part__part_category
string<character varying>
Maximum string length: 60
part__part_number
string<character varying>
Maximum string length: 80
part__reorder_point
number<numeric>
part__reserved_quantity
number<numeric>
part__shortages_12m
integer<bigint>
part__shortages_that_stopped_work
integer<bigint>
part__tracking_mode
string<character varying>
Maximum string length: 20
part__unit_of_measure
string<character varying>
Maximum string length: 30
part__updated_at
string<timestamp with time zone>
part__updated_by_name
string<character varying>
Maximum string length: 200
part_id
string<uuid>

Note: This is a Foreign Key to inventory_available.part_id.

part_name
string<character varying>
Maximum string length: 250
part_number
string<character varying>
Maximum string length: 80
quantity_consumed
number<numeric>
quantity_issued
number<numeric>
quantity_outstanding
number<numeric>
quantity_required
number<numeric>
quantity_reserved
number<numeric>
quantity_returned
number<numeric>
quantity_shortfall
number<numeric>
quantity_used
number<numeric>
row_version
integer<bigint>
substituted_part__at_or_below_reorder_point
boolean<boolean>
substituted_part__available_quantity
number<numeric>
substituted_part__created_at
string<timestamp with time zone>
substituted_part__created_by_name
string<character varying>
Maximum string length: 200
substituted_part__criticality
string<character varying>
Maximum string length: 20
substituted_part__description
string<text>
substituted_part__is_active
boolean<boolean>
substituted_part__is_consumable
boolean<boolean>
substituted_part__is_stocked
boolean<boolean>
substituted_part__lead_time_days
integer<integer>
substituted_part__name
string<character varying>
Maximum string length: 250
substituted_part__on_hand_quantity
number<numeric>
substituted_part__on_order_quantity
number<numeric>
substituted_part__open_recommendations
integer<bigint>
substituted_part__part_category
string<character varying>
Maximum string length: 60
substituted_part__part_number
string<character varying>
Maximum string length: 80
substituted_part__reorder_point
number<numeric>
substituted_part__reserved_quantity
number<numeric>
substituted_part__shortages_12m
integer<bigint>
substituted_part__shortages_that_stopped_work
integer<bigint>
substituted_part__tracking_mode
string<character varying>
Maximum string length: 20
substituted_part__unit_of_measure
string<character varying>
Maximum string length: 30
substituted_part__updated_at
string<timestamp with time zone>
substituted_part__updated_by_name
string<character varying>
Maximum string length: 200
substituted_part_id
string<uuid>

Note: This is a Foreign Key to inventory_available.part_id.

substituted_part_number
string<character varying>
Maximum string length: 80
unit_cost
number<numeric>
unit_cost_currency_id
string<uuid>

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

warehouse__allows_negative_stock
boolean<boolean>
warehouse__bins
integer<bigint>
warehouse__code
string<character varying>
Maximum string length: 60
warehouse__is_active
boolean<boolean>
warehouse__keeper_name
string<character varying>
Maximum string length: 200
warehouse__name
string<character varying>
Maximum string length: 200
warehouse__negative_rows
integer<bigint>
warehouse__parts_stocked
integer<bigint>
warehouse__site_code
string<character varying>
Maximum string length: 50
warehouse__site_name
string<character varying>
Maximum string length: 200
warehouse__units_on_hand
number<numeric>
warehouse__warehouse_type
string<character varying>
Maximum string length: 30
warehouse_code
string<character varying>
Maximum string length: 60
warehouse_id
string<uuid>

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

warehouse_name
string<character varying>
Maximum string length: 200
work_order__actual_duration_minutes
integer<integer>
work_order__actual_end_at
string<timestamp with time zone>
work_order__actual_start_at
string<timestamp with time zone>
work_order__age_days
integer<integer>
work_order__allows_labour_entry
boolean<boolean>
work_order__allows_parts_consumption
boolean<boolean>
work_order__allows_sla_extension
boolean<boolean>
work_order__allows_technician_edit
boolean<boolean>
work_order__asset_name
string<character varying>
Maximum string length: 250
work_order__asset_number
string<character varying>
Maximum string length: 80
work_order__assigned_team_name
string<character varying>
Maximum string length: 200
work_order__assigned_vendor_name
string<character varying>
Maximum string length: 200
work_order__assignees
string<jsonb>
work_order__cc
string<jsonb>
work_order__checked_in_minutes
integer<integer>
work_order__checked_in_since
string<timestamp with time zone>
work_order__closed_at
string<timestamp with time zone>
work_order__created_at
string<timestamp with time zone>
work_order__created_by_name
string<character varying>
Maximum string length: 200
work_order__custom_fields
string<jsonb>
work_order__description
string<text>
work_order__due_at
string<timestamp with time zone>
work_order__estimated_duration_minutes
integer<integer>
work_order__failure_code
string<character varying>
Maximum string length: 80
work_order__is_emergency
boolean<boolean>
work_order__is_open
boolean<boolean>
work_order__is_overdue
boolean<boolean>
work_order__is_planned
boolean<boolean>
work_order__is_ready
boolean<boolean>
work_order__is_unassigned
boolean<boolean>
work_order__is_warranty_covered
boolean<boolean>
work_order__labour_cost
number<numeric>
work_order__mandatory_tasks_outstanding
integer<bigint>
work_order__origin
string<character varying>
Maximum string length: 30
work_order__parts_cost
number<numeric>
work_order__permit_required
boolean<boolean>
work_order__planned_end_at
string<timestamp with time zone>
work_order__planned_start_at
string<timestamp with time zone>
work_order__priority
string<character varying>
Maximum string length: 40
work_order__priority_name
string<character varying>
Maximum string length: 150
work_order__priority_rank
integer<smallint>
work_order__problem_code
string<character varying>
Maximum string length: 80
work_order__readiness_score
number<numeric>
work_order__remarks
string<text>
work_order__reported_by_user_name
string<character varying>
Maximum string length: 200
work_order__requires_permit
boolean<boolean>
work_order__resolution_code
string<character varying>
Maximum string length: 60
work_order__resolution_code_name
string<character varying>
Maximum string length: 200
work_order__resolution_due_at
string<timestamp with time zone>
work_order__resolution_notes
string<text>
work_order__response_due_at
string<timestamp with time zone>
work_order__safety_briefing
string<text>
work_order__safety_instructions
string<text>
work_order__site_code
string<character varying>
Maximum string length: 50
work_order__sla_breached
boolean<boolean>
work_order__sla_breached_now
boolean<boolean>
work_order__sla_source
string<character varying>
Maximum string length: 20
work_order__sla_target_name
string<character varying>
Maximum string length: 150
work_order__status
string<character varying>
Maximum string length: 60
work_order__status_category
string<character varying>
Maximum string length: 20
work_order__status_is_terminal
boolean<boolean>
work_order__status_label
string<text>
work_order__task_count
integer<bigint>
work_order__title
string<character varying>
Maximum string length: 250
work_order__total_cost
number<numeric>
work_order__turnaround_minutes
integer<integer>
work_order__turnaround_running
boolean<boolean>
work_order__updated_at
string<timestamp with time zone>
work_order__updated_by_name
string<character varying>
Maximum string length: 200
work_order__vendor_cost
number<numeric>
work_order__vendor_technician
string<character varying>
Maximum string length: 120
work_order__vendor_technician_phone
string<character varying>
Maximum string length: 40
work_order__work_order_number
string<character varying>
Maximum string length: 60
work_order__work_order_type
string<character varying>
Maximum string length: 40
work_order__work_order_type_name
string<character varying>
Maximum string length: 150
work_order_id
string<uuid>

Note: This is a Foreign Key to asset_maintenance_plans.next_work_order_id.