Get Unique Values

curl -X POST "https://api.dcycle.io/v2/imports/YOUR_IMPORT_ID/unique-values" \
  -H "x-api-key: YOUR_API_KEY" \
  -H "x-organization-id: YOUR_ORGANIZATION_ID" \
  -H "Content-Type: application/json" \
  -d '{
    "mapping": {
      "facility": "Site",
      "waste_code": "LER"
    },
    "constant_values": {
      "treatment": "recycling"
    }
  }'

import requests

HEADERS = {
    "x-api-key": "YOUR_API_KEY",
    "x-organization-id": "YOUR_ORGANIZATION_ID",
}

data = requests.post(
    f"https://api.dcycle.io/v2/imports/{import_id}/unique-values",
    headers=HEADERS,
    json={
        "mapping": {"facility": "Site", "waste_code": "LER"},
        "constant_values": {"treatment": "recycling"},
    },
    timeout=60,
).json()

for column in data["columns"]:
    if column["truncated"]:
        print(f"{column['column_key']}: showing part of {column['total_unique']} values")

    # `resolved` is ABSENT when nothing matched — never assume the key exists
    needs_user = [v for v in column["values"] if v.get("resolved") is None]
    print(f"{column['column_key']}: {len(needs_user)} values need a decision")

const response = await fetch(
  `https://api.dcycle.io/v2/imports/${importId}/unique-values`,
  {
    method: "POST",
    headers: {
      "x-api-key": "YOUR_API_KEY",
      "x-organization-id": "YOUR_ORGANIZATION_ID",
      "Content-Type": "application/json",
    },
    body: JSON.stringify({
      mapping: { facility: "Site", waste_code: "LER" },
      constant_values: { treatment: "recycling" },
    }),
  },
);
const data = await response.json();

for (const column of data.columns) {
  // `resolved` may be missing entirely, not null
  const needsUser = column.values.filter((v) => v.resolved === undefined);
  console.log(`${column.column_key}: ${needsUser.length} need a decision`);
}