> ## Documentation Index
> Fetch the complete documentation index at: https://docs.assetinfinity.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# The technician list (UI spec §19).

> Team, site, skills, certifications, availability, load and the latest computed performance period.



## OpenAPI

````yaml /api-reference/openapi.json get /technicians
openapi: 3.0.0
info:
  description: ''
  title: >-
    The only schema PostgREST exposes (ADR-014). Reads are security_invoker
    views; writes are SECURITY DEFINER functions. Rebuilt wholesale on every
    deploy — it holds no data.
  version: 12.2.3
servers:
  - url: https://app.assetinfinity.ai/api
security: []
tags:
  - name: Signing in
  - name: Profile
  - name: Assets
  - name: Asset lifecycle
  - name: Work lifecycle
  - name: Maintenance
  - name: Inventory
  - name: Inventory detail
  - name: Procurement
  - name: Contracts
  - name: Workforce
  - name: Capacity
  - name: Dispatch
  - name: Routing
  - name: Tools
  - name: Inspections
  - name: Verification
  - name: Reliability
  - name: Parts demand
  - name: Sensors and meters
  - name: Map
  - name: Floor plans
  - name: Labels
  - name: Lost and found
  - name: Root cause analysis
  - name: Reports
  - name: Audit center
  - name: Activity
  - name: Notifications
  - name: Channels
  - name: Search
  - name: Copilot
  - name: Import
  - name: Files
  - name: Sync
  - name: Support
  - name: Admin
  - name: Access
  - name: Lookups
  - name: Read models
  - name: Branding
  - name: Custom fields
  - name: Form studio
  - name: Workflows
  - name: Workflow studio
  - name: Rules
  - name: Statuses and transitions
  - name: Currencies and locales
  - name: Work configuration
  - name: Asset configuration
  - name: Inventory configuration
  - name: Tool configuration
  - name: Workforce configuration
  - name: Vendor and contract configuration
  - name: Document configuration
  - name: Inspection configuration
  - name: Sites, locations and the organisation
  - name: Platform
  - name: Self verification
  - name: Setup
  - name: Tools on a job, and who has them out
  - name: Vendors and contracts
  - name: Work order execution
  - name: Workforce detail
externalDocs:
  description: PostgREST Documentation
  url: https://postgrest.org/en/v12/references/api.html
paths:
  /technicians:
    get:
      tags:
        - Workforce detail
      summary: The technician list (UI spec §19).
      description: >-
        Team, site, skills, certifications, availability, load and the latest
        computed performance period.
      parameters:
        - $ref: '#/components/parameters/rowFilter.technicians.worker_id'
        - $ref: '#/components/parameters/rowFilter.technicians.worker_number'
        - $ref: '#/components/parameters/rowFilter.technicians.name'
        - $ref: '#/components/parameters/rowFilter.technicians.worker_type'
        - $ref: '#/components/parameters/rowFilter.technicians.primary_site_id'
        - $ref: >-
            #/components/parameters/rowFilter.technicians.max_concurrent_work_orders
        - $ref: '#/components/parameters/rowFilter.technicians.is_active'
        - $ref: '#/components/parameters/rowFilter.technicians.open_work_orders'
        - $ref: '#/components/parameters/rowFilter.technicians.active_work_orders'
        - $ref: '#/components/parameters/rowFilter.technicians.overdue_work_orders'
        - $ref: >-
            #/components/parameters/rowFilter.technicians.planned_minutes_outstanding
        - $ref: '#/components/parameters/rowFilter.technicians.skills'
        - $ref: '#/components/parameters/rowFilter.technicians.email'
        - $ref: '#/components/parameters/rowFilter.technicians.phone'
        - $ref: '#/components/parameters/rowFilter.technicians.employment_status'
        - $ref: '#/components/parameters/rowFilter.technicians.employment_start_date'
        - $ref: '#/components/parameters/rowFilter.technicians.can_travel'
        - $ref: '#/components/parameters/rowFilter.technicians.travel_radius_km'
        - $ref: '#/components/parameters/rowFilter.technicians.track_location'
        - $ref: '#/components/parameters/rowFilter.technicians.site_code'
        - $ref: '#/components/parameters/rowFilter.technicians.site_name'
        - $ref: '#/components/parameters/rowFilter.technicians.department_name'
        - $ref: '#/components/parameters/rowFilter.technicians.team_name'
        - $ref: '#/components/parameters/rowFilter.technicians.is_team_lead'
        - $ref: '#/components/parameters/rowFilter.technicians.availability'
        - $ref: '#/components/parameters/rowFilter.technicians.valid_certifications'
        - $ref: >-
            #/components/parameters/rowFilter.technicians.certifications_expiring
        - $ref: '#/components/parameters/rowFilter.technicians.certifications_lapsed'
        - $ref: >-
            #/components/parameters/rowFilter.technicians.next_certification_expiry
        - $ref: >-
            #/components/parameters/rowFilter.technicians.performance_period_start
        - $ref: '#/components/parameters/rowFilter.technicians.performance_period_end'
        - $ref: '#/components/parameters/rowFilter.technicians.utilisation_rate'
        - $ref: '#/components/parameters/rowFilter.technicians.first_time_fix_rate'
        - $ref: '#/components/parameters/rowFilter.technicians.sla_compliance_rate'
        - $ref: '#/components/parameters/rowFilter.technicians.completed_in_period'
        - $ref: '#/components/parameters/select'
        - $ref: '#/components/parameters/order'
        - $ref: '#/components/parameters/range'
        - $ref: '#/components/parameters/rangeUnit'
        - $ref: '#/components/parameters/offset'
        - $ref: '#/components/parameters/limit'
        - $ref: '#/components/parameters/preferCount'
      responses:
        '200':
          content:
            application/json:
              schema:
                items:
                  $ref: '#/components/schemas/technicians'
                type: array
            application/vnd.pgrst.object+json:
              schema:
                items:
                  $ref: '#/components/schemas/technicians'
                type: array
            application/vnd.pgrst.object+json;nulls=stripped:
              schema:
                items:
                  $ref: '#/components/schemas/technicians'
                type: array
            text/csv:
              schema:
                items:
                  $ref: '#/components/schemas/technicians'
                type: array
          description: OK
        '206':
          description: Partial Content
components:
  parameters:
    rowFilter.technicians.worker_id:
      in: query
      name: worker_id
      required: false
      schema:
        type: string
    rowFilter.technicians.worker_number:
      in: query
      name: worker_number
      required: false
      schema:
        type: string
    rowFilter.technicians.name:
      in: query
      name: name
      required: false
      schema:
        type: string
    rowFilter.technicians.worker_type:
      in: query
      name: worker_type
      required: false
      schema:
        type: string
    rowFilter.technicians.primary_site_id:
      in: query
      name: primary_site_id
      required: false
      schema:
        type: string
    rowFilter.technicians.max_concurrent_work_orders:
      in: query
      name: max_concurrent_work_orders
      required: false
      schema:
        type: string
    rowFilter.technicians.is_active:
      in: query
      name: is_active
      required: false
      schema:
        type: string
    rowFilter.technicians.open_work_orders:
      in: query
      name: open_work_orders
      required: false
      schema:
        type: string
    rowFilter.technicians.active_work_orders:
      in: query
      name: active_work_orders
      required: false
      schema:
        type: string
    rowFilter.technicians.overdue_work_orders:
      in: query
      name: overdue_work_orders
      required: false
      schema:
        type: string
    rowFilter.technicians.planned_minutes_outstanding:
      in: query
      name: planned_minutes_outstanding
      required: false
      schema:
        type: string
    rowFilter.technicians.skills:
      in: query
      name: skills
      required: false
      schema:
        type: string
    rowFilter.technicians.email:
      in: query
      name: email
      required: false
      schema:
        type: string
    rowFilter.technicians.phone:
      in: query
      name: phone
      required: false
      schema:
        type: string
    rowFilter.technicians.employment_status:
      in: query
      name: employment_status
      required: false
      schema:
        type: string
    rowFilter.technicians.employment_start_date:
      in: query
      name: employment_start_date
      required: false
      schema:
        type: string
    rowFilter.technicians.can_travel:
      in: query
      name: can_travel
      required: false
      schema:
        type: string
    rowFilter.technicians.travel_radius_km:
      in: query
      name: travel_radius_km
      required: false
      schema:
        type: string
    rowFilter.technicians.track_location:
      in: query
      name: track_location
      required: false
      schema:
        type: string
    rowFilter.technicians.site_code:
      in: query
      name: site_code
      required: false
      schema:
        type: string
    rowFilter.technicians.site_name:
      in: query
      name: site_name
      required: false
      schema:
        type: string
    rowFilter.technicians.department_name:
      in: query
      name: department_name
      required: false
      schema:
        type: string
    rowFilter.technicians.team_name:
      in: query
      name: team_name
      required: false
      schema:
        type: string
    rowFilter.technicians.is_team_lead:
      in: query
      name: is_team_lead
      required: false
      schema:
        type: string
    rowFilter.technicians.availability:
      in: query
      name: availability
      required: false
      schema:
        type: string
    rowFilter.technicians.valid_certifications:
      in: query
      name: valid_certifications
      required: false
      schema:
        type: string
    rowFilter.technicians.certifications_expiring:
      in: query
      name: certifications_expiring
      required: false
      schema:
        type: string
    rowFilter.technicians.certifications_lapsed:
      in: query
      name: certifications_lapsed
      required: false
      schema:
        type: string
    rowFilter.technicians.next_certification_expiry:
      in: query
      name: next_certification_expiry
      required: false
      schema:
        type: string
    rowFilter.technicians.performance_period_start:
      in: query
      name: performance_period_start
      required: false
      schema:
        type: string
    rowFilter.technicians.performance_period_end:
      in: query
      name: performance_period_end
      required: false
      schema:
        type: string
    rowFilter.technicians.utilisation_rate:
      in: query
      name: utilisation_rate
      required: false
      schema:
        type: string
    rowFilter.technicians.first_time_fix_rate:
      in: query
      name: first_time_fix_rate
      required: false
      schema:
        type: string
    rowFilter.technicians.sla_compliance_rate:
      in: query
      name: sla_compliance_rate
      required: false
      schema:
        type: string
    rowFilter.technicians.completed_in_period:
      in: query
      name: completed_in_period
      required: false
      schema:
        type: string
    select:
      description: Filtering Columns
      in: query
      name: select
      required: false
      schema:
        type: string
    order:
      description: Ordering
      in: query
      name: order
      required: false
      schema:
        type: string
    range:
      description: Limiting and Pagination
      in: header
      name: Range
      required: false
      schema:
        type: string
    rangeUnit:
      description: Limiting and Pagination
      in: header
      name: Range-Unit
      required: false
      schema:
        default: items
        type: string
    offset:
      description: Limiting and Pagination
      in: query
      name: offset
      required: false
      schema:
        type: string
    limit:
      description: Limiting and Pagination
      in: query
      name: limit
      required: false
      schema:
        type: string
    preferCount:
      description: Preference
      in: header
      name: Prefer
      required: false
      schema:
        enum:
          - count=none
        type: string
  schemas:
    technicians:
      description: >-
        The technician list (UI spec §19).


        Team, site, skills, certifications, availability, load and the latest
        computed performance period.
      properties:
        active_work_orders:
          format: bigint
          type: integer
        availability:
          format: text
          type: string
        can_travel:
          format: boolean
          type: boolean
        certifications_expiring:
          format: bigint
          type: integer
        certifications_lapsed:
          format: bigint
          type: integer
        completed_in_period:
          format: integer
          type: integer
        department_name:
          format: character varying
          maxLength: 200
          type: string
        email:
          format: public.citext
          type: string
        employment_start_date:
          format: date
          type: string
        employment_status:
          format: character varying
          maxLength: 30
          type: string
        first_time_fix_rate:
          format: numeric
          type: number
        is_active:
          format: boolean
          type: boolean
        is_team_lead:
          format: boolean
          type: boolean
        max_concurrent_work_orders:
          format: smallint
          type: integer
        name:
          format: character varying
          maxLength: 200
          type: string
        next_certification_expiry:
          format: date
          type: string
        open_work_orders:
          format: bigint
          type: integer
        overdue_work_orders:
          format: bigint
          type: integer
        performance_period_end:
          format: date
          type: string
        performance_period_start:
          format: date
          type: string
        phone:
          format: character varying
          maxLength: 40
          type: string
        planned_minutes_outstanding:
          format: integer
          type: integer
        primary_site_id:
          description: >-
            Note:

            This is a Foreign Key to `site_settings.id`.<fk
            table='site_settings' column='id'/>
          format: uuid
          type: string
        site_code:
          format: character varying
          maxLength: 50
          type: string
        site_name:
          format: character varying
          maxLength: 200
          type: string
        skills:
          format: jsonb
        sla_compliance_rate:
          format: numeric
          type: number
        team_name:
          format: character varying
          maxLength: 200
          type: string
        track_location:
          format: boolean
          type: boolean
        travel_radius_km:
          format: integer
          type: integer
        utilisation_rate:
          format: numeric
          type: number
        valid_certifications:
          format: bigint
          type: integer
        worker_id:
          description: |-
            Note:
            This is a Primary Key.<pk/>
          format: uuid
          type: string
        worker_number:
          format: character varying
          maxLength: 60
          type: string
        worker_type:
          format: character varying
          maxLength: 40
          type: string
      type: object

````

## Related topics

- [Technicians](/workforce/technicians.md)
- [Inside a technician](/workforce/technician-detail.md)
- [The work order list](/work/work-orders.md)
- [The skills matrix](/workforce/skills.md)
- [Today and Work](/field/today-and-work.md)