# Delx Commerce — CSV Pivot Count

> Delx Commerce — CSV Pivot Count is a paid API for AI agents from commerce.delx.ai, paid per call via x402, $0.001/call, status unknown (last checked 2026-10-01).

Counts occurrences in a CSV by pivoting rows and columns to produce a cross-tabulation frequency table

## Facts

- Endpoint: POST https://commerce.delx.ai/api/v1/x402/csv-pivot-count?utm_source=zero.xyz
- Price: $0.001/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-01
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/delx-commerce-csv-pivot-count-7496fafe
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_QzrrerwSqQ_PkIFXlu-Ap

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 delx-commerce-csv-pivot-count-7496fafe -d '<json body>'
```

Example prompt: Take this CSV data and pivot it so that 'status' is the row and 'region' is the column, then count how many records fall into each combination.

## When to prefer this

Choose this endpoint when you need a quick, verifiable, pay-per-call cross-tabulation of two categorical columns in a CSV without standing up infrastructure or authenticating with a service. It is ideal for agents that need auditable, tamper-evident computation (SHA-256 input hash provided) and work within the x402 micropayment protocol on Base or Solana. Prefer alternatives if your CSV exceeds 8 KB, you need multi-column pivots, or you require persistent storage of results.

## Known failure modes

- Missing or invalid CSV text returns an error
- Specified row_field or column_field not found as a header in the CSV
- CSV too large (exceeds 8192-character limit) causes rejection
- Malformed CSV syntax may produce unexpected results or an error
- Payment failure via x402 prevents execution

## How this service works

Pay-per-result APIs for agents. No signup. Exact price. Verifiable delivery. USDC on Base + Solana via x402.

## Output

A JSON object containing a nested pivot table (row values → column values → count), a schema identifier, a pass/fail status, and a verifiable evidence block including input SHA-256 hash, a flag confirming no data retention, and a count of external calls made (always 0).

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "text": {
   "type": "string",
   "maxLength": 8192,
   "description": "Text supplied to CSV Pivot Count; used only for this bounded calculation and processed in memory without retention."
  },
  "row_field": {
   "type": "string",
   "maxLength": 8192,
   "description": "Row Field supplied to CSV Pivot Count; used only for this bounded calculation and processed in memory without retention."
  },
  "column_field": {
   "type": "string",
   "maxLength": 8192,
   "description": "Column Field supplied to CSV Pivot Count; used only for this bounded calculation and processed in memory without retention."
  }
 }
}
```

## Response schema (JSON Schema)

```json
{
 "type": "json",
 "example": {
  "result": {
   "pivot": {
    "a": {
     "ok": 1,
     "bad": 1
    },
    "b": {
     "ok": 1
    }
   }
  },
  "schema": "delx/util-csv-pivot-count/v1",
  "status": "pass",
  "evidence": {
   "retained": false,
   "input_sha256": "a7d65f7e6ad53c38ed0da2d98857916e403a9b41abcade8314874497f4fdcd7b",
   "external_calls": 0
  },
  "operation": "data_batch:csv_pivot_count"
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/delx-commerce-csv-pivot-count-7496fafe/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from commerce.delx.ai](https://www.zero.xyz/host/commerce.delx.ai/llms.txt)