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

# List order report rows



## OpenAPI

````yaml /openapi.yaml get /v2/reports/orders
openapi: 3.1.2
info:
  title: Bahn Customer API
  version: 2.0.0-draft
  summary: Create and follow vehicle transport orders.
  description: |
    Create vehicle transport orders and read their current state.
  contact:
    name: Bahn API support
    email: support@bahnexpress.com
  license:
    name: Proprietary
    identifier: LicenseRef-Proprietary
servers:
  - url: https://sandbox.api.bahnexpress.fi
    description: Customer sandbox
  - url: https://api.bahnexpress.fi
    description: Production
security:
  - oauth2:
      - orders:read
      - orders:write
tags:
  - name: Authentication
    description: Create an access token for the selected environment.
  - name: Prices
    description: Check the current price for a route.
  - name: Orders
    description: Create, read, change, and cancel orders.
  - name: Files
    description: Upload and read order files.
  - name: Inspections
    description: Get vehicle inspection reports.
  - name: Tracking
    description: Get the current location for each order item.
  - name: Reports
    description: Get order report rows.
  - name: Sandbox
    description: Apply deterministic scenarios in the customer sandbox.
  - name: Webhooks
    description: Receive order change events from Bahn.
paths:
  /v2/reports/orders:
    get:
      tags:
        - Reports
      summary: List order report rows
      operationId: listOrderReportRows
      parameters:
        - $ref: '#/components/parameters/RequestId'
        - $ref: '#/components/parameters/Cursor'
        - $ref: '#/components/parameters/PageSize'
        - name: created_from
          in: query
          description: Include orders created at or after this RFC 3339 timestamp.
          schema:
            type: string
            format: date-time
        - name: created_to
          in: query
          description: Include orders created at or before this RFC 3339 timestamp.
          schema:
            type: string
            format: date-time
      responses:
        '200':
          description: The report page.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/OrderReportPage'
              example:
                data:
                  - order_id: ord_01k1a2b3c4d5e6f7g8h9j0k1m2
                    ordered_for: null
                    customer_reference: PO-2026-1042
                    created_at: '2026-07-30T13:00:00Z'
                    status: delivered
                    primary_vin: WBA00000000000001
                    primary_registration_number: ABC-123
                    origin_country: FI
                    destination_country: FI
                    pickup_address: Teollisuuskatu 1, 00510 Helsinki, Finland
                    delivery_address: Hatanpään valtatie 24, 33100 Tampere, Finland
                    pickup_type: dealership
                    delivery_type: dealership
                    ordered_by:
                      name: API service account
                      email: api@example.com
                    available_for_pickup_at: '2026-08-03T08:00:00+03:00'
                    picked_up_at: '2026-08-03T08:40:00+03:00'
                    delivered_at: '2026-08-03T13:18:00+03:00'
                    distance_meters: 181200
                    driver_time_minutes: 144
                    total_transport_minutes: 278
                    cost:
                      currency: EUR
                      total_cents: 45900
                    refuel:
                      occurred: true
                      cost_cents: 6200
                next_cursor: null
                has_more: false
        '400':
          $ref: '#/components/responses/BadRequest'
        '401':
          $ref: '#/components/responses/Unauthorized'
        '403':
          $ref: '#/components/responses/Forbidden'
        '500':
          $ref: '#/components/responses/ServerError'
        '503':
          $ref: '#/components/responses/ServerError'
      security:
        - oauth2:
            - reports:read
components:
  parameters:
    RequestId:
      name: X-Request-Id
      in: header
      required: false
      description: A caller-supplied request identifier for support.
      schema:
        type: string
        minLength: 1
        maxLength: 255
    Cursor:
      name: cursor
      in: query
      description: The opaque cursor from the previous response.
      schema:
        type: string
    PageSize:
      name: page_size
      in: query
      description: The number of resources to return.
      schema:
        type: integer
        minimum: 1
        maximum: 100
        default: 50
  schemas:
    OrderReportPage:
      description: Cursor-paginated page of flat report rows.
      type: object
      additionalProperties: false
      required:
        - data
        - next_cursor
        - has_more
      properties:
        data:
          type: array
          description: Report rows in this page.
          items:
            $ref: '#/components/schemas/OrderReportRow'
        next_cursor:
          type:
            - string
            - 'null'
          description: Opaque cursor for the next page, or null after the final page.
        has_more:
          type: boolean
          description: Whether another report page is available.
    OrderReportRow:
      description: Flat order row for exports, reporting, and finance workflows.
      type: object
      additionalProperties: false
      required:
        - order_id
        - ordered_for
        - customer_reference
        - created_at
        - status
        - primary_vin
        - primary_registration_number
        - origin_country
        - destination_country
        - pickup_address
        - delivery_address
        - pickup_type
        - delivery_type
        - ordered_by
        - available_for_pickup_at
        - picked_up_at
        - delivered_at
        - distance_meters
        - driver_time_minutes
        - total_transport_minutes
        - cost
        - refuel
      properties:
        order_id:
          $ref: '#/components/schemas/OrderId'
          description: Stable Bahn order ID.
        ordered_for:
          $ref: '#/components/schemas/NullableOrderedFor'
          description: Represented business, or null for a direct customer order.
        customer_reference:
          type:
            - string
            - 'null'
          description: Customer reference supplied with the order.
        created_at:
          type: string
          format: date-time
          description: Time when Bahn accepted the order.
        status:
          $ref: '#/components/schemas/OrderStatus'
          description: Current overall order state.
        primary_vin:
          type:
            - string
            - 'null'
          description: Primary vehicle VIN, when available.
        primary_registration_number:
          type:
            - string
            - 'null'
          description: Primary vehicle registration number, when available.
        origin_country:
          type:
            - string
            - 'null'
          description: Pickup country as a two-letter ISO code, when available.
        destination_country:
          type:
            - string
            - 'null'
          description: Delivery country as a two-letter ISO code, when available.
        pickup_address:
          type:
            - string
            - 'null'
          description: Human-readable pickup address, when available.
        delivery_address:
          type:
            - string
            - 'null'
          description: Human-readable delivery address, when available.
        pickup_type:
          type: string
          description: Pickup handover type.
          enum:
            - dealership
            - private
        delivery_type:
          type: string
          description: Delivery handover type.
          enum:
            - dealership
            - end_customer
        ordered_by:
          $ref: '#/components/schemas/OrderedBy'
          description: Person or API credential that created the order.
        available_for_pickup_at:
          type:
            - string
            - 'null'
          format: date-time
          description: >-
            Earliest pickup availability supplied with the order, when
            available.
        picked_up_at:
          type:
            - string
            - 'null'
          format: date-time
          description: Actual primary-vehicle pickup time, when available.
        delivered_at:
          type:
            - string
            - 'null'
          format: date-time
          description: Actual primary-vehicle delivery time, when available.
        distance_meters:
          type:
            - integer
            - 'null'
          minimum: 0
          description: >-
            Sum of recorded driving distances for completed transport work, in
            meters.
        driver_time_minutes:
          type:
            - integer
            - 'null'
          minimum: 0
          description: >-
            Sum of recorded driving times for completed transport work, in
            minutes.
        total_transport_minutes:
          type:
            - integer
            - 'null'
          minimum: 0
          description: Minutes from actual primary pickup to actual primary delivery.
        cost:
          $ref: '#/components/schemas/ReportCost'
          description: Billed order cost, or null when unavailable.
        refuel:
          $ref: '#/components/schemas/RefuelReport'
          description: Approved fuel or charging expense summary.
    Problem:
      description: A machine-readable API error in RFC 9457 problem-details format.
      type: object
      additionalProperties: false
      required:
        - type
        - title
        - status
        - code
        - instance
        - request_id
      properties:
        type:
          type: string
          format: uri
          description: A stable URI for the problem type.
        title:
          type: string
          description: A short problem summary.
        status:
          type: integer
          minimum: 400
          maximum: 599
          description: The HTTP status code returned with this problem.
        code:
          $ref: '#/components/schemas/ProblemCode'
          description: Stable code for application logic and retry decisions.
        detail:
          type: string
          description: A human-readable explanation of this occurrence.
        instance:
          type: string
          description: The request path that produced the problem.
        request_id:
          type: string
          description: Request identifier to include when you contact Bahn support.
        errors:
          type: array
          description: >-
            Field-level validation errors, when the problem concerns request
            input.
          items:
            $ref: '#/components/schemas/FieldError'
    OrderId:
      type: string
      pattern: ^ord_[a-z0-9]+$
      description: Stable Bahn order identifier used in every order resource path.
    NullableOrderedFor:
      description: >-
        Represented business, or null when the order belongs to the direct API
        customer.
      oneOf:
        - $ref: '#/components/schemas/OrderedFor'
        - type: 'null'
    OrderStatus:
      type: string
      description: >
        Overall order state derived from all vehicles.

        accepted means no vehicle is in transit; in_transit means transport is
        underway;

        delivered means every required vehicle is delivered; cancelled means the
        order was cancelled.
      enum:
        - accepted
        - in_transit
        - delivered
        - cancelled
    OrderedBy:
      description: Person or API credential that created the order.
      type: object
      additionalProperties: false
      required:
        - name
        - email
      properties:
        name:
          type:
            - string
            - 'null'
          description: Credential name or person name, when available.
        email:
          type:
            - string
            - 'null'
          format: email
          description: Person email for portal orders, or null for API-credential orders.
    ReportCost:
      description: Billed order cost, or null when no cost is available.
      type:
        - object
        - 'null'
      additionalProperties: false
      required:
        - currency
        - total_cents
      properties:
        currency:
          const: EUR
          description: Currency of the report cost.
        total_cents:
          type: integer
          minimum: 0
          description: Billing price plus additional billing rows, in euro cents.
    RefuelReport:
      description: Approved fuel or charging cost for an intra-Finland transport.
      type: object
      additionalProperties: false
      required:
        - occurred
        - cost_cents
      properties:
        occurred:
          type: boolean
          description: Whether Bahn recorded an approved fuel or charging expense.
        cost_cents:
          type: integer
          minimum: 0
          description: Total approved fuel or charging cost in euro cents.
    ProblemCode:
      type: string
      description: A stable machine code for client decisions.
      enum:
        - validation_error
        - authentication_failed
        - permission_denied
        - resource_not_found
        - idempotency_conflict
        - revision_conflict
        - order_not_cancellable
        - order_not_updateable
        - business_rule_violation
        - ordered_for_required
        - ordered_for_not_allowed
        - ordered_for_customer_not_found
        - file_too_large
        - request_too_large
        - scenario_not_allowed
        - internal_error
    FieldError:
      description: One invalid request field.
      type: object
      additionalProperties: false
      required:
        - path
        - code
        - message
      properties:
        path:
          type: string
          description: Dot-separated path to the invalid field.
        code:
          type: string
          description: Stable validation code for this field error.
        message:
          type: string
          description: Human-readable reason why the field is invalid.
    OrderedFor:
      description: Business represented by a platform ordering channel.
      type: object
      additionalProperties: false
      required:
        - country_code
        - business_id
      properties:
        country_code:
          type: string
          pattern: ^[A-Z]{2}$
          description: The ISO 3166-1 alpha-2 country code of the Bahn customer.
        business_id:
          type: string
          minLength: 1
          maxLength: 100
          description: The official business ID of the Bahn customer.
  responses:
    BadRequest:
      description: The request syntax or shape is invalid.
      content:
        application/problem+json:
          schema:
            $ref: '#/components/schemas/Problem'
          example:
            type: https://api.bahnexpress.fi/problems/validation-error
            title: The request is invalid.
            status: 400
            code: validation_error
            detail: One or more fields are invalid.
            instance: /v2/orders
            request_id: req_01k1a2b3c4d5e6f7g8h9j0k1m2
            errors:
              - path: items.0.vin
                code: invalid_length
                message: The VIN must contain 17 characters.
    Unauthorized:
      description: Authentication failed.
      content:
        application/problem+json:
          schema:
            $ref: '#/components/schemas/Problem'
    Forbidden:
      description: The token lacks the required scope or customer access.
      content:
        application/problem+json:
          schema:
            $ref: '#/components/schemas/Problem'
    ServerError:
      description: Bahn could not complete the request.
      content:
        application/problem+json:
          schema:
            $ref: '#/components/schemas/Problem'
  securitySchemes:
    oauth2:
      type: oauth2
      description: OAuth 2.0 client credentials.
      flows:
        clientCredentials:
          tokenUrl: /oauth2/token
          scopes:
            orders:read: Read customer orders.
            orders:write: Check prices, upload files, and change customer orders.
            reports:read: Read customer order reports.
            test:write: Apply customer sandbox scenarios.

````