# DiscountCodeOrderSeries

> Daily order count and revenue series for one discount code. Read access, discounts toolset, MCP tool get_discount_code_order_series.

**Access:** [Read](https://developer.missin.co.uk/get-started/authentication.md#access-levels)

## Variables

| Variable | Type | Required | Accepts | Description |
|---|---|---|---|---|
| `filter` | `OrderFilter` | no | [OrderFilter](https://developer.missin.co.uk/reference/input-types.md#orderfilter) |  |
| `id` | `UUID!` | yes |  |  |
| `reportedFilter` | `OrderReportedFilter!` | yes | Input object, below |  |

## Input types

A filter lists its fields by the type they take, and none of them is required.

### OrderReportedFilter

- `[OrderReportedFilter!]`: `and`, `or`
- [StringFilter](https://developer.missin.co.uk/reference/input-types.md#stringfilter): `bestTier`, `nativeCurrency`, `rateProvider`, `reportingCurrency`
- [BooleanFilter](https://developer.missin.co.uk/reference/input-types.md#booleanfilter): `converted`
- [BigFloatFilter](https://developer.missin.co.uk/reference/input-types.md#bigfloatfilter): `nativeAttributedRevenue`, `nativeTotalPrice`, `rate`, `reportedAttributedRevenue`, `reportedTotalPrice`
- `OrderReportedFilter`: `not`
- [UUIDFilter](https://developer.missin.co.uk/reference/input-types.md#uuidfilter): `orderId`, `workspaceId`
- [DateFilter](https://developer.missin.co.uk/reference/input-types.md#datefilter): `placedDay`

## Call it

```bash curl
curl https://api.missin.co.uk/graphql/v1 \
  -H "Authorization: Bearer $MISSIN_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"operationName":"DiscountCodeOrderSeries","variables":{"id":"00000000-0000-0000-0000-000000000000","reportedFilter":{"and":[]}},"extensions":{"persistedQuery":{"version":1,"sha256Hash":"6f505ba4f8f0de57b87532bb2bcd26dca10be0cf7a95ad1f1afb62a6c4530568"}}}'
```

## Document

```graphql
query DiscountCodeOrderSeries($filter: OrderFilter, $id: UUID!, $reportedFilter: OrderReportedFilter!) { __typename fxRates: allFxRates(first: 1, orderBy: [RATE_DATE_DESC]) { __typename nodes { __typename rateDate } } gmv: allOrderReporteds(filter: $reportedFilter) { __typename aggregates { __typename sum { __typename reportedTotalPrice } } groupedAggregates(groupBy: [CONVERTED, NATIVE_CURRENCY, REPORTING_CURRENCY]) { __typename distinctCount { __typename orderId } keys sum { __typename nativeTotalPrice } } days: groupedAggregates(groupBy: [PLACED_DAY]) { __typename keys sum { __typename reportedTotalPrice } } } discountCodeByRowId(rowId: $id) { __typename id ordersByDiscountCodeId(first: 1000, orderBy: [PLACED_AT_ASC], filter: $filter) { __typename groupedAggregates(groupBy: [PLACED_DAY]) { __typename distinctCount { __typename rowId } keys } perConnection: groupedAggregates(groupBy: [CONNECTION_ID]) { __typename distinctCount { __typename rowId } keys } nodes { __typename currencyByCurrencyId { __typename code decimalPlaces decimalSeparator id symbol symbolPosition thousandsSeparator } id orderReportedByOrderId { __typename converted id nativeCurrency nativeTotalPrice placedDay rate rateDate rateProvider reportedTotalPrice reportingCurrency } placedAt totalPrice } totalCount } } }
```

Source: https://developer.missin.co.uk/reference/discounts/discount-code-order-series