# fittings Column Profile

> fittings Column Profile is a paid API for AI agents from fittings.sh, paid per call via x402, $0.005/call, status unknown (last checked 2026-09-14).

Computes a per-column statistical profile (null rate, cardinality, inferred type, numeric range, mean, std dev, top values) for a CSV or NDJSON dataset.

## Facts

- Endpoint: POST https://fittings.sh/v1/data/column-profile
- Price: $0.005/call
- Payment: x402
- Status: unknown
- Last checked: 2026-09-14
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/fittings-column-profile-0bc3167d
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_47b9dlGa41tg48KQk7SNe

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability fittings-column-profile-0bc3167d -d '<json body>'
```

Example prompt: Can you profile all the columns in this CSV for me — I need to know the null rate, cardinality, data types, numeric ranges, and the top most-frequent values for each field?

## When to prefer this

Choose this endpoint when you need a fast, comprehensive statistical summary of a tabular dataset in CSV or NDJSON format without standing up a data warehouse or running pandas locally. It is ideal for data quality audits, pre-ingestion checks, exploratory analysis, and schema drift detection, especially when the dataset fits within the 5M-character / 100K-row limit.

## Known failure modes

- Payload exceeds 5,000,000 characters, 100,000 rows, 256 columns, or 1,000,000 cells — returns error
- Malformed CSV or NDJSON that cannot be parsed — returns parse error
- Unsupported format value other than 'csv' or 'ndjson' — returns validation error
- Delimiter is more than one character — returns validation error
- Empty dataset with no rows — may return empty or minimal profile
- Payment not included or insufficient — returns 402 Payment Required

## How this service works

Per-column profile of a CSV or NDJSON payload: null rate, cardinality, inferred type, numeric range, mean, standard deviation and most frequent values.

## Output

A per-column breakdown containing: inferred data type, null count and null rate, distinct value cardinality, numeric min/max range, mean, standard deviation, and a list of the most frequently occurring values — returned for every column in the submitted CSV or NDJSON payload.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "data": {
   "type": "string",
   "description": "CSV or NDJSON, up to 5000000 characters, 100000 rows, 256 columns and 1000000 cells"
  },
  "format": {
   "type": "string",
   "description": "'csv' (default) or 'ndjson'"
  },
  "delimiter": {
   "type": "string",
   "description": "CSV only. Single character, defaults to comma"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/fittings-column-profile-0bc3167d/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from fittings.sh](https://www.zero.xyz/host/fittings.sh/llms.txt)