---
title: "Get Routes by id with Waypoints, Orders and order items"
method: GET
path: "/consolidated-routes"
tags: ["Consolidated Routes"]
---

# Get Routes by id with Waypoints, Orders and order items

`GET /consolidated-routes`

Get Routes by id with Waypoints, Orders and order items

## Query parameters

- `limit` integer
- `offset` integer
- `_id` string

## Response `200`

Get all Completed Routes

- object
  - `meta` object
    - `limit` integer — Number of rows retrieved
    - `offset` integer — Number of rows skipped
    - `total` integer — Total number of rows
  - `data` object[]
    - `code` string — Route code
    - `startDate` string, date-time — Route start date
    - `date` string, date — Route scheduled date
    - `status` 'overdue' | 'finished' | 'extended' | 'pending' | 'closed' | 'ongoing' — Route state
    - `deviceId` number — Route assigned vehicle
    - `totalAmount` number — Route total amount
    - `driverId` number — Route driver id
    - `companionId` number — Route companion id
    - `secondaryCode` string — Route secondary code
    - `warehouseDepartureDate` string, date-time — Warehouse departure date
    - `warehouseReturnDate` string, date-time — Warehouse return date
    - `carrier` string — Route carrier
    - `scheduledStartDate` string, date-time — Route scheduled date
    - `recalculatedAt` string, date-time — Route recalculated date
    - `optimized` boolean — Route is optimized
    - `assignedDeviceIMEI` number — Route assigned device IMEI
    - `routePrediction` object
      - `_id` integer
      - `routeId` integer
      - `estimatedReturnDate` string
      - `realReturnDate` string
      - `initialReturnDate` string
      - `estimatedDepartureDate` string
      - `estimatedKms` number
      - `executedKms` number
      - `optimizedOn` string
    - `waypoints` object[] — Route waypoints
      - `scheduledDate` string, date-time — Waypoint scheduled date
      - `poiId` number — Poi id processed on waypoint
      - `visited` boolean — Waypoint visited
      - `longitude` number — Waypoint visited exact location longitude
      - `latitude` number — Waypoint visited exact location latitude
      - `vehicleId` number — Waypoint vehicle assigned
      - `visitedAt` string, date-time — Waypoint visit date
      - `visitDuration` integer — Waypoint visit duration
      - `totalValue` number — Waypoint total amount
      - `pallets` number — Waypoint pallets
      - `createdAt` string, date-time — Waypoint created date
      - `departedAt` string, date-time — Waypoint departure date
      - `comments` string — Waypoint comments
      - `scheduledArrivalTimestamp` string, date-time — Waypoint scheduled visit arrival
      - `scheduledDepartureTimestamp` string, date-time — Waypoint scheduled visit departure
      - `visitOrder` integer — Waypoint visit order
      - `activities` object
        - `type` 'pickup' | 'task' | 'delivery' — Activity type
        - `orders` object[]
          - `_id` union — Order ID
            - integer
            - string
          - `weight` union — Weight
            - integer
            - string
          - `deliveredWeight` union — Delivered weight
            - integer
            - string
        - `tasks` object[]
          - `_id` union — Task ID
            - integer
            - string
      - `status` object
        - `_id` integer — id
        - `status` integer — Status
        - `description` string — Description
        - `code` number — Code
        - `subStatus` object — Sub Status model
          - `_id` integer — id
          - `description` string — Description
          - `code` number — Code
        - `photos` object[]
          - `_id` integer — id
          - `url` string — Photo name
          - `fullUrl` string — Photo URL
          - `comment` string — comment
          - `timestamp` string — comment
        - `certifiedAt` string — Certification timestamp made through the CDE App
        - `signature` object
          - `url` string — Image Name saved on storage
          - `fullUrl` string — Image link
          - `signatureName` string — Name of the signing person

## Other responses

- `403` — Not authorized access

---

[API](https://skmtc.net/quadminds/apis/quadminds-api-v2.md) · [All operations](https://skmtc.net/quadminds/apis/quadminds-api-v2/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/quadminds/quadminds-api-v2/versions/e0ab56dece05/schema)