# BRAINIAC CSV Data Quality Report

> BRAINIAC CSV Data Quality Report is a paid API for AI agents from www.brainiac.software, paid per call via x402, $0.12/call, status unknown (last checked 2026-11-17).

Analyzes a CSV, JSON, or record dataset for data quality issues—detecting duplicates, missing values, format inconsistencies, and normalizing values—returning a detailed report of changes, issues, and grouped duplicates.

## Facts

- Endpoint: POST https://www.brainiac.software/api/v1/data-quality/csv-report?utm_source=zero.xyz
- Price: $0.12/call
- Payment: x402
- Status: unknown
- Last checked: 2026-11-17
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/brainiac-csv-data-quality-report-a200e072
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_nEW5wOuf5hPngin86ve8a

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 brainiac-csv-data-quality-report-a200e072 -d '<json body>'
```

Example prompt: Can you run a data quality check on this CSV I'm about to upload and give me a full report of any duplicates, missing values, inconsistent formats, and any normalizations applied to things like emails or boolean fields?

## When to prefer this

Choose this endpoint when you need a detailed, row-level data quality audit of a tabular dataset—including normalization of emails, booleans, and whitespace, plus duplicate detection and missing-value flagging—delivered as a structured report. It is especially useful as a pre-import validation step or automated pipeline gate. Prefer it over generic LLM-based data review when you need precise row/column references, machine-readable issue codes, and reproducible normalization rules rather than a prose summary.

## Known failure modes

- Input exceeds size limits (CSV >200,000 chars or records >5,000 items) — request rejected
- Invalid or unparseable CSV/JSON input — parsing error returned
- Missing both 'csv', 'json', 'file', and 'records' fields — no input to process
- Unsupported media type in file upload — rejected by schema validation
- Payment not completed or insufficient USDC — 402 response, no result returned

## How this service works

Pay-per-call APIs for AI agents: OFAC sanctions screening, compliance checks, token security, and Base chain data via x402. No account. Fixed USDC price. MCP-ready.

## Output

Returns a JSON object with: a 'status' field ('checked'), a list of 'issues' (each with row, column, code, kind, value, and detail describing the problem), a list of 'changes' (each with row, column, original value, normalized value, and the normalization rule applied), and 'groups' of duplicate rows with counts and source row references.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "csv": {
   "type": "string",
   "maxLength": 200000
  },
  "file": {
   "type": "object",
   "required": [
    "mediaType",
    "fileBase64"
   ],
   "properties": {
    "filename": {
     "type": "string",
     "maxLength": 180,
     "minLength": 1
    },
    "mediaType": {
     "enum": [
      "text/csv",
      "application/json",
      "text/plain"
     ],
     "type": "string"
    },
    "fileBase64": {
     "type": "string",
     "maxLength": 12000000,
     "minLength": 1
    }
   },
   "additionalProperties": false
  },
  "json": {
   "type": "string",
   "maxLength": 200000
  },
  "records": {
   "type": "array",
   "items": {
    "type": "object",
    "propertyNames": {
     "type": "string",
     "maxLength": 80,
     "minLength": 1
    },
    "additionalProperties": {
     "anyOf": [
      {
       "type": "string",
       "maxLength": 4000
      },
      {
       "type": "number"
      },
      {
       "type": "boolean"
      },
      {
       "type": "null"
      }
     ]
    }
   },
   "maxItems": 5000
  },
  "keyColumns": {
   "type": "array",
   "items": {
    "type": "string",
    "maxLength": 80,
    "minLength": 1
   },
   "maxItems": 20
  }
 }
}
```

## Response schema (JSON Schema)

```json
{
 "type": "json",
 "example": {
  "format": "csv",
  "groups": [
   {
    "rows": [
     {
      "row": 2,
      "sourceRow": 3
     },
     {
      "row": 5,
      "sourceRow": 6
     }
    ],
    "count": 2
   }
  ],
  "issues": [
   {
    "row": 7,
    "code": "inconsistent_format",
    "kind": "conflict",
    "value": "not-an-email",
    "column": "email",
    "detail": "The most common type is email. This value was not changed.",
    "sourceRow": 8,
    "columnIndex": 2
   },
   {
    "row": 7,
    "code": "inconsistent_format",
    "kind": "conflict",
    "value": "03/11/2026",
    "column": "joined",
    "detail": "The most common type is date. This value was not changed.",
    "sourceRow": 8,
    "columnIndex": 5
   },
   {
    "row": 3,
    "code": "missing_value",
    "kind": "missing",
    "value": "",
    "column": "status",
    "detail": "This cell is empty or whitespace. The row was kept.",
    "sourceRow": 4,
    "columnIndex": 4
   },
   {
    "row": 5,
    "code": "duplicate_row",
    "kind": "conflict",
    "value": "",
    "column": "",
    "detail": "This record matches record 2 after trimming the compared cells. No record was removed.",
    "sourceRow": 6,
    "columnIndex": 0
   }
  ],
  "status": "checked",
  "changes": [
   {
    "row": 1,
    "rule": "email_lower",
    "column": "email",
    "original": "Ada@Example.com",
    "sourceRow": 2,
    "normalized": "ada@example.com",
    "columnIndex": 2
   },
   {
    "row": 1,
    "rule": "boolean_token",
    "column": "status",
    "original": "yes",
    "sourceRow": 2,
    "normalized": "true",
    "columnIndex": 4
   },
   {
    "row": 2,
    "rule": "trim",
    "column": "amount",
    "original": " 12",
    "sourceRow": 3,
    "normalized": "12",
    "columnIndex": 3
   },
   {
    "row": 2,
    "rule": "boolean_token",
    "column": "status",
    "original": "no",
    "sourceRow": 3,
    "normalized": "false",
    "columnIndex": 4
   },
   {
    "row": 4,
    "rule": "boolean_token",
    "column": "status",
    "original": "yes",
    "sourceRow": 5,
    "normalized": "true",
    "columnIndex": 4
   },
   {
    "row": 5,
    "rule": "boolean_token",
    "column": "status",
    "original": "no",
    "sourceRow": 6,
    "normalized": "false",
    "columnIndex": 4
   },
   {
    "row": 6,
    "rule": "boolean_token",
    "column": "status",
    "original": "yes",
    "sourceRow": 7,
    "normalized": "true",
    "columnIndex": 4
   },
   {
    "row": 7,
    "rule": "boolean_token",
 
… (truncated)
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/brainiac-csv-data-quality-report-a200e072/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from www.brainiac.software](https://www.zero.xyz/host/www.brainiac.software/llms.txt)
