--- title: "Advanced search agency shift manifest data export" method: POST path: "/agency/{agency_id}/exports/advanced-search-assignments" tags: ["Data exports"] --- # Advanced search agency shift manifest data export `POST /agency/{agency_id}/exports/advanced-search-assignments` ## Request - Base URL: `http://localhost:3010/v1` - URL: `http://localhost:3010/v1/agency/{agency_id}/exports/advanced-search-assignments` - Auth: HTTP basic ## Request body - AgencyShiftManifestDataExportPayload - `sort` AgencyShiftManifestSortItems[] - `project_config` object - `order_reference` ProjectConfigField - `column_name` string, required - `timesheet_number` ProjectConfigField - `column_name` string, required - `agency_shift_booked_candidate_full_name` ProjectConfigField - `column_name` string, required - `timesheet_candidate_name` ProjectConfigField - `column_name` string, required - `agency_shift_booked_candidate_payroll_number` ProjectConfigField - `column_name` string, required - `timesheet_candidate_agency_reference` ProjectConfigField - `column_name` string, required - `order_job_title_id` ProjectConfigField - `column_name` string, required - `timesheet_job_title_id` ProjectConfigField - `column_name` string, required - `shift_start_date` ProjectConfigField - `column_name` string, required - `shift_end_date` ProjectConfigField - `column_name` string, required - `agency_shift_booked_minutes` ProjectConfigField - `column_name` string, required - `time_interval_total_billable_minutes` ProjectConfigField - `column_name` string, required - `time_interval_total_non_billable_minutes` ProjectConfigField - `column_name` string, required - `time_interval_start_date` ProjectConfigField - `column_name` string, required - `time_interval_end_date` ProjectConfigField - `column_name` string, required - `minutes_difference` ProjectConfigField - `column_name` string, required - `period_end_date` ProjectConfigField - `column_name` string, required - `timesheet_job_family_id` ProjectConfigField - `column_name` string, required - `order_job_family_id` ProjectConfigField - `column_name` string, required - `timesheet_po_number` ProjectConfigField - `column_name` string, required - `time_interval_shift_reference` ProjectConfigField - `column_name` string, required - `order_po_number` ProjectConfigField - `column_name` string, required - `agency_shift_reference_number` ProjectConfigField - `column_name` string, required - `timesheet_ward_reference` ProjectConfigField - `column_name` string, required - `timesheet_ward_name` ProjectConfigField - `column_name` string, required - `order_ward_name` ProjectConfigField - `column_name` string, required - `order_organisation_id` ProjectConfigField - `column_name` string, required - `order_site_id` ProjectConfigField - `column_name` string, required - `agency_shift_booked_assignment_created_date` ProjectConfigField - `column_name` string, required - `agency_shift_status_code` ProjectConfigField - `column_name` string, required - `timesheet_contract_total_gross_charge_incl_vat` ProjectConfigField - `column_name` string, required - `timesheet_contract_total_gross_pay` ProjectConfigField - `column_name` string, required - `timesheet_contract_total_expense_pay` ProjectConfigField - `column_name` string, required - `time_interval_contract_pay` ProjectConfigField - `column_name` string, required - `timesheet_status` ProjectConfigField - `column_name` string, required - `time_interval_status` ProjectConfigField - `column_name` string, required - `time_interval_authorised` ProjectConfigField - `column_name` string, required - `time_interval_confirmed` ProjectConfigField - `column_name` string, required - `contract_change` ProjectConfigField - `column_name` string, required - `timesheet_contract_id` ProjectConfigField - `column_name` string, required - `agency_order_contract_id` ProjectConfigField - `column_name` string, required - `job_title_change` ProjectConfigField - `column_name` string, required - `ward_change` ProjectConfigField - `column_name` string, required - `agency_shift_booked_assignment_created_user_username` ProjectConfigField - `column_name` string, required - `agency_shift_booked_assignment_created_user_fullname` ProjectConfigField - `column_name` string, required - `timesheet_currency` ProjectConfigField - `column_name` string, required - `order_site_name` ProjectConfigField - `column_name` string, required - `order_organisation_name` ProjectConfigField - `column_name` string, required - `order_job_family_name` ProjectConfigField - `column_name` string, required - `timesheet_job_family_name` ProjectConfigField - `column_name` string, required - `order_job_title_name` ProjectConfigField - `column_name` string, required - `timesheet_job_title_name` ProjectConfigField - `column_name` string, required - `agency_order_contract_name` ProjectConfigField - `column_name` string, required - `timesheet_contract_name` ProjectConfigField - `column_name` string, required - `agency_shift_compliance_contract_id` ProjectConfigField - `column_name` string, required - `agency_shift_compliance_contract_link_id` ProjectConfigField - `column_name` string, required - `timesheet_payroll_review_status` ProjectConfigField - `column_name` string, required - `timesheet_contract_vat_auto_resolved` ProjectConfigField - `column_name` string, required - `project` object, required - `order_agency_id` 1 - `shift_id` 1 - `order_id` 1 - `agency_order_id` 1 - `agency_order_status` 1 - `agency_order_requires_po_number` 1 - `shift_start_date` 1 - `shift_end_date` 1 - `shift_status_code` 1 - `agency_shift_requires_shift_ref` 1 - `agency_shift_status_code` 1 - `agency_shift_reference_number` 1 - `order_job_title_id` 1 - `order_job_title_name` 1 - `order_job_family_id` 1 - `order_job_family_name` 1 - `order_reference` 1 - `order_status` 1 - `order_po_number` 1 - `order_organisation_id` 1 - `order_organisation_name` 1 - `order_site_id` 1 - `order_site_name` 1 - `order_ward_id` 1 - `order_ward_name` 1 - `agency_order_contract_id` 1 - `agency_order_contract_name` 1 - `agency_order_contract_version` 1 - `agency_order_contract_link` 1 - `agency_order_contract_vat_applicable` 1 - `agency_order_contract_unit` 1 - `agency_order_contract_initial_start_date` 1 - `agency_order_contract_final_end_date` 1 - `agency_order_contract_currency` 1 - `agency_shift_booked_minutes` 1 - `agency_shift_booked_resource_id` 1 - `agency_shift_booked_assignment_id` 1 - `agency_shift_booked_candidate_id` 1 - `agency_shift_booked_candidate_full_name` 1 - `agency_shift_booked_candidate_payroll_number` 1 - `agency_shift_contract_charge` 1 - `agency_shift_contract_pay` 1 - `agency_shift_contract_vat` 1 - `agency_shift_contract_charge_incl_vat` 1 - `timesheet_id` 1 - `timesheet_number` 1 - `timesheet_status` 1 - `period_start_date` 1 - `period_end_date` 1 - `period_start_datetime` 1 - `period_end_datetime` 1 - `first_time_interval_start` 1 - `timesheet_candidate_id` 1 - `timesheet_candidate_name` 1 - `timesheet_candidate_agency_reference` 1 - `timesheet_agency_name` 1 - `timesheet_organisation_id` 1 - `timesheet_organisation_name` 1 - `timesheet_site_id` 1 - `timesheet_site_name` 1 - `timesheet_ward_id` 1 - `timesheet_ward_name` 1 - `timesheet_site_reference` 1 - `timesheet_ward_reference` 1 - `timesheet_currency` 1 - `total_expenses` 1 - `time_interval_id` 1 - `time_interval_status` 1 - `time_interval_start_date` 1 - `time_interval_end_date` 1 - `time_interval_shift_reference` 1 - `time_interval_total_minutes` 1 - `time_interval_total_billable_minutes` 1 - `time_interval_total_non_billable_minutes` 1 - `time_interval_authorised_by_user_id` 1 - `time_interval_authorised_by_full_name` 1 - `time_interval_authorised_date` 1 - `time_interval_confirmed_by_user_id` 1 - `time_interval_confirmed_by_full_name` 1 - `time_interval_authorised_client_contact_name` 1 - `time_interval_contract_pay` 1 - `time_interval_contract_charge` 1 - `time_interval_contract_vat` 1 - `time_interval_contract_charge_incl_vat` 1 - `time_interval_confirmed` 1 - `time_interval_authorised` 1 - `invoice_client_reference` 1 - `client_reference` 1 - `billing_path_info_id` 1 - `total_minutes` 1 - `timesheet_original_po_number` 1 - `timesheet_po_number` 1 - `timesheet_date_created` 1 - `timesheet_date_modified` 1 - `timesheet_exported` 1 - `timesheet_job_title_id` 1 - `timesheet_job_title_name` 1 - `timesheet_job_family_id` 1 - `timesheet_job_family_name` 1 - `timesheet_contract_id` 1 - `timesheet_contract_name` 1 - `timesheet_contract_version` 1 - `timesheet_contract_link` 1 - `timesheet_contract_vat_applicable` 1 - `timesheet_contract_unit` 1 - `timesheet_contract_total_pay` 1 - `timesheet_contract_total_expense_pay` 1 - `timesheet_contract_total_gross_pay` 1 - `timesheet_contract_total_charge` 1 - `timesheet_contract_total_expense_charge` 1 - `timesheet_contract_total_gross_charge` 1 - `timesheet_contract_total_vat` 1 - `timesheet_contract_total_expense_vat` 1 - `timesheet_contract_total_gross_vat` 1 - `timesheet_contract_total_gross_charge_incl_vat` 1 - `minutes_difference` 1 - `ward_change` 1 - `job_title_change` 1 - `contract_change` 1 - `time_interval_breakdown` 1 - `agency_shift_booked_assignment_created_user_id` 1 - `agency_shift_booked_assignment_created_user_username` 1 - `agency_shift_booked_assignment_created_user_firstname` 1 - `agency_shift_booked_assignment_created_user_lastname` 1 - `agency_shift_booked_assignment_created_user_fullname` 1 - `agency_shift_booked_assignment_created_user_context_type` 1 - `agency_shift_booked_assignment_created_user_context_id` 1 - `agency_shift_booked_assignment_created_date` 1 - `agency_shift_compliance_contract_id` 1 - `agency_shift_compliance_contract_link_id` 1 - `timesheet_payroll_review_status` 1 - `timesheet_contract_vat_auto_resolved` 1 - `query` AgencyShiftManifestQuery - `and` AgencyShiftManifestAdvancedSearchQueryFields[] - `and` AgencyShiftManifestAdvancedSearchQueryFields[] - `or` AgencyShiftManifestAdvancedSearchQueryFields[] - `order_reference` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `order_agency_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_booked_candidate_full_name` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_booked_candidate_payroll_number` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `order_site_name` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `order_organisation_name` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `order_ward_name` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_reference_number` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `order_po_number` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `order_job_family_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `order_job_title_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `shift_start_date` AdvancedSearchOperationsDateField - `equal` string, date-time, nullable - `greater_than` string, date-time, nullable - `less_than` string, date-time, nullable - `greater_than_equal` string, date-time, nullable - `less_than_equal` string, date-time, nullable - `in` string[] - `shift_end_date` AdvancedSearchOperationsDateField - `equal` string, date-time, nullable - `greater_than` string, date-time, nullable - `less_than` string, date-time, nullable - `greater_than_equal` string, date-time, nullable - `less_than_equal` string, date-time, nullable - `in` string[] - `agency_shift_booked_minutes` AdvancedSearchOperationsIntegerField - `equal` integer, nullable - `greater_than` integer, nullable - `less_than` integer, nullable - `greater_than_equal` integer, nullable - `less_than_equal` integer, nullable - `in` integer[] - `nin` integer[] - `agency_order_contract_name` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_status_code` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `order_site_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `order_organisation_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_order_contract_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_contract_pay` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `agency_shift_contract_charge` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `agency_shift_contract_charge_incl_vat` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `timesheet_number` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_candidate_name` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_candidate_agency_reference` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_ward_name` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_ward_reference` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `time_interval_shift_reference` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_po_number` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_job_family_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_job_title_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `time_interval_total_billable_minutes` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `time_interval_total_non_billable_minutes` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `period_end_date` AdvancedSearchOperationsDateField - `equal` string, date-time, nullable - `greater_than` string, date-time, nullable - `less_than` string, date-time, nullable - `greater_than_equal` string, date-time, nullable - `less_than_equal` string, date-time, nullable - `in` string[] - `time_interval_start_date` AdvancedSearchOperationsDateField - `equal` string, date-time, nullable - `greater_than` string, date-time, nullable - `less_than` string, date-time, nullable - `greater_than_equal` string, date-time, nullable - `less_than_equal` string, date-time, nullable - `in` string[] - `time_interval_end_date` AdvancedSearchOperationsDateField - `equal` string, date-time, nullable - `greater_than` string, date-time, nullable - `less_than` string, date-time, nullable - `greater_than_equal` string, date-time, nullable - `less_than_equal` string, date-time, nullable - `in` string[] - `minutes_difference` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `ward_change` AdvancedSearchOperationsBooleanField - `equal` boolean - `job_title_change` AdvancedSearchOperationsBooleanField - `equal` boolean - `timesheet_contract_name` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_contract_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `contract_change` AdvancedSearchOperationsBooleanField - `equal` boolean - `time_interval_confirmed` AdvancedSearchOperationsBooleanField - `equal` boolean - `time_interval_authorised` AdvancedSearchOperationsBooleanField - `equal` boolean - `time_interval_status` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_status` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_payroll_review_status` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `time_interval_contract_pay` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `timesheet_contract_total_expense_pay` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `timesheet_contract_total_gross_pay` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `timesheet_contract_total_gross_charge_incl_vat` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `agency_shift_booked_assignment_created_user_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_booked_assignment_created_user_username` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_booked_assignment_created_user_firstname` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_booked_assignment_created_user_lastname` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_booked_assignment_created_user_fullname` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_booked_assignment_created_user_context_type` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_booked_assignment_created_user_context_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_booked_assignment_created_date` AdvancedSearchOperationsDateField - `equal` string, date-time, nullable - `greater_than` string, date-time, nullable - `less_than` string, date-time, nullable - `greater_than_equal` string, date-time, nullable - `less_than_equal` string, date-time, nullable - `in` string[] - `agency_shift_compliance_contract_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_compliance_contract_link_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `client_tag_links` object - `tag_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `contains` AdvancedSearchTagsLinksQueryFields[] - `tag_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `contains_any` AdvancedSearchTagsLinksQueryFields[] - `tag_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `client_consultants` object - `consultant_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `consultant_role_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `contains` AdvancedSearchClientConsultantsQueryFields[] - `consultant_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `consultant_role_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `contains_any` AdvancedSearchClientConsultantsQueryFields[] - `consultant_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `consultant_role_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `or` AgencyShiftManifestAdvancedSearchQueryFields[] - `and` AgencyShiftManifestAdvancedSearchQueryFields[] - `or` AgencyShiftManifestAdvancedSearchQueryFields[] - `order_reference` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `order_agency_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_booked_candidate_full_name` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_booked_candidate_payroll_number` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `order_site_name` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `order_organisation_name` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `order_ward_name` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_reference_number` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `order_po_number` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `order_job_family_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `order_job_title_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `shift_start_date` AdvancedSearchOperationsDateField - `equal` string, date-time, nullable - `greater_than` string, date-time, nullable - `less_than` string, date-time, nullable - `greater_than_equal` string, date-time, nullable - `less_than_equal` string, date-time, nullable - `in` string[] - `shift_end_date` AdvancedSearchOperationsDateField - `equal` string, date-time, nullable - `greater_than` string, date-time, nullable - `less_than` string, date-time, nullable - `greater_than_equal` string, date-time, nullable - `less_than_equal` string, date-time, nullable - `in` string[] - `agency_shift_booked_minutes` AdvancedSearchOperationsIntegerField - `equal` integer, nullable - `greater_than` integer, nullable - `less_than` integer, nullable - `greater_than_equal` integer, nullable - `less_than_equal` integer, nullable - `in` integer[] - `nin` integer[] - `agency_order_contract_name` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_status_code` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `order_site_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `order_organisation_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_order_contract_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_contract_pay` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `agency_shift_contract_charge` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `agency_shift_contract_charge_incl_vat` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `timesheet_number` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_candidate_name` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_candidate_agency_reference` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_ward_name` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_ward_reference` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `time_interval_shift_reference` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_po_number` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_job_family_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_job_title_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `time_interval_total_billable_minutes` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `time_interval_total_non_billable_minutes` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `period_end_date` AdvancedSearchOperationsDateField - `equal` string, date-time, nullable - `greater_than` string, date-time, nullable - `less_than` string, date-time, nullable - `greater_than_equal` string, date-time, nullable - `less_than_equal` string, date-time, nullable - `in` string[] - `time_interval_start_date` AdvancedSearchOperationsDateField - `equal` string, date-time, nullable - `greater_than` string, date-time, nullable - `less_than` string, date-time, nullable - `greater_than_equal` string, date-time, nullable - `less_than_equal` string, date-time, nullable - `in` string[] - `time_interval_end_date` AdvancedSearchOperationsDateField - `equal` string, date-time, nullable - `greater_than` string, date-time, nullable - `less_than` string, date-time, nullable - `greater_than_equal` string, date-time, nullable - `less_than_equal` string, date-time, nullable - `in` string[] - `minutes_difference` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `ward_change` AdvancedSearchOperationsBooleanField - `equal` boolean - `job_title_change` AdvancedSearchOperationsBooleanField - `equal` boolean - `timesheet_contract_name` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_contract_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `contract_change` AdvancedSearchOperationsBooleanField - `equal` boolean - `time_interval_confirmed` AdvancedSearchOperationsBooleanField - `equal` boolean - `time_interval_authorised` AdvancedSearchOperationsBooleanField - `equal` boolean - `time_interval_status` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_status` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `timesheet_payroll_review_status` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `time_interval_contract_pay` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `timesheet_contract_total_expense_pay` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `timesheet_contract_total_gross_pay` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `timesheet_contract_total_gross_charge_incl_vat` AdvancedSearchOperationsNumberField - `equal` number, nullable - `greater_than` number, nullable - `less_than` number, nullable - `greater_than_equal` number, nullable - `less_than_equal` number, nullable - `in` number[] - `nin` number[] - `agency_shift_booked_assignment_created_user_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_booked_assignment_created_user_username` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_booked_assignment_created_user_firstname` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_booked_assignment_created_user_lastname` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_booked_assignment_created_user_fullname` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_booked_assignment_created_user_context_type` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_booked_assignment_created_user_context_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_booked_assignment_created_date` AdvancedSearchOperationsDateField - `equal` string, date-time, nullable - `greater_than` string, date-time, nullable - `less_than` string, date-time, nullable - `greater_than_equal` string, date-time, nullable - `less_than_equal` string, date-time, nullable - `in` string[] - `agency_shift_compliance_contract_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `agency_shift_compliance_contract_link_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `client_tag_links` object - `tag_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `contains` AdvancedSearchTagsLinksQueryFields[] - `tag_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `contains_any` AdvancedSearchTagsLinksQueryFields[] - `tag_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `client_consultants` object - `consultant_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `consultant_role_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `contains` AdvancedSearchClientConsultantsQueryFields[] - `consultant_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `consultant_role_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `contains_any` AdvancedSearchClientConsultantsQueryFields[] - `consultant_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable - `consultant_role_id` AdvancedSearchOperationsStringField - `like` string, nullable - `equal` string, nullable - `in` string[] - `nin` string[] - `greater_than` string, nullable - `less_than` string, nullable - `greater_than_equal` string, nullable - `less_than_equal` string, nullable ## Response `201` Data export record will be returned - AdvancedSearchDataExportsResponseDef - `_id` string, required - `updated_at` string, date-time, required - `created_at` string, date-time, required - `__v` integer, required - `payload` object, required - `timezone` string - `user_id` string, required - `processing_errors` object[] - `status` 'pending' | 'processing' | 'completed', required ## Other responses - `400`: Validation Error. Usually caused by a missing or invalid parameter. - `401`: Authorization Error. Thrown if the user does not have access to resource. - `403`: Permission denied error - `default`: Server error occurred --- [API](https://skmtc.dev/staffshift/apis/staffshift-api-gateway.md) - [All operations](https://skmtc.dev/staffshift/apis/staffshift-api-gateway/llms.txt) - [OpenAPI document](https://skmtc.dev/staffshift/apis/staffshift-api-gateway/revisions/1f079f6b65f5?raw)