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

# Asset register with resolved category, status, site and custom fields.



## OpenAPI

````yaml /api-reference/openapi.json get /assets
openapi: 3.0.0
info:
  description: ''
  title: >-
    The only schema PostgREST exposes. 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: 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: Amendments
  - name: Asset clone
  - name: Asset components
  - name: Asset register
  - name: Asset transfer
  - name: Audit feed
  - name: Billing
  - name: Bookings
  - name: Budgets
  - name: Bulk jobs
  - name: Calibration history
  - name: Capex plans
  - name: Conversations
  - name: Costing
  - name: Currency
  - name: Dashboards
  - name: Directory sync
  - name: Document control
  - name: Document folders
  - name: Document tree
  - name: Documents
  - name: Energy
  - name: Extracts
  - name: Features
  - name: Feeds
  - name: File exchange
  - name: Filing exceptions
  - name: Finance
  - name: Inbound mail
  - name: Keys
  - name: Knowledge
  - name: Licence
  - name: List views
  - name: Locations
  - name: Mapping
  - name: Mcp
  - name: Mcp oauth
  - name: Mfa
  - name: Numbering
  - name: Permits
  - name: Readers
  - name: Reference
  - name: Reference columns
  - name: Reference entry
  - name: Release
  - name: Scim
  - name: Security streams
  - name: Self verification
  - name: Setup
  - name: Shutdown
  - name: Sso
  - name: Telegram
  - name: Tenant switch
  - name: The caller's own work
  - name: The checklist library
  - name: Tools on a job, and who has them out
  - name: Tray
  - name: Vendor spend forecast
  - name: Vendors and contracts
  - name: Visitors
  - name: Work order execution
  - name: Work sequencing
  - name: Workforce detail
externalDocs:
  description: PostgREST Documentation
  url: https://postgrest.org/en/v12/references/api.html
paths:
  /assets:
    get:
      tags:
        - Assets
      summary: Asset register with resolved category, status, site and custom fields.
      parameters:
        - $ref: '#/components/parameters/rowFilter.assets.id'
        - $ref: '#/components/parameters/rowFilter.assets.asset_number'
        - $ref: '#/components/parameters/rowFilter.assets.name'
        - $ref: '#/components/parameters/rowFilter.assets.serial_number'
        - $ref: '#/components/parameters/rowFilter.assets.asset_category_id'
        - $ref: '#/components/parameters/rowFilter.assets.asset_category_code'
        - $ref: '#/components/parameters/rowFilter.assets.asset_category'
        - $ref: '#/components/parameters/rowFilter.assets.asset_category_ancestor_ids'
        - $ref: '#/components/parameters/rowFilter.assets.asset_category_path'
        - $ref: '#/components/parameters/rowFilter.assets.asset_category_root_code'
        - $ref: '#/components/parameters/rowFilter.assets.asset_category_root'
        - $ref: '#/components/parameters/rowFilter.assets.asset_class_id'
        - $ref: '#/components/parameters/rowFilter.assets.asset_class_code'
        - $ref: '#/components/parameters/rowFilter.assets.asset_class'
        - $ref: '#/components/parameters/rowFilter.assets.asset_class_is_default'
        - $ref: '#/components/parameters/rowFilter.assets.status'
        - $ref: '#/components/parameters/rowFilter.assets.status_label'
        - $ref: '#/components/parameters/rowFilter.assets.status_category'
        - $ref: '#/components/parameters/rowFilter.assets.criticality'
        - $ref: '#/components/parameters/rowFilter.assets.criticality_rank'
        - $ref: >-
            #/components/parameters/rowFilter.assets.criticality_response_minutes
        - $ref: '#/components/parameters/rowFilter.assets.site_id'
        - $ref: '#/components/parameters/rowFilter.assets.site_code'
        - $ref: '#/components/parameters/rowFilter.assets.site_name'
        - $ref: '#/components/parameters/rowFilter.assets.location_id'
        - $ref: '#/components/parameters/rowFilter.assets.location_name'
        - $ref: '#/components/parameters/rowFilter.assets.latitude'
        - $ref: '#/components/parameters/rowFilter.assets.longitude'
        - $ref: '#/components/parameters/rowFilter.assets.parent_asset_id'
        - $ref: '#/components/parameters/rowFilter.assets.parent_asset_number'
        - $ref: '#/components/parameters/rowFilter.assets.manufacturer'
        - $ref: '#/components/parameters/rowFilter.assets.model_code'
        - $ref: '#/components/parameters/rowFilter.assets.model_name'
        - $ref: '#/components/parameters/rowFilter.assets.purchase_date'
        - $ref: '#/components/parameters/rowFilter.assets.installation_date'
        - $ref: '#/components/parameters/rowFilter.assets.commissioning_date'
        - $ref: '#/components/parameters/rowFilter.assets.warranty_expires_on'
        - $ref: '#/components/parameters/rowFilter.assets.health_score'
        - $ref: '#/components/parameters/rowFilter.assets.is_retired'
        - $ref: '#/components/parameters/rowFilter.assets.custodian_user_id'
        - $ref: '#/components/parameters/rowFilter.assets.custodian'
        - $ref: '#/components/parameters/rowFilter.assets.custodian_email'
        - $ref: '#/components/parameters/rowFilter.assets.custody_since'
        - $ref: '#/components/parameters/rowFilter.assets.primary_image_file_id'
        - $ref: '#/components/parameters/rowFilter.assets.custom_fields'
        - $ref: '#/components/parameters/rowFilter.assets.row_version'
        - $ref: '#/components/parameters/rowFilter.assets.created_at'
        - $ref: '#/components/parameters/rowFilter.assets.created_by_id'
        - $ref: '#/components/parameters/rowFilter.assets.created_by_name'
        - $ref: '#/components/parameters/rowFilter.assets.created_source'
        - $ref: '#/components/parameters/rowFilter.assets.updated_at'
        - $ref: '#/components/parameters/rowFilter.assets.updated_by_id'
        - $ref: '#/components/parameters/rowFilter.assets.updated_by_name'
        - $ref: '#/components/parameters/rowFilter.assets.search_text'
        - $ref: '#/components/parameters/rowFilter.assets.custom_text'
        - $ref: '#/components/parameters/rowFilter.assets.search_all'
        - $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/assets'
                type: array
            application/vnd.pgrst.object+json:
              schema:
                items:
                  $ref: '#/components/schemas/assets'
                type: array
            application/vnd.pgrst.object+json;nulls=stripped:
              schema:
                items:
                  $ref: '#/components/schemas/assets'
                type: array
            text/csv:
              schema:
                items:
                  $ref: '#/components/schemas/assets'
                type: array
          description: OK
        '206':
          description: Partial Content
components:
  parameters:
    rowFilter.assets.id:
      in: query
      name: id
      required: false
      schema:
        type: string
    rowFilter.assets.asset_number:
      in: query
      name: asset_number
      required: false
      schema:
        type: string
    rowFilter.assets.name:
      in: query
      name: name
      required: false
      schema:
        type: string
    rowFilter.assets.serial_number:
      in: query
      name: serial_number
      required: false
      schema:
        type: string
    rowFilter.assets.asset_category_id:
      in: query
      name: asset_category_id
      required: false
      schema:
        type: string
    rowFilter.assets.asset_category_code:
      in: query
      name: asset_category_code
      required: false
      schema:
        type: string
    rowFilter.assets.asset_category:
      in: query
      name: asset_category
      required: false
      schema:
        type: string
    rowFilter.assets.asset_category_ancestor_ids:
      in: query
      name: asset_category_ancestor_ids
      required: false
      schema:
        type: string
    rowFilter.assets.asset_category_path:
      in: query
      name: asset_category_path
      required: false
      schema:
        type: string
    rowFilter.assets.asset_category_root_code:
      in: query
      name: asset_category_root_code
      required: false
      schema:
        type: string
    rowFilter.assets.asset_category_root:
      in: query
      name: asset_category_root
      required: false
      schema:
        type: string
    rowFilter.assets.asset_class_id:
      in: query
      name: asset_class_id
      required: false
      schema:
        type: string
    rowFilter.assets.asset_class_code:
      in: query
      name: asset_class_code
      required: false
      schema:
        type: string
    rowFilter.assets.asset_class:
      in: query
      name: asset_class
      required: false
      schema:
        type: string
    rowFilter.assets.asset_class_is_default:
      in: query
      name: asset_class_is_default
      required: false
      schema:
        type: string
    rowFilter.assets.status:
      in: query
      name: status
      required: false
      schema:
        type: string
    rowFilter.assets.status_label:
      in: query
      name: status_label
      required: false
      schema:
        type: string
    rowFilter.assets.status_category:
      in: query
      name: status_category
      required: false
      schema:
        type: string
    rowFilter.assets.criticality:
      in: query
      name: criticality
      required: false
      schema:
        type: string
    rowFilter.assets.criticality_rank:
      in: query
      name: criticality_rank
      required: false
      schema:
        type: string
    rowFilter.assets.criticality_response_minutes:
      in: query
      name: criticality_response_minutes
      required: false
      schema:
        type: string
    rowFilter.assets.site_id:
      in: query
      name: site_id
      required: false
      schema:
        type: string
    rowFilter.assets.site_code:
      in: query
      name: site_code
      required: false
      schema:
        type: string
    rowFilter.assets.site_name:
      in: query
      name: site_name
      required: false
      schema:
        type: string
    rowFilter.assets.location_id:
      in: query
      name: location_id
      required: false
      schema:
        type: string
    rowFilter.assets.location_name:
      in: query
      name: location_name
      required: false
      schema:
        type: string
    rowFilter.assets.latitude:
      in: query
      name: latitude
      required: false
      schema:
        type: string
    rowFilter.assets.longitude:
      in: query
      name: longitude
      required: false
      schema:
        type: string
    rowFilter.assets.parent_asset_id:
      in: query
      name: parent_asset_id
      required: false
      schema:
        type: string
    rowFilter.assets.parent_asset_number:
      in: query
      name: parent_asset_number
      required: false
      schema:
        type: string
    rowFilter.assets.manufacturer:
      in: query
      name: manufacturer
      required: false
      schema:
        type: string
    rowFilter.assets.model_code:
      in: query
      name: model_code
      required: false
      schema:
        type: string
    rowFilter.assets.model_name:
      in: query
      name: model_name
      required: false
      schema:
        type: string
    rowFilter.assets.purchase_date:
      in: query
      name: purchase_date
      required: false
      schema:
        type: string
    rowFilter.assets.installation_date:
      in: query
      name: installation_date
      required: false
      schema:
        type: string
    rowFilter.assets.commissioning_date:
      in: query
      name: commissioning_date
      required: false
      schema:
        type: string
    rowFilter.assets.warranty_expires_on:
      in: query
      name: warranty_expires_on
      required: false
      schema:
        type: string
    rowFilter.assets.health_score:
      in: query
      name: health_score
      required: false
      schema:
        type: string
    rowFilter.assets.is_retired:
      in: query
      name: is_retired
      required: false
      schema:
        type: string
    rowFilter.assets.custodian_user_id:
      in: query
      name: custodian_user_id
      required: false
      schema:
        type: string
    rowFilter.assets.custodian:
      in: query
      name: custodian
      required: false
      schema:
        type: string
    rowFilter.assets.custodian_email:
      in: query
      name: custodian_email
      required: false
      schema:
        type: string
    rowFilter.assets.custody_since:
      in: query
      name: custody_since
      required: false
      schema:
        type: string
    rowFilter.assets.primary_image_file_id:
      in: query
      name: primary_image_file_id
      required: false
      schema:
        type: string
    rowFilter.assets.custom_fields:
      in: query
      name: custom_fields
      required: false
      schema:
        type: string
    rowFilter.assets.row_version:
      in: query
      name: row_version
      required: false
      schema:
        type: string
    rowFilter.assets.created_at:
      in: query
      name: created_at
      required: false
      schema:
        type: string
    rowFilter.assets.created_by_id:
      in: query
      name: created_by_id
      required: false
      schema:
        type: string
    rowFilter.assets.created_by_name:
      in: query
      name: created_by_name
      required: false
      schema:
        type: string
    rowFilter.assets.created_source:
      in: query
      name: created_source
      required: false
      schema:
        type: string
    rowFilter.assets.updated_at:
      in: query
      name: updated_at
      required: false
      schema:
        type: string
    rowFilter.assets.updated_by_id:
      in: query
      name: updated_by_id
      required: false
      schema:
        type: string
    rowFilter.assets.updated_by_name:
      in: query
      name: updated_by_name
      required: false
      schema:
        type: string
    rowFilter.assets.search_text:
      in: query
      name: search_text
      required: false
      schema:
        type: string
    rowFilter.assets.custom_text:
      in: query
      name: custom_text
      required: false
      schema:
        type: string
    rowFilter.assets.search_all:
      in: query
      name: search_all
      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:
    assets:
      description: Asset register with resolved category, status, site and custom fields.
      properties:
        asset_category:
          format: character varying
          maxLength: 200
          type: string
        asset_category_ancestor_ids:
          format: uuid[]
          items:
            type: string
          type: array
        asset_category_code:
          format: character varying
          maxLength: 60
          type: string
        asset_category_id:
          description: >-
            Note:

            This is a Foreign Key to `asset_categories.id`.<fk
            table='asset_categories' column='id'/>
          format: uuid
          type: string
        asset_category_path:
          format: text
          type: string
        asset_category_root:
          format: character varying
          maxLength: 200
          type: string
        asset_category_root_code:
          format: character varying
          maxLength: 60
          type: string
        asset_class:
          format: character varying
          type: string
        asset_class_code:
          format: character varying
          type: string
        asset_class_id:
          format: uuid
          type: string
        asset_class_is_default:
          format: boolean
          type: boolean
        asset_number:
          format: character varying
          maxLength: 80
          type: string
        commissioning_date:
          format: date
          type: string
        created_at:
          format: timestamp with time zone
          type: string
        created_by_id:
          description: >-
            Note:

            This is a Foreign Key to `capex_invite_candidates.id`.<fk
            table='capex_invite_candidates' column='id'/>
          format: uuid
          type: string
        created_by_name:
          format: character varying
          maxLength: 200
          type: string
        created_source:
          format: text
          type: string
        criticality:
          format: character varying
          maxLength: 40
          type: string
        criticality_rank:
          format: smallint
          type: integer
        criticality_response_minutes:
          format: integer
          type: integer
        custodian:
          format: character varying
          type: string
        custodian_email:
          format: public.citext
          type: string
        custodian_user_id:
          description: >-
            Note:

            This is a Foreign Key to `capex_invite_candidates.id`.<fk
            table='capex_invite_candidates' column='id'/>
          format: uuid
          type: string
        custody_since:
          format: date
          type: string
        custom_fields:
          format: jsonb
        custom_text:
          format: text
          type: string
        health_score:
          format: numeric
          type: number
        id:
          description: |-
            Note:
            This is a Primary Key.<pk/>
          format: uuid
          type: string
        installation_date:
          format: date
          type: string
        is_retired:
          format: boolean
          type: boolean
        latitude:
          format: numeric
          type: number
        location_id:
          description: >-
            Note:

            This is a Foreign Key to `location_settings.id`.<fk
            table='location_settings' column='id'/>
          format: uuid
          type: string
        location_name:
          format: character varying
          maxLength: 200
          type: string
        longitude:
          format: numeric
          type: number
        manufacturer:
          format: character varying
          maxLength: 200
          type: string
        model_code:
          format: character varying
          maxLength: 80
          type: string
        model_name:
          format: character varying
          maxLength: 200
          type: string
        name:
          format: character varying
          maxLength: 250
          type: string
        parent_asset_id:
          description: >-
            Note:

            This is a Foreign Key to `asset_contracts.asset_id`.<fk
            table='asset_contracts' column='asset_id'/>
          format: uuid
          type: string
        parent_asset_number:
          format: character varying
          maxLength: 80
          type: string
        primary_image_file_id:
          format: uuid
          type: string
        purchase_date:
          format: date
          type: string
        row_version:
          format: bigint
          type: integer
        search_all:
          format: text
          type: string
        search_text:
          format: text
          type: string
        serial_number:
          format: character varying
          maxLength: 120
          type: string
        site_code:
          format: character varying
          maxLength: 50
          type: string
        site_id:
          description: >-
            Note:

            This is a Foreign Key to `entry_currencies.for_site_id`.<fk
            table='entry_currencies' column='for_site_id'/>
          format: uuid
          type: string
        site_name:
          format: character varying
          maxLength: 200
          type: string
        status:
          format: character varying
          maxLength: 60
          type: string
        status_category:
          format: character varying
          maxLength: 20
          type: string
        status_label:
          format: text
          type: string
        updated_at:
          format: timestamp with time zone
          type: string
        updated_by_id:
          description: >-
            Note:

            This is a Foreign Key to `capex_invite_candidates.id`.<fk
            table='capex_invite_candidates' column='id'/>
          format: uuid
          type: string
        updated_by_name:
          format: character varying
          maxLength: 200
          type: string
        warranty_expires_on:
          format: date
          type: string
      type: object

````