See which high-value BigCommerce customers have open cases

**Objective:** Find BigCommerce customers with orders of at least `{min-order-total}` (default 500) since `{since-date}` (default 90 days ago) who currently have open cases in Dynamics 365.

**Step 1: Find large orders**

Call `bigcommerce-get-order` (BigCommerce server) with `total-including-tax.min` set to `{min-order-total}`, `date-created.from` set to `{since-date}` and `max-records` 50. Group by `billing-email` and total the spend per customer.

**Step 2: Find open cases**

For each customer, call `dynamics-365-sales-get-contacts` (Dynamics 365 server) with `email` set to the billing email to get the customer name, then call `dynamics-365-sales-get-incidents` with `customer` set to that name and `status` set to active. Skip customers with no CRM contact and list them separately.

**Step 3: Report**

Customers with at least one open case, ranked by spend: email, total spend, order count, open case count, highest priority and oldest case title. Then a short list of high spenders not found in the CRM.

**Rules & Guidelines:**

* `bigcommerce-get-order` is on the BigCommerce server; the Dynamics 365 Sales tools (names beginning dynamics-365-sales-) are on the Dynamics 365 Sales server.
* Read only. Do not call `dynamics-365-sales-create-case`, `dynamics-365-sales-update-case` or any write tool.

**Validation:**

* If no orders qualify, say so and stop.
* If `status` is not accepted as active, list cases without the filter and keep only those not resolved.