Physical Stocks

query GetProductPhysicalStocks($start: DateTime!, $end: DateTime!, $organization: Guid, $warehouse: Guid, $product: Guid, $withBatch: Boolean) {
  documents {
    productPhysicalStocks(startDate: $start, endDate: $end, organizationKey: $organization, warehouseKey: $warehouse, productKey: $product, withBatch: $withBatch) {
      price
      batch
      startQuantity
      endQuantity
      product { key name code }
      warehouse { key name }
    }
  }
}

{
  "start": "2026-10-01T00:00:00",
  "end": "2026-10-31T23:59:59",
  "organization": "<organization key>",
  "warehouse": "<warehouse key>",
  "product": null,
  "withBatch": false
}

curl --location 'https://sandbox.expressoft.eu/connect/api/interopgql' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer <token>' \
--data '{"query": "query GetProductPhysicalStocks($start: DateTime!, $end: DateTime!, $organization: Guid, $warehouse: Guid, $product: Guid, $withBatch: Boolean) { documents { productPhysicalStocks(startDate: $start, endDate: $end, organizationKey: $organization, warehouseKey: $warehouse, productKey: $product, withBatch: $withBatch) { price batch startQuantity endQuantity product { key name code } warehouse { key name } } } }", "variables": {"start": "2026-10-01T00:00:00", "end": "2026-10-31T23:59:59", "organization": "<organization key>", "warehouse": "<warehouse key>", "product": null, "withBatch": false}}'

{
  "data": {
    "documents": {
      "productPhysicalStocks": [
        {
          "price": 10.0,
          "batch": null,
          "startQuantity": 100.0,
          "endQuantity": 85.0,
          "product": {
            "key": "00000000-0000-0000-0000-000000000003",
            "name": "Flour 1 kg",
            "code": "P001"
          },
          "warehouse": {
            "key": "00000000-0000-0000-0000-000000000004",
            "name": "Main warehouse"
          }
        }
      ]
    }
  }
}