# Mining Pool Metric Imports — Declared Column Projection

> Mining Pool Metric Imports — Declared Column Projection is a paid API for AI agents from market.datapackvibe.com, paid per call via x402, $0.01/call, status unknown (last checked 2026-10-15).

Validates a CSV of mining pool metrics against a declared column contract and projects allowed columns, supporting up to 1000 rows with quoted cells.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-bx-csv-pool-metrics-projection?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-15
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/mining-pool-metric-imports-declared-column-projection-0b180e96
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_FKDJ4d7_ey4nXgbii2-31

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 mining-pool-metric-imports-declared-column-projection-0b180e96 -d '<json body>'
```

Example prompt: Can you validate this mining pool metrics CSV against its declared columns — it has observation_id, observed_on, pool_id, hashrate_ths, and reported_reward_btc columns, uses a comma delimiter, and I want to allow group-a and group-b as valid pool categories, with numeric values between 0 and 1000000?

## When to prefer this

Choose this endpoint when you need to validate a mining pool metrics CSV against a declared column contract specifically, including hashrate and reward columns, with support for category allowlists and numeric range bounds. Prefer this over generic CSV validators when the domain is crypto mining pool data and you need a structured projection report rather than just syntax checking.

## Known failure modes

- CSV exceeds 1000 rows — only first 1000 rows processed or rejected
- CSV string exceeds 100,000 character limit — request rejected
- Numeric values outside specified minimum/maximum bounds — flagged as violations
- Category values not in allowed_categories list — flagged as invalid
- Malformed CSV with unclosed quotes — parse error returned
- Unsupported delimiter used — validation fails
- Cell length exceeding max_cell_length — flagged per cell

## How this service works

Mining pool metric imports — Declared column projection: Declared column projection for Mining pool metric imports. Validate a declared CSV table contract, up to 1000 rows. Quoted cells supported; no external enrichment. Specialised preset in a shared 50-profile, 20-operation engine. 0.01 USDC includes one CSV declared column projection report.

## Output

A declared column projection report indicating whether the CSV conforms to the declared column contract, including per-column validation status, flagged rows or cells that violate constraints (numeric range, allowed categories, cell length), and an overall pass/fail for the up-to-1000-row input.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "csv": {
   "type": "string",
   "default": "observation_id,observed_on,pool_id,hashrate_ths,reported_reward_btc\nrecord-a,2026-01-01,group-a,10,2\nrecord-b,2026-01-02,group-b,20,3",
   "maxLength": 100000,
   "minLength": 1
  },
  "maximum": {
   "type": "number",
   "default": 1000000000000,
   "maximum": 1000000000000,
   "minimum": -1000000000000
  },
  "minimum": {
   "type": "number",
   "default": -1000000000000,
   "maximum": 1000000000000,
   "minimum": -1000000000000
  },
  "delimiter": {
   "enum": [
    ",",
    ";",
    "\t"
   ],
   "type": "string",
   "default": ","
  },
  "max_cell_length": {
   "type": "integer",
   "default": 1000,
   "maximum": 5000,
   "minimum": 1
  },
  "allowed_categories": {
   "type": "array",
   "items": {
    "type": "string",
    "default": "",
    "maxLength": 100,
    "minLength": 1
   },
   "default": [
    "group-a",
    "group-b"
   ],
   "maxItems": 100,
   "minItems": 0
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/mining-pool-metric-imports-declared-column-projection-0b180e96/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from market.datapackvibe.com](https://www.zero.xyz/host/market.datapackvibe.com/llms.txt)