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

# List materialized relational mirror rows for an edge table lineage

> Returns rows from the lineage's physical TSDB mirror table in a naturalized shape.
Each row has `device_id`, `materialized_at`, and a `data` object containing the
business columns only. Use the `columns` query parameter to project a subset of columns.




## OpenAPI

````yaml /api-reference/ilyama.v1.json get /projects/{project_id}/edge/lineages/{lineage_id}/mirror-rows
openapi: 3.1.0
info:
  description: >
    Generation-ready starter contract for ilyama's HTTP API.

    This is intentionally scoped to stable routes already mounted in
    services/apis

    so frontend clients can begin integrating against the rewrite immediately.
  title: ilyama Core API
  version: 0.1.0
servers:
  - url: /core/api/v1
security:
  - bearerAuth: []
tags:
  - name: Certificates (HTTP)
  - name: Device JITR
  - name: Device RPC
  - name: Devices
  - name: Edge replication
  - name: Fleets
  - name: Integrations
  - name: MDM
  - name: Notification Event Registry
  - name: Notifications
  - name: OTA
  - name: Observability & data
  - name: Organizations
  - name: Project settings
  - name: Projects
  - name: Projects — Email Templates
  - name: Projects — Notification Subscriptions
  - name: Projects — Status
  - name: System
  - name: Tickets & workflows
  - name: Webhooks
paths:
  /projects/{project_id}/edge/lineages/{lineage_id}/mirror-rows:
    get:
      tags:
        - Edge replication
      summary: List materialized relational mirror rows for an edge table lineage
      description: >
        Returns rows from the lineage's physical TSDB mirror table in a
        naturalized shape.

        Each row has `device_id`, `materialized_at`, and a `data` object
        containing the

        business columns only. Use the `columns` query parameter to project a
        subset of columns.
      operationId: listEdgeMirrorRowsForLineage
      parameters:
        - in: path
          name: project_id
          required: true
          schema:
            format: uuid
            type: string
        - in: path
          name: lineage_id
          required: true
          schema:
            format: uuid
            type: string
        - description: >-
            Comma-separated list of business column names to include in the
            `data` object. Omit to return all columns.
          in: query
          name: columns
          schema:
            example: temperature,pressure,humidity
            type: string
        - in: query
          name: page
          schema:
            type: integer
        - in: query
          name: limit
          schema:
            type: integer
      responses:
        '200':
          content:
            application/json:
              schema:
                allOf:
                  - $ref: '#/components/schemas/SuccessEnvelope'
                  - properties:
                      data:
                        properties:
                          columns:
                            description: >-
                              Present only when the `columns` query param was
                              supplied.
                            items:
                              type: string
                            type: array
                          mirror_table_name:
                            description: Physical TSDB table name the rows were read from.
                            type: string
                          rows:
                            items:
                              properties:
                                data:
                                  additionalProperties: true
                                  description: Business columns for this row.
                                  type: object
                                device_id:
                                  format: uuid
                                  type: string
                                materialized_at:
                                  description: >-
                                    Infrastructure timestamps for this mirror
                                    row.
                                  properties:
                                    created_at:
                                      description: When the row was first materialized.
                                      format: date-time
                                      type: string
                                    updated_at:
                                      description: When the row was last updated.
                                      format: date-time
                                      type: string
                                  type: object
                              type: object
                            type: array
                          source:
                            description: >-
                              Whether the rows come from a per-device or
                              coalesced mirror.
                            enum:
                              - mirror
                              - coalesced
                            type: string
                        type: object
                    type: object
          description: Mirror rows loaded
        '404':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorEnvelope'
          description: Lineage or mirror not found
        '503':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorEnvelope'
          description: TSDB unavailable
      security:
        - bearerAuth: []
          orgIdHeader: []
components:
  schemas:
    SuccessEnvelope:
      description: >
        Preferred shape for successful JSON responses is `{ ok, data, meta }`
        with list metadata

        (e.g. pagination totals) in top-level `meta`, not nested under `data`.
      properties:
        data:
          description: Response payload; may be null for no-content successes.
          nullable: true
        meta:
          description: Top-level metadata (e.g. pagination); null when unused.
          nullable: true
        ok:
          enum:
            - 1
          type: integer
      required:
        - ok
        - data
        - meta
      type: object
    ErrorEnvelope:
      properties:
        detail:
          type: string
        message:
          oneOf:
            - type: string
            - type: object
        ok:
          enum:
            - 0
          type: integer
      required:
        - ok
        - message
        - detail
      type: object
  securitySchemes:
    bearerAuth:
      bearerFormat: JWT
      scheme: bearer
      type: http
    orgIdHeader:
      in: header
      name: ORG-ID
      type: apiKey

````