import { Lapyme } from "lapyme";

const lapyme = new Lapyme({
  bearerAuth: process.env["LAPYME_API_KEY"] ?? "",
});

const report = await lapyme.reports.query({
  source: "sales",
  period: {
    startDate: "2026-01-01",
    endDate: "2026-03-31",
  },
  dimensions: ["product"],
  measures: ["total", "units", "count"],
  includeTotals: true,
});

{
  "request_id": "req_report_1",
  "data": {
    "rows": [
      {
        "id": "9c692e8b",
        "ids": [
          "9c692e8b-0f9a-4f7c-8b99-061a2eb188ae"
        ],
        "labels": [
          "Almohada Microfibra 80x50"
        ],
        "measures": {
          "total": 998300,
          "units": 12,
          "count": 8
        }
      },
      {
        "id": "3b4a1c2d",
        "ids": [
          "3b4a1c2d-1234-5678-abcd-ef1234567890"
        ],
        "labels": [
          "King size sheet"
        ],
        "measures": {
          "total": 450000,
          "units": 5,
          "count": 4
        }
      }
    ],
    "totals": {
      "total": 1448300,
      "units": 17,
      "count": 12
    },
    "metadata": {
      "source": "sales",
      "dimensions": [
        "product"
      ],
      "measures": [
        "total",
        "units",
        "count"
      ],
      "period": {
        "start_date": "2026-01-01",
        "end_date": "2026-03-31"
      },
      "date_basis": "commercial"
    }
  }
}