Get 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.