{"uid":"cap_nEW5wOuf5hPngin86ve8a","slug":"brainiac-csv-data-quality-report-a200e072","name":"BRAINIAC CSV Data Quality Report","description":"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.","url":"https://www.brainiac.software/api/v1/data-quality/csv-report?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"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}}},"responseSchema":{"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","column":"status","original":"no","sourceRow":8,"normalized":"false","columnIndex":4},{"row":8,"rule":"boolean_token","column":"status","original":"yes","sourceRow":9,"normalized":"true","columnIndex":4},{"row":9,"rule":"boolean_token","column":"status","original":"no","sourceRow":10,"normalized":"false","columnIndex":4},{"row":10,"rule":"boolean_token","column":"status","original":"yes","sourceRow":11,"normalized":"true","columnIndex":4},{"row":11,"rule":"boolean_token","column":"status","original":"yes","sourceRow":12,"normalized":"true","columnIndex":4},{"row":12,"rule":"boolean_token","column":"status","original":"no","sourceRow":13,"normalized":"false","columnIndex":4}],"columns":[{"max":"12","min":"1","name":"id","type":"integer","count":12,"index":1,"nullable":false,"missingCount":0,"distinctCount":11},{"max":"not-an-email","min":"Ada@Example.com","name":"email","type":"mixed","count":12,"index":2,"nullable":false,"missingCount":0,"distinctCount":11},{"max":"500","min":"10","name":"amount","type":"integer","count":12,"index":3,"nullable":false,"missingCount":0,"distinctCount":5},{"max":"yes","min":"no","name":"status","type":"boolean","count":11,"index":4,"nullable":true,"missingCount":1,"distinctCount":2},{"max":"2024-10-01","min":"03/11/2026","name":"joined","type":"mixed","count":12,"index":5,"nullable":false,"missingCount":0,"distinctCount":11}],"outliers":[{"row":9,"rule":"tukey_1_5_iqr","value":"500","column":"amount","detail":"The value is outside the Tukey fence 8.875 to 13.875. This is a statistical outlier, not a confirmed error.","confirmed":false,"sourceRow":10,"columnIndex":3}],"rowCount":12,"blankRows":0,"checkedAt":"2026-11-03T14:00:00.000Z","columnCount":5,"limitations":["No business system is contacted or updated.","Rows past the 2,000-row limit and columns past the 40-column limit are not read. recordsOmitted and columnsOmitted state how many.","Rows that were read stay in the counts. None of those rows is deleted.","Normalization is a proposal. The original cell is kept beside the proposed value.","A statistical outlier is not a confirmed error.","A date is normalized only when it is already a real YYYY-MM-DD day."],"recordsRead":12,"dataModified":false,"outlierCount":1,"columnsOmitted":0,"recordsOmitted":0,"recordsDiscarded":false,"outliersConfirmed":false}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.12","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.12/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.12","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.12","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_6MbEpCNkm-5a4yTk70Ikw","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.12","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"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.","exampleAgentPrompt":"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?","exampleUseCases":[{"title":"Pre-import database validation","prompt":"Before I import this customer CSV into our database, can you check it for duplicate rows, missing required fields, and any email addresses or status columns that need to be normalized?"},{"title":"Audit exported spreadsheet for inconsistencies","prompt":"I exported this sales data as a CSV—can you scan it for formatting issues, like dates in the wrong format or amounts with extra whitespace, and tell me exactly which rows have problems?"},{"title":"Automated pipeline data quality gate","prompt":"I have a JSON records payload from our data pipeline—run a quality check on it using 'customer_id' and 'email' as key columns and report back any duplicates, blanks, or type conflicts before we process it further."}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-17T00:36:21.356Z","isFirstParty":false,"canonicalSlug":"brainiac-csv-data-quality-report-a200e072"}