Skip to main content
GET
Work order labour with every field of the records each row points at: technician, vendor, 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
worker_id
string
worker_name
string
vendor_id
string
vendor_name
string
rate_type
string
planned_hours
string
actual_hours
string
hours_variance
string
hourly_rate
string
hourly_rate_currency_id
string
currency_code
string
line_cost
string
is_warranty_covered
string
notes
string
row_version
string
vendor__vendor_number
string
vendor__name
string
vendor__vendor_type
string
vendor__is_oem
string
vendor__status
string
vendor__status_label
string
vendor__status_category
string
vendor__email
string
vendor__phone
string
vendor__website
string
vendor__payment_terms_days
string
vendor__onboarded_on
string
vendor__approved_on
string
vendor__performance_score
string
vendor__usable
string
vendor__categories
string
vendor__site_count
string
vendor__active_contracts
string
vendor__best_response_minutes
string
vendor__average_rating
string
vendor__rating_count
string
vendor__open_work_orders
string
vendor__warranty_work_orders
string
vendor__open_claims
string
vendor__is_assignable
string
vendor__compliance_expiring
string
vendor__warranty_authorisations
string
vendor__custom_fields
string
vendor__created_at
string
vendor__created_by_name
string
vendor__updated_at
string
vendor__updated_by_name
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
worker__worker_number
string
worker__name
string
worker__worker_type
string
worker__max_concurrent_work_orders
string
worker__is_active
string
worker__open_work_orders
string
worker__active_work_orders
string
worker__overdue_work_orders
string
worker__planned_minutes_outstanding
string
worker__skills
string
worker__email
string
worker__phone
string
worker__user_email
string
worker__user_status
string
worker__employment_status
string
worker__employment_start_date
string
worker__can_travel
string
worker__travel_radius_km
string
worker__track_location
string
worker__site_code
string
worker__site_name
string
worker__department_name
string
worker__team_name
string
worker__is_team_lead
string
worker__availability
string
worker__valid_certifications
string
worker__certifications_expiring
string
worker__certifications_lapsed
string
worker__next_certification_expiry
string
worker__performance_period_start
string
worker__performance_period_end
string
worker__utilisation_rate
string
worker__first_time_fix_rate
string
worker__sla_compliance_rate
string
worker__completed_in_period
string
worker__custom_fields
string
worker__created_at
string
worker__created_by_name
string
worker__updated_at
string
worker__updated_by_name
string
select
string

Filtering Columns

order
string

Ordering

offset
string

Limiting and Pagination

limit
string

Limiting and Pagination

Response

OK

actual_hours
number<numeric>
currency_code
string<character varying>
Maximum string length: 3
hourly_rate
number<numeric>
hourly_rate_currency_id
string<uuid>

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

hours_variance
number<numeric>
id
string<uuid>

Note: This is a Primary Key.

is_warranty_covered
boolean<boolean>
line_cost
number<numeric>
notes
string<text>
planned_hours
number<numeric>
rate_type
string<character varying>
Maximum string length: 30
row_version
integer<bigint>
vendor__active_contracts
integer<bigint>
vendor__approved_on
string<date>
vendor__average_rating
number<numeric>
vendor__best_response_minutes
integer<integer>
vendor__categories
string<jsonb>
vendor__compliance_expiring
integer<bigint>
vendor__created_at
string<timestamp with time zone>
vendor__created_by_name
string<character varying>
Maximum string length: 200
vendor__custom_fields
string<jsonb>
vendor__email
string<public.citext>
vendor__is_assignable
boolean<boolean>
vendor__is_oem
boolean<boolean>
Maximum string length: 250
vendor__name
string<character varying>
Maximum string length: 200
vendor__onboarded_on
string<date>
vendor__open_claims
integer<bigint>
vendor__open_work_orders
integer<bigint>
vendor__payment_terms_days
integer<integer>
vendor__performance_score
number<numeric>
vendor__phone
string<character varying>
Maximum string length: 40
vendor__rating_count
integer<bigint>
vendor__site_count
integer<bigint>
vendor__status
string<character varying>
Maximum string length: 60
vendor__status_category
string<character varying>
Maximum string length: 20
vendor__status_label
string<text>
vendor__updated_at
string<timestamp with time zone>
vendor__updated_by_name
string<character varying>
Maximum string length: 200
vendor__usable
boolean<boolean>
vendor__vendor_number
string<character varying>
Maximum string length: 60
vendor__vendor_type
string<character varying>
Maximum string length: 40
vendor__warranty_authorisations
integer<bigint>
vendor__warranty_work_orders
integer<bigint>
vendor__website
string<character varying>
Maximum string length: 250
vendor_id
string<uuid>

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

vendor_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.

worker__active_work_orders
integer<bigint>
worker__availability
string<text>
worker__can_travel
boolean<boolean>
worker__certifications_expiring
integer<bigint>
worker__certifications_lapsed
integer<bigint>
worker__completed_in_period
integer<integer>
worker__created_at
string<timestamp with time zone>
worker__created_by_name
string<character varying>
Maximum string length: 200
worker__custom_fields
string<jsonb>
worker__department_name
string<character varying>
Maximum string length: 200
worker__email
string<public.citext>
worker__employment_start_date
string<date>
worker__employment_status
string<character varying>
Maximum string length: 30
worker__first_time_fix_rate
number<numeric>
worker__is_active
boolean<boolean>
worker__is_team_lead
boolean<boolean>
worker__max_concurrent_work_orders
integer<smallint>
worker__name
string<character varying>
Maximum string length: 200
worker__next_certification_expiry
string<date>
worker__open_work_orders
integer<bigint>
worker__overdue_work_orders
integer<bigint>
worker__performance_period_end
string<date>
worker__performance_period_start
string<date>
worker__phone
string<character varying>
Maximum string length: 40
worker__planned_minutes_outstanding
integer<integer>
worker__site_code
string<character varying>
Maximum string length: 50
worker__site_name
string<character varying>
Maximum string length: 200
worker__skills
string<jsonb>
worker__sla_compliance_rate
number<numeric>
worker__team_name
string<character varying>
Maximum string length: 200
worker__track_location
boolean<boolean>
worker__travel_radius_km
integer<integer>
worker__updated_at
string<timestamp with time zone>
worker__updated_by_name
string<character varying>
Maximum string length: 200
worker__user_email
string<text>
worker__user_status
string<character varying>
Maximum string length: 30
worker__utilisation_rate
number<numeric>
worker__valid_certifications
integer<bigint>
worker__worker_number
string<character varying>
Maximum string length: 60
worker__worker_type
string<character varying>
Maximum string length: 40
worker_id
string<uuid>

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

worker_name
string<character varying>
Maximum string length: 200