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

# List attendance records

> Scoped to company_id; the handler does not restrict this read to the session school assignments. Provide date_from AND date_to, or a positive last_n_days; mixing them returns 400. Defaults min_hours to 2; records below that threshold are excluded. room_id/room_ids and student_id/student_ids are merged. Row responses are sparse Attendance objects and support fields and pagination; sort_by on rows returns 400. group_by plus metrics selects nested AttendanceAggregate rows with a limit instead of pagination. Room/student filter counts, when positive, are returned in headers.



## OpenAPI

````yaml /openapi.yaml get /attendances
openapi: 3.1.0
info:
  title: Primula Tracker API V3
  version: 3.0.0
  description: >-
    Reference for the 66 operations registered under `/primula/api/v3` in the V3
    release baseline.


    ## Authentication

    Create a session with `POST /sessions`, then send `Authorization: Bearer
    <access_token>` on protected operations. Tokens must remain associated with
    a valid server-side session. The returned refresh token has no refresh
    endpoint in V3. Session company and school restrictions are documented per
    operation; company_id is not inferred from the token.


    ## Responses and errors

    Collections generally return bare JSON arrays and items return bare JSON
    objects. Report objects, nested maps, and update summaries are explicitly
    described below. List metadata travels in response headers rather than an
    envelope. Empty lists written by collection helpers are `[]`; fields backed
    by nullable values may be `null`, and omitted properties are distinguished
    from null properties in schemas. Handlers generally return `{ "error":
    "message" }`; authentication middleware and activity proxy errors use plain
    text. Unsupported methods on a registered path return 405 with Allow after
    any applicable authentication checks.


    ## Pagination and projections

    Only operations documenting page/per_page support pagination. Defaults are
    page=1 and per_page=100. Values exceeding the documented effective cap are
    clamped, not rejected. X-Total-Count describes the full matching set. Link
    contains applicable navigation links and is omitted for a single page.
    Aggregates use limit (default 50, effective cap 200) instead of pagination
    and send X-Truncated only when rows were omitted. The fields parameter,
    where available, selects the exact response properties; unsupported fields
    return 400.


    ## Query encoding

    Multi-value parameters documented as arrays accept repeated keys or
    comma-separated values. Prefer repeated keys for long UUID lists. Except for
    the two activity proxy operations, query parsing drops the entire query
    string above 8192 bytes and truncates each decoded query value to 128 bytes.
    Parameter combinations and interpretation differ by resource and
    representation; consult each operation. Unknown parameters are rejected only
    where explicitly documented.


    ## Dates and writes

    Calendar dates use YYYY-MM-DD, monthly periods use YYYY-MM, and timestamp
    formats are described in the corresponding schema. Defaults such as today
    depend on the server clock. PATCH operations change only the documented
    properties and reject unknown body properties. Clearing values,
    authorization, and partial-write behavior vary by resource and are described
    per operation.


    Examples use synthetic identifiers and placeholder tokens. Replace the
    server host before using an interactive API client.
servers:
  - url: https://{host}/primula/api/v3
    description: V3 API deployment. Replace the placeholder hostname.
    variables:
      host:
        default: api.example.com
security:
  - bearerAuth: []
tags:
  - name: sessions
    description: Sessions.
  - name: schools
    description: Schools.
  - name: companies
    description: Companies.
  - name: rooms
    description: Rooms.
  - name: users
    description: Users.
  - name: gusto_companies
    description: Gusto companies.
  - name: gusto_employees
    description: Gusto employees.
  - name: gusto_contractors
    description: Gusto contractors.
  - name: gusto_payrolls
    description: Gusto payrolls.
  - name: procare_staff
    description: Procare staff.
  - name: efficiency_ratios
    description: Efficiency ratios.
  - name: enrollment_tracker
    description: Enrollment tracker.
  - name: classroom_attendance
    description: Classroom attendance.
  - name: absences
    description: Absences.
  - name: billing_attendance_audits
    description: Billing attendance audits.
  - name: data_refresh
    description: Data refresh.
  - name: waitlist
    description: Waitlist.
  - name: sibling_discounts
    description: Sibling discounts.
  - name: new_start_tracker
    description: New start tracker.
  - name: withdrawal_tracker
    description: Withdrawal tracker.
  - name: transition_tracker
    description: Transition tracker.
  - name: enrollments
    description: Enrollments.
  - name: pre_registration_fallout
    description: Pre registration fallout.
  - name: procare_messages
    description: Procare messages.
  - name: activities_summary
    description: Activities summary.
  - name: activity_details
    description: Activity details.
  - name: leads
    description: Leads.
  - name: students
    description: Students.
  - name: payments
    description: Payments.
  - name: family_balances
    description: Family balances.
  - name: attendances
    description: Attendances.
  - name: billing_plans
    description: Billing plans.
  - name: spaces
    description: Spaces.
paths:
  /attendances:
    get:
      tags:
        - attendances
      summary: List attendance records
      description: >-
        Scoped to company_id; the handler does not restrict this read to the
        session school assignments. Provide date_from AND date_to, or a positive
        last_n_days; mixing them returns 400. Defaults min_hours to 2; records
        below that threshold are excluded. room_id/room_ids and
        student_id/student_ids are merged. Row responses are sparse Attendance
        objects and support fields and pagination; sort_by on rows returns 400.
        group_by plus metrics selects nested AttendanceAggregate rows with a
        limit instead of pagination. Room/student filter counts, when positive,
        are returned in headers.
      operationId: GetAttendancesV3
      parameters:
        - $ref: '#/components/parameters/CompanyId'
        - name: school_id
          in: query
          required: true
          description: School UUID.
          schema:
            type: string
            format: uuid
          example: 22222222-2222-4222-8222-222222222222
        - name: room_id
          in: query
          required: false
          description: >-
            Alias combined with room_ids. Accepts repeated query parameters or
            comma-separated values; empty entries are dropped and surrounding
            whitespace is trimmed.
          schema:
            type: array
            items:
              type: string
              format: uuid
          style: form
          explode: true
        - name: room_ids
          in: query
          required: false
          description: >-
            Optional room UUIDs; combined with room_id. Accepts repeated query
            parameters or comma-separated values; empty entries are dropped and
            surrounding whitespace is trimmed.
          schema:
            type: array
            items:
              type: string
              format: uuid
          style: form
          explode: true
        - name: student_id
          in: query
          required: false
          description: >-
            Alias combined with student_ids. Accepts repeated query parameters
            or comma-separated values; empty entries are dropped and surrounding
            whitespace is trimmed.
          schema:
            type: array
            items:
              type: string
              format: uuid
          style: form
          explode: true
        - name: student_ids
          in: query
          required: false
          description: >-
            Optional student UUIDs; combined with student_id. Accepts repeated
            query parameters or comma-separated values; empty entries are
            dropped and surrounding whitespace is trimmed.
          schema:
            type: array
            items:
              type: string
              format: uuid
          style: form
          explode: true
        - name: date_from
          in: query
          required: false
          description: >-
            Inclusive start date in YYYY-MM-DD. Both dates required unless
            last_n_days is supplied.
          schema:
            type: string
            format: date
          example: '2026-01-01'
        - name: date_to
          in: query
          required: false
          description: >-
            Inclusive end date in YYYY-MM-DD. Both dates required unless
            last_n_days is supplied.
          schema:
            type: string
            format: date
          example: '2026-01-31'
        - name: last_n_days
          in: query
          required: false
          description: >-
            Positive rolling-window length; cannot be combined with either
            explicit date bound.
          schema:
            type: integer
            minimum: 1
        - name: min_hours
          in: query
          required: false
          description: >-
            Minimum hours attended per record. Use zero to include records below
            the historical two-hour threshold.
          schema:
            type: number
            minimum: 0
            default: 2
        - name: fields
          in: query
          required: false
          description: >-
            Select response properties. Unknown names return 400. Default:
            student_id, date, room_id, room_name, hours_attended. Row view only.
            Accepts repeated query parameters or comma-separated values; empty
            entries are dropped and surrounding whitespace is trimmed.
          schema:
            type: array
            items:
              type: string
              enum:
                - attendance_id
                - student_id
                - date
                - room_id
                - room_name
                - hours_attended
                - sign_in_time
                - sign_out_time
          style: form
          explode: true
        - name: sort_by
          in: query
          required: false
          description: >-
            Aggregate view only; sending sort_by without group_by returns 400.
            Default group_asc.
          schema:
            type: string
            enum:
              - group_asc
              - group_desc
              - attendance_days_asc
              - attendance_days_desc
              - total_records_asc
              - total_records_desc
              - sum_hours_asc
              - sum_hours_desc
              - avg_hours_asc
              - avg_hours_desc
              - distinct_students_asc
              - distinct_students_desc
        - name: group_by
          in: query
          required: false
          description: Select an aggregate representation; metrics must also be supplied.
          schema:
            type: string
            enum:
              - student_id
              - room_id
              - room_name
              - date
              - month
        - name: metrics
          in: query
          required: false
          description: >-
            Metrics to calculate; required with group_by and invalid without it.
            Accepts repeated query parameters or comma-separated values; empty
            entries are dropped and surrounding whitespace is trimmed.
          schema:
            type: array
            items:
              type: string
              enum:
                - attendance_days
                - total_records
                - sum_hours
                - avg_hours
                - distinct_students
          style: form
          explode: true
        - name: limit
          in: query
          required: false
          description: >-
            Aggregate result limit. Defaults to 50 and clamps values above 200
            to 200. Zero and negative values use the default.
          schema:
            type: integer
            default: 50
        - name: page
          in: query
          required: false
          description: One-based page number. Row view only.
          schema:
            type: integer
            minimum: 1
            default: 1
          example: 1
        - name: per_page
          in: query
          required: false
          description: >-
            Items per page; values greater than 200 are clamped to 200. Row view
            only.
          schema:
            type: integer
            minimum: 1
            default: 100
          example: 100
      responses:
        '200':
          description: Successful response.
          content:
            application/json:
              schema:
                anyOf:
                  - type: array
                    items:
                      $ref: '#/components/schemas/Attendance'
                  - type: array
                    items:
                      $ref: '#/components/schemas/AttendanceAggregate'
              examples:
                rows:
                  summary: Default attendance fields
                  value:
                    - student_id: 33333333-3333-4333-8333-333333333333
                      date: '2026-01-15'
                      room_id: 55555555-5555-4555-8555-555555555555
                      room_name: Example classroom
                      hours_attended: 6
                aggregate:
                  summary: group_by=room_id&metrics=total_records,sum_hours
                  value:
                    - group:
                        room_id: 55555555-5555-4555-8555-555555555555
                      metrics:
                        total_records: 1
                        sum_hours: 6
          headers:
            X-Total-Count:
              $ref: '#/components/headers/TotalCount'
            Link:
              $ref: '#/components/headers/Link'
              description: Only for rows.
            X-Truncated:
              $ref: '#/components/headers/Truncated'
              description: Only for aggregates.
            X-Room-Filter-Count:
              $ref: '#/components/headers/RoomFilterCount'
            X-Student-Filter-Count:
              $ref: '#/components/headers/StudentFilterCount'
        '400':
          $ref: '#/components/responses/400'
        '401':
          $ref: '#/components/responses/401'
        '403':
          $ref: '#/components/responses/403'
        '405':
          $ref: '#/components/responses/405'
        '500':
          $ref: '#/components/responses/500'
components:
  parameters:
    CompanyId:
      name: company_id
      in: query
      required: true
      description: >-
        Company UUID. Must equal the authenticated session company when that
        session has a company assigned; the equality check is skipped for
        sessions without one.
      schema:
        type: string
        format: uuid
      example: 11111111-1111-4111-8111-111111111111
  schemas:
    Attendance:
      type: object
      description: >-
        A sparse row containing only the selected fields. Default fields:
        student_id, date, room_id, room_name, hours_attended.
      properties:
        attendance_id:
          type: string
          description: Attendance id.
        student_id:
          type: string
          description: Student id.
        date:
          type: string
          format: date
        room_id:
          type:
            - string
            - 'null'
        room_name:
          type: string
        hours_attended:
          type: number
        sign_in_time:
          type: string
          description: >-
            Local display time in h:mm AM/PM format, or an empty string when
            unavailable.
          examples:
            - 9:15 AM
            - ''
        sign_out_time:
          type: string
          description: >-
            Local display time in h:mm AM/PM format, or an empty string when
            unavailable.
          examples:
            - 9:15 AM
            - ''
      additionalProperties: false
    AttendanceAggregate:
      type: object
      properties:
        group:
          type: object
          properties:
            student_id:
              type: string
              description: >-
                Grouping value; missing data may be represented by an empty or
                unknown label.
            room_id:
              type: string
              description: >-
                Grouping value; missing data may be represented by an empty or
                unknown label.
            room_name:
              type: string
              description: >-
                Grouping value; missing data may be represented by an empty or
                unknown label.
            date:
              type: string
              description: >-
                Grouping value; missing data may be represented by an empty or
                unknown label.
            month:
              type: string
              description: >-
                Grouping value; missing data may be represented by an empty or
                unknown label.
          additionalProperties: false
        metrics:
          type: object
          properties:
            attendance_days:
              type: integer
            total_records:
              type: integer
            sum_hours:
              type: number
            avg_hours:
              type: number
            distinct_students:
              type: integer
          additionalProperties: false
      required:
        - group
        - metrics
      additionalProperties: false
      description: >-
        Contains the selected grouping key and requested metrics only. Grouping
        keys are nested under group; metric values are nested under metrics.
    Error:
      type: object
      properties:
        error:
          type: string
          description: Human-readable error message.
      required:
        - error
      description: Error.
  headers:
    TotalCount:
      description: >-
        Total matching rows before pagination, or matching groups before the
        aggregate limit. For unpaginated arrays, the number of returned rows.
      schema:
        type: integer
        minimum: 0
      example: 125
    Link:
      description: >-
        Pagination links using rel="next", "last", "prev", and "first". Only
        applicable links are sent; absent when all results fit on one page.
        Links preserve the original query parameters.
      schema:
        type: string
      example: >-
        </primula/api/v3/students?company_id=11111111-1111-4111-8111-111111111111&page=2>;
        rel="next"
    Truncated:
      description: Present with value true only when an aggregate result exceeds its limit.
      schema:
        type: boolean
      example: true
    RoomFilterCount:
      description: Number of room IDs in the resolved filter; omitted when zero.
      schema:
        type: integer
        minimum: 1
    StudentFilterCount:
      description: Number of student IDs in the resolved filter; omitted when zero.
      schema:
        type: integer
        minimum: 1
  responses:
    '400':
      description: Invalid or missing parameters or request body.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
          example:
            error: Invalid or missing parameters or request body.
    '401':
      description: >-
        Missing or invalid Bearer token, or an absent, invalid or expired
        server-side session. The authentication middleware returns plain text
        with a trailing newline.
      content:
        text/plain:
          schema:
            type: string
          examples:
            missing:
              value: |
                missing authorization header
            invalid:
              value: |
                Unauthorized
            expired:
              value: |
                Session expired
    '403':
      description: The authenticated session is not allowed to perform this operation.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
          example:
            error: >-
              The authenticated session is not allowed to perform this
              operation.
    '405':
      description: The path exists but does not support this HTTP method.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
          example:
            error: The path exists but does not support this HTTP method.
      headers:
        Allow:
          description: Comma-separated HTTP methods accepted by this path.
          schema:
            type: string
    '500':
      description: The operation could not be completed.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
          example:
            error: The operation could not be completed.
  securitySchemes:
    bearerAuth:
      type: http
      scheme: bearer
      bearerFormat: JWT
      description: >-
        Access token issued by POST /sessions and associated with a valid
        server-side session.

````

This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.