Get sales for a year

{
  orders(
    status: { equals: [succeeded] }
    closedOn: { range: [1767225599999, 1798761600000] }
  ) {
    id
    status
    closedOn
    amountNetCharge
    student {
      fullName
      email
    }
    offerSnapshot {
      name
    }
  }
}

{
  "data": {
    "orders": [
      {
        "id": "55555555-5555-4555-8555-555555555555",
        "status": "succeeded",
        "closedOn": 1790841600000,
        "amountNetCharge": 49.0,
        "student": {
          "fullName": "Jamie Smith",
          "email": "student@example.com"
        },
        "offerSnapshot": {
          "name": "Drawing Essentials"
        }
      }
    ]
  }
}

{
  orders(
    status: { equals: [succeeded] }
    closedOn: { range: [1767225599999, 1798761600000] }
  ) {
    id
    status
    closedOn
    amountNetCharge
    student {
      fullName
      email
    }
    offerSnapshot {
      name
    }
  }
}

{
  "data": {
    "orders": [
      {
        "id": "55555555-5555-4555-8555-555555555555",
        "status": "succeeded",
        "closedOn": 1790841600000,
        "amountNetCharge": 49.0,
        "student": {
          "fullName": "Jamie Smith",
          "email": "student@example.com"
        },
        "offerSnapshot": {
          "name": "Drawing Essentials"
        }
      }
    ]
  }
}

This example lists Orders currently marked succeeded with a positive amountNetCharge, completed during 2026. It excludes free acquisitions and Orders currently marked refunded or disputed. The example year runs from January 1, 2026 at 00:00 UTC (1767225600000) to January 1, 2027 at 00:00 UTC (1798761600000). Replace these timestamps to use another year or timezone. The query’s lower bound is one millisecond earlier because the API’s date bounds are strict.

{
  orders(
    status: { equals: [succeeded] }
    closedOn: { range: [1767225599999, 1798761600000] }
  ) {
    id
    status
    closedOn
    amountNetCharge
    student {
      fullName
      email
    }
    offerSnapshot {
      name
    }
  }
}

{
  "data": {
    "orders": [
      {
        "id": "55555555-5555-4555-8555-555555555555",
        "status": "succeeded",
        "closedOn": 1790841600000,
        "amountNetCharge": 49.0,
        "student": {
          "fullName": "Jamie Smith",
          "email": "student@example.com"
        },
        "offerSnapshot": {
          "name": "Drawing Essentials"
        }
      }
    ]
  }
}

Use the result

The date filter also matches Orders created during the interval. Keep only Orders with a closedOn inside the year and a positive amountNetCharge:

const sales = response.data.orders.filter(order =>
  order.closedOn !== null &&
  order.closedOn >= 1767225600000 &&
  order.closedOn < 1798761600000 &&
  order.amountNetCharge > 0
);

There is no pagination limit, so the list is not capped. Use a response without errors. For a large list, request shorter periods and apply the same completion-date check to each period. student can be null, so allow for a missing customer when building your report. The result contains sales recorded in Creatora, including manually registered Orders; it is not a payment-provider reconciliation. Orders Reference

Get started

Recipes

Reference

API guides

Queries

Mutations

Get sales for a year

Use the result

​Use the result

Use the result