API Documentation

Returns a paginated list of building products. Supports full-text search, filtering by category/manufacturer/performance specs, and sorting.

Query Parameters

Example Request

curl "https://substrata-34wm.polsia.app/v1/products?category=windows&energy_star=true&max_u_value=0.25&limit=3"

Response

{
  "data": [
    {
      "id": 6,
      "name": "Andersen E-Series Triple Pane Casement",
      "slug": "andersen-e-series-triple-casement",
      "manufacturer": "Andersen",
      "category": "windows",
      "subcategory": "casement",
      "description": "Premium architectural-grade casement...",
      "width_mm": 762,
      "height_mm": 1524,
      "u_value": "0.170",
      "shgc": "0.190",
      "vt": "0.330",
      "stc_rating": 37,
      "frame_material": "Wood/Aluminum",
      "glazing_type": "Triple Low-E",
      "price_min_usd": "1200.00",
      "price_max_usd": "2400.00",
      "warranty_years": 20,
      "energy_star": true,
      "certifications": ["ENERGY STAR","NFRC","AAMA","PHI"],
      "model_number": "AE-TC3060"
    }
  ],
  "pagination": {
    "page": 1,
    "limit": 3,
    "total": 7,
    "total_pages": 3,
    "has_next": true,
    "has_prev": false
  },
  "filters_applied": {
    "category": "windows",
    "energy_star": "true",
    "max_u_value": "0.25"
  }
}

Returns a single product by its URL slug. Returns 404 if not found.

Example

curl "https://substrata-34wm.polsia.app/v1/products/andersen-400-casement"

Response

{
  "data": {
    "id": 2,
    "name": "Andersen 400 Series Casement Window",
    "slug": "andersen-400-casement",
    "manufacturer": "Andersen",
    ...all product fields
  }
}

Returns all product categories with subcategories and product counts.

curl "https://substrata-34wm.polsia.app/v1/categories"

{
  "data": [
    {
      "category": "doors",
      "product_count": "16",
      "subcategories": ["entry","patio","multi-slide","garage","interior","folding"]
    },
    {
      "category": "insulation",
      "product_count": "18",
      "subcategories": ["fiberglass-batt","mineral-wool","rigid-board","blown-in","spray-foam",...]
    },
    {
      "category": "windows",
      "product_count": "19",
      "subcategories": ["double-hung","casement","awning","sliding","picture",...]
    }
  ]
}

Returns all manufacturers with product counts and which categories they produce.

curl "https://substrata-34wm.polsia.app/v1/manufacturers"

{
  "data": [
    {
      "manufacturer": "Andersen",
      "product_count": "4",
      "categories": ["windows","doors"]
    },
    {
      "manufacturer": "Owens Corning",
      "product_count": "3",
      "categories": ["insulation"]
    },
    ...
  ]
}

Returns aggregate statistics about the product database.

{
  "data": {
    "total_products": "53",
    "total_manufacturers": "35",
    "total_categories": "3",
    "energy_star_products": "26",
    "avg_u_value": "0.259",
    "avg_r_value": "13.40",
    "avg_price_min": "919.41",
    "avg_price_max": "2781.80"
  }
}