Top-level order records returned by /orders. Source: reporting_db
| Parameter | Type(s) | Example |
|---|---|---|
| allocations | list | [{"alloc_id": 4907, "confirmed": false, "driver": {"company_email": "brownlee1989@outlook.com", "company_phone": "+44 7342 232479", "driv... |
| booking_company_name | str | |
| booking_contact_name | str | Batsheva Rosenblatt |
| booking_contact_phone | str | |
| booking_value | float, int | 920 |
| cargo_golf_clubs_count | int | 24 |
| cargo_hand_luggage_count | int | 10 |
| cargo_passengers_count | int | 12 |
| cargo_suitcase_count | int | 12 |
| company | str | |
| contacts | list | [{"billing_contact": false, "contact_id": 1537, "contact_phone": "Contact Via WhatsApp", "customer_id": 9265, "email": "", "firstname": "... |
| created_at | str | 2025-04-10T09:28:00+00:00 |
| customer | dict, list | {"company_name": "", "contacts": [], "customer_email": "batsheva@luxetrailagency.com", "customer_id": 9265, "customer_name": "Batsheva Ro... |
| customer_name | str | Batsheva Rosenblatt |
| first_travel_date | NoneType, str | 2025-09-08T17:30:00+00:00 |
| invoices | list | [{"consolidated": false, "created_at": "2025-04-16T07:19:30+00:00", "currency": "GBP", "customer": {"company_name": "", "contacts": [], "... |
| on_account | bool | False |
| order_balance | float, int | 0 |
| order_cancelled_date | NoneType, str | 2000-01-01T00:00:00+00:00 |
| order_completed_date | NoneType, str | 2018-04-27T13:10:35+00:00 |
| order_confirmed_date | NoneType, str | 2025-04-28T23:11:16+00:00 |
| order_id | int | 14226 |
| order_paid | float, int | 920 |
| order_priced_date | NoneType, str | 2025-04-10T10:31:41+00:00 |
| order_reserved_date | NoneType, str | 2025-04-16T07:19:30+00:00 |
| order_status | str | confirmed |
| order_value | float, int | 920 |
| payment_status | str | paid |
| phone | str | |
| price | float, int | 920 |
| purchase_order | str | |
| salesperson_id | NoneType, int | 6 |
| salesperson_name | NoneType, str | Gemma Anderson Black |
| staff_id | NoneType, int | 6 |
| staff_name | NoneType, str | Gemma Anderson Black |
| status | str | confirmed |
| transport_status | str | none |
| transports | list | [{"allocations": [{"alloc_id": 4916, "confirmed": true, "driver": {"company_email": "email@jharrison.co.uk", "company_phone": "0788758545... |
| updated_at | str | 2025-08-31T17:10:42+00:00 |
| web_keyword | str | |
| web_page | str | |
| web_referrer | str | |