---
title: "Get Orders"
method: GET
path: "/crm/orders"
tags: ["CRM Service Calls"]
---

# Get Orders

`GET /crm/orders`

Retrieve orders with optional filtering, sorting, pagination, and date range.

Returns orders matching your criteria. Without `start_date`/`end_date`, returns all
matching orders sorted newest first.

**Time-based filtering (start_date / end_date):**

Use `start_date` and `end_date` to filter orders by creation date.
Both accept **ISO 8601 UTC** strings.

- Format: `YYYY-MM-DDTHH:MM:SSZ` (full) or `YYYY-MM-DD` (date only = midnight UTC)
- Both are optional — provide one or both.
- **Do NOT pass date/timestamp fields inside `match_filter_dict`** — use these parameters instead.

**Example requests:**

- All orders (no date filter):
  `GET /orders`
- Orders created in the last 7 days:
  `GET /orders?start_date=2026-03-22T00:00:00Z&end_date=2026-03-29T23:59:59Z`
- Approved orders created this month:
  `GET /orders?start_date=2026-03-01&match_filter_dict={"stage": "approved"}`

**Other Query Parameters:**

- **match_filter_dict** *(optional)*: JSON-encoded MongoDB query for non-date fields.
  Filterable fields: `stage`, `order_type`, `total_amount`, `order_date`,
  `account_id`, `contact_id`.
- **sort_dict** *(default: {"_id": -1})*: JSON-encoded sort criteria.
- **page_size** *(default: 50, max: 500)*: Number of records per page.

**Response:** Array of order objects with id, name, stage, order_num, order_type,
total_amount, order_date, timestamps, account, contact, and opportunity references.

## Query parameters

- `match_filter_dict` string
- `sort_dict` string
- `page_size` integer
- `start_date` string, nullable — Start of date range in ISO 8601 format (e.g. 2026-03-22T00:00:00Z or 2026-03-22). UTC.
- `end_date` string, nullable — End of date range in ISO 8601 format (e.g. 2026-03-29T23:59:59Z or 2026-03-29). UTC.

## Response `200`

Successful Response

- OrderResponse[]
  - `id` string, required
  - `name` string, nullable
  - `stage` string, nullable
  - `description` string, nullable
  - `order_num` string, nullable
  - `order_type` string, nullable
  - `order_date` string, nullable
  - `total_amount` string, nullable
  - `agreement_signed_date` string, nullable
  - `created_ts` string, nullable
  - `created_ts_date` string, nullable
  - `updated_ts` string, nullable
  - `updated_ts_date` string, nullable
  - `account` string, nullable
  - `primary_sales_agent_email` string, nullable
  - `contact` string, nullable
  - `opportunity` string, nullable

## Other responses

- `422` — Validation Error

---

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