Skip to main content
GET
Work requests with every field of the records each row points at: asset, duplicate of, location, requested by, site, triaged by.

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
request_number
string
summary
string
description
string
status
string
status_label
string
status_category
string
source
string
category
string
work_request_category_id
string
category_name
string
reported_severity
string
severity_rank
string
suggested_work_order_priority_id
string
suggested_priority_code
string
suggested_priority_name
string
asset_id
string
asset_number
string
asset_name
string
site_id
string
location_id
string
requester_name
string
requested_by_user_id
string
discovered_at
string
triaged_at
string
rejection_reason
string
duplicate_of_work_request_id
string
assigned_worker_id
string
assigned_worker_name
string
assigned_team_id
string
assigned_team_name
string
assigned_vendor_id
string
assigned_vendor_name
string
cc
string
work_order_id
string
work_order_number
string
primary_image_file_id
string
asset_image_file_id
string
custom_fields
string
pending_approval_request_id
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
asset__asset_number
string
asset__name
string
asset__serial_number
string
asset__asset_category_code
string
asset__asset_category
string
asset__asset_category_ancestor_ids
string
asset__asset_category_path
string
asset__asset_category_root_code
string
asset__asset_category_root
string
asset__asset_class_code
string
asset__asset_class
string
asset__asset_class_is_default
string
asset__status
string
asset__status_label
string
asset__status_category
string
asset__criticality
string
asset__criticality_rank
string
asset__criticality_response_minutes
string
asset__site_code
string
asset__site_name
string
asset__location_name
string
asset__latitude
string
asset__longitude
string
asset__parent_asset_number
string
asset__manufacturer
string
asset__model_code
string
asset__model_name
string
asset__purchase_date
string
asset__installation_date
string
asset__commissioning_date
string
asset__warranty_expires_on
string
asset__health_score
string
asset__is_retired
string
asset__custodian
string
asset__custodian_email
string
asset__custody_since
string
asset__custom_fields
string
asset__created_at
string
asset__created_by_name
string
asset__updated_at
string
asset__updated_by_name
string
duplicate_of__request_number
string
duplicate_of__summary
string
duplicate_of__description
string
duplicate_of__status
string
duplicate_of__status_label
string
duplicate_of__status_category
string
duplicate_of__source
string
duplicate_of__category
string
duplicate_of__category_name
string
duplicate_of__reported_severity
string
duplicate_of__severity_rank
string
duplicate_of__suggested_priority_code
string
duplicate_of__suggested_priority_name
string
duplicate_of__asset_number
string
duplicate_of__asset_name
string
duplicate_of__requester_name
string
duplicate_of__discovered_at
string
duplicate_of__triaged_at
string
duplicate_of__rejection_reason
string
duplicate_of__assigned_worker_name
string
duplicate_of__assigned_team_name
string
duplicate_of__assigned_vendor_name
string
duplicate_of__cc
string
duplicate_of__work_order_number
string
duplicate_of__custom_fields
string
duplicate_of__created_at
string
duplicate_of__created_by_name
string
duplicate_of__updated_at
string
duplicate_of__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
requested_by__email
string
requested_by__username
string
requested_by__sign_in_handle
string
requested_by__name
string
requested_by__phone
string
requested_by__status
string
requested_by__last_login_at
string
requested_by__worker_number
string
requested_by__worker_name
string
requested_by__worker_type
string
requested_by__worker_is_active
string
requested_by__worker_teams
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
triaged_by__email
string
triaged_by__username
string
triaged_by__sign_in_handle
string
triaged_by__name
string
triaged_by__phone
string
triaged_by__status
string
triaged_by__last_login_at
string
triaged_by__worker_number
string
triaged_by__worker_name
string
triaged_by__worker_type
string
triaged_by__worker_is_active
string
triaged_by__worker_teams
string
reference_records
string
select
string

Filtering Columns

order
string

Ordering

offset
string

Limiting and Pagination

limit
string

Limiting and Pagination

Response

OK

asset__asset_category
string<character varying>
Maximum string length: 200
asset__asset_category_ancestor_ids
string[]
asset__asset_category_code
string<character varying>
Maximum string length: 60
asset__asset_category_path
string<text>
asset__asset_category_root
string<character varying>
Maximum string length: 200
asset__asset_category_root_code
string<character varying>
Maximum string length: 60
asset__asset_class
string<character varying>
asset__asset_class_code
string<character varying>
asset__asset_class_is_default
boolean<boolean>
asset__asset_number
string<character varying>
Maximum string length: 80
asset__commissioning_date
string<date>
asset__created_at
string<timestamp with time zone>
asset__created_by_name
string<character varying>
Maximum string length: 200
asset__criticality
string<character varying>
Maximum string length: 40
asset__criticality_rank
integer<smallint>
asset__criticality_response_minutes
integer<integer>
asset__custodian
string<character varying>
asset__custodian_email
string<public.citext>
asset__custody_since
string<date>
asset__custom_fields
string<jsonb>
asset__health_score
number<numeric>
asset__installation_date
string<date>
asset__is_retired
boolean<boolean>
asset__latitude
number<numeric>
asset__location_name
string<character varying>
Maximum string length: 200
asset__longitude
number<numeric>
asset__manufacturer
string<character varying>
Maximum string length: 200
asset__model_code
string<character varying>
Maximum string length: 80
asset__model_name
string<character varying>
Maximum string length: 200
asset__name
string<character varying>
Maximum string length: 250
asset__parent_asset_number
string<character varying>
Maximum string length: 80
asset__purchase_date
string<date>
asset__serial_number
string<character varying>
Maximum string length: 120
asset__site_code
string<character varying>
Maximum string length: 50
asset__site_name
string<character varying>
Maximum string length: 200
asset__status
string<character varying>
Maximum string length: 60
asset__status_category
string<character varying>
Maximum string length: 20
asset__status_label
string<text>
asset__updated_at
string<timestamp with time zone>
asset__updated_by_name
string<character varying>
Maximum string length: 200
asset__warranty_expires_on
string<date>
asset_id
string<uuid>

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

asset_image_file_id
string<uuid>
asset_name
string<character varying>
Maximum string length: 250
asset_number
string<character varying>
Maximum string length: 80
assigned_team_id
string<uuid>

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

assigned_team_name
string<character varying>
Maximum string length: 200
assigned_vendor_id
string<uuid>

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

assigned_vendor_name
string<character varying>
Maximum string length: 200
assigned_worker_id
string<uuid>

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

assigned_worker_name
string<character varying>
Maximum string length: 200
category
string<character varying>
Maximum string length: 60
category_name
string<character varying>
Maximum string length: 200
cc
string<jsonb>
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>
description
string<text>
discovered_at
string<timestamp with time zone>
duplicate_of__asset_name
string<character varying>
Maximum string length: 250
duplicate_of__asset_number
string<character varying>
Maximum string length: 80
duplicate_of__assigned_team_name
string<character varying>
Maximum string length: 200
duplicate_of__assigned_vendor_name
string<character varying>
Maximum string length: 200
duplicate_of__assigned_worker_name
string<character varying>
Maximum string length: 200
duplicate_of__category
string<character varying>
Maximum string length: 60
duplicate_of__category_name
string<character varying>
Maximum string length: 200
duplicate_of__cc
string<jsonb>
duplicate_of__created_at
string<timestamp with time zone>
duplicate_of__created_by_name
string<character varying>
Maximum string length: 200
duplicate_of__custom_fields
string<jsonb>
duplicate_of__description
string<text>
duplicate_of__discovered_at
string<timestamp with time zone>
duplicate_of__rejection_reason
string<text>
duplicate_of__reported_severity
string<character varying>
Maximum string length: 20
duplicate_of__request_number
string<character varying>
Maximum string length: 60
duplicate_of__requester_name
string<character varying>
Maximum string length: 200
duplicate_of__severity_rank
integer<integer>
duplicate_of__source
string<character varying>
Maximum string length: 40
duplicate_of__status
string<character varying>
Maximum string length: 60
duplicate_of__status_category
string<character varying>
Maximum string length: 20
duplicate_of__status_label
string<text>
duplicate_of__suggested_priority_code
string<character varying>
Maximum string length: 40
duplicate_of__suggested_priority_name
string<character varying>
Maximum string length: 150
duplicate_of__summary
string<character varying>
Maximum string length: 250
duplicate_of__triaged_at
string<timestamp with time zone>
duplicate_of__updated_at
string<timestamp with time zone>
duplicate_of__updated_by_name
string<character varying>
Maximum string length: 200
duplicate_of__work_order_number
string<character varying>
Maximum string length: 60
duplicate_of_work_request_id
string<uuid>

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

id
string<uuid>

Note: This is a Primary Key.

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.

pending_approval_request_id
string<uuid>
primary_image_file_id
string<uuid>
reference_records
string<jsonb>
rejection_reason
string<text>
reported_severity
string<character varying>
Maximum string length: 20
request_number
string<character varying>
Maximum string length: 60
requested_by__email
string<public.citext>
requested_by__last_login_at
string<timestamp with time zone>
requested_by__name
string<character varying>
Maximum string length: 200
requested_by__phone
string<character varying>
Maximum string length: 40
requested_by__sign_in_handle
string<text>
requested_by__status
string<character varying>
Maximum string length: 30
requested_by__username
string<public.citext>
requested_by__worker_is_active
boolean<boolean>
requested_by__worker_name
string<character varying>
Maximum string length: 200
requested_by__worker_number
string<character varying>
Maximum string length: 60
requested_by__worker_teams
string<jsonb>
requested_by__worker_type
string<character varying>
Maximum string length: 150
requested_by_user_id
string<uuid>

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

requester_name
string<character varying>
Maximum string length: 200
row_version
integer<bigint>
severity_rank
integer<integer>
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_id
string<uuid>

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

source
string<character varying>
Maximum string length: 40
status
string<character varying>
Maximum string length: 60
status_category
string<character varying>
Maximum string length: 20
status_label
string<text>
suggested_priority_code
string<character varying>
Maximum string length: 40
suggested_priority_name
string<character varying>
Maximum string length: 150
suggested_work_order_priority_id
string<uuid>

Note: This is a Foreign Key to request_severity_priorities.work_order_priority_id.

summary
string<character varying>
Maximum string length: 250
triaged_at
string<timestamp with time zone>
triaged_by__email
string<public.citext>
triaged_by__last_login_at
string<timestamp with time zone>
triaged_by__name
string<character varying>
Maximum string length: 200
triaged_by__phone
string<character varying>
Maximum string length: 40
triaged_by__sign_in_handle
string<text>
triaged_by__status
string<character varying>
Maximum string length: 30
triaged_by__username
string<public.citext>
triaged_by__worker_is_active
boolean<boolean>
triaged_by__worker_name
string<character varying>
Maximum string length: 200
triaged_by__worker_number
string<character varying>
Maximum string length: 60
triaged_by__worker_teams
string<jsonb>
triaged_by__worker_type
string<character varying>
Maximum string length: 150
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
work_order_id
string<uuid>
work_order_number
string<character varying>
Maximum string length: 60
work_request_category_id
string<uuid>

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