{
  "product_id": "550e8400-e29b-41d4-a716-446655440000",
  "product_name": "Industrial Compressor X200",
  "organization_id": "a8315ef3-dd50-43f8-b7ce-d839e68d51fa",
  "organization_name": "Acme Manufacturing"
}

{
  "id": "period-uuid-001",
  "start_date": "2024-01-01",
  "end_date": "2024-12-31"
}

{
  "items": [
    {
      "id": "sale-uuid-001",
      "quantity": 250.0,
      "unit": {
        "id": "unit-uuid",
        "name": "unit",
        "symbol": "u"
      },
      "location": {
        "country_code": "ES",
        "country_name": "Spain"
      }
    },
    {
      "id": "sale-uuid-002",
      "quantity": 180.0,
      "unit": {
        "id": "unit-uuid",
        "name": "unit",
        "symbol": "u"
      },
      "location": {
        "country_code": "DE",
        "country_name": "Germany"
      }
    }
  ],
  "total_quantity": 430.0,
  "file": null
}

{
  "items": [
    {
      "type": "use_phase",
      "status": "calculated",
      "quantity": 12500.0,
      "use_of_product_data_id": "use-data-uuid"
    },
    {
      "type": "end_of_life",
      "status": "calculated",
      "quantity": 350.0,
      "use_of_product_data_id": null
    }
  ]
}

import requests
import os

headers = {
    "x-api-key": os.environ["DCYCLE_API_KEY"],
    "x-organization-id": os.environ["DCYCLE_ORG_ID"],
}

# Get all sold products
products = requests.get(
    "https://api.dcycle.io/v1/sold-products/",
    headers=headers
).json()

for product in products["items"]:
    print(f"Product: {product['product_name']}")

    # Get periods for each product
    periods = requests.get(
        f"https://api.dcycle.io/v1/sold-products/{product['product_id']}/periods",
        headers=headers
    ).json()

    for period in periods["items"]:
        print(f"  Period: {period['start_date']} to {period['end_date']}")

# Check if data already exists for a product-country-period combination
existing = requests.get(
    "https://api.dcycle.io/v1/sold-products/existing-country-sales",
    headers=headers,
    params={
        "start_date": "2024-01-01",
        "end_date": "2024-12-31"
    }
).json()

for org_data in existing["items"]:
    for item in org_data["items"]:
        print(f"Existing: {item['product_name']} in {item['country_name']}")

emissions = requests.get(
    f"https://api.dcycle.io/v1/sold-products/{product_id}/periods/{period_id}/emissions",
    headers=headers
).json()

for emission in emissions["items"]:
    print(f"{emission['type']}: {emission['quantity']} kgCO2e ({emission['status']})")