Hillwinds APIDocs
Core Concepts

Flat-File Mode

Add format=flat to any list or export endpoint to get spreadsheet-compatible responses.

bash
GET /v1/companies?states=CA&mode=full&format=flat&page_size=5

What changes

Data typeJSON modeFlat mode
String arrays["CIGNA", "BCBS"]"CIGNA; BCBS"
Object arrays[{ "name": "CIGNA", "premiums": 15M }]carrier_1_name: "CIGNA", carrier_1_premiums: "15000000"
Nested objects{ "high": 85 }confidence_distribution_high: "85"
Numbers18500000"18500000" (string)
Nullsnull"" (empty string)

Array expansion is capped at 5 items. If a company has 8 carriers, only the first 5 appear as numbered columns.

Example

json
{
  "id": "84629153",
  "company_name": "PACIFIC HEALTH SYSTEMS INC",
  "all_carriers": "BLUE SHIELD OF CALIFORNIA; UNITED HEALTHCARE; DELTA DENTAL",
  "carrier_1_name": "BLUE SHIELD OF CALIFORNIA",
  "carrier_1_participants": "5890",
  "carrier_1_premiums": "15200000",
  "carrier_2_name": "UNITED HEALTHCARE",
  "carrier_2_participants": "5890",
  "carrier_2_premiums": "1500000",
  "signals": "carrier_change; self_funded"
}

Clay integration

See the Clay Integration Guide for step-by-step setup.

PreviousResponse ModesNext Signals & Enrichments