{"uid":"cap_aqUXXb3SIqHZBJ9985a2I","slug":"brainiac-csv-missing-value-audit-55df1a73","name":"BRAINIAC CSV Missing Value Audit","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-missing-value-audit?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","issues":[{"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}],"status":"checked","columns":[{"name":"id","index":1,"missingRate":0,"missingCount":0},{"name":"email","index":2,"missingRate":0,"missingCount":0},{"name":"amount","index":3,"missingRate":0,"missingCount":0},{"name":"status","index":4,"missingRate":0.0833,"missingCount":1},{"name":"joined","index":5,"missingRate":0,"missingCount":0}],"blankRows":0,"checkedAt":"2026-11-03T14:00:00.000Z","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,"missingCount":1,"columnsOmitted":0,"recordsOmitted":0,"recordsDiscarded":false,"outliersConfirmed":false}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.03","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.03/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.03","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.03","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_oGVMkjgZaFTKGkPJz-H5g","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.03","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Audits a CSV, JSON, or record dataset for missing and blank values, returning per-column missing counts, rates, and row-level issue details.","exampleAgentPrompt":"Can you audit this CSV for missing values and tell me which columns have blank cells and how many are missing in each?","exampleUseCases":[{"title":"Pre-pipeline data completeness check","prompt":"Before I load this CSV into my database, can you check it for missing values and tell me which columns have blanks and what percentage of rows are affected?"},{"title":"ETL quality gate for customer records","prompt":"I have a JSON array of 800 customer records — can you audit them for missing fields and flag any rows where email, amount, or status is blank?"},{"title":"Uploaded file audit before ML training","prompt":"I just uploaded a CSV dataset I want to train a model on — can you scan it for missing values per column and tell me how many rows would be affected?"}],"resultDescription":"A JSON object containing: a list of row-level issues (each with row index, column name, column index, source row number, and detail message), per-column statistics (name, index, missing count, missing rate), total missing count, blank row count, records read, records and columns omitted due to limits, a checkedAt timestamp, and a limitations array describing what the audit does and does not cover. The dataModified flag confirms no data was altered.","failureModes":["Input exceeds 2,000 rows or 40 columns — excess rows/columns are silently omitted and counts returned in recordsOmitted/columnsOmitted","CSV or JSON is malformed and cannot be parsed — expect an error response","Input body is empty or no csv/json/records/file field is provided — validation error","File base64 is too large (>12MB) or CSV text exceeds 200,000 characters — rejected with size error","Payment of 0.03 USDC on Base via x402 not received — 402 Payment Required response"],"whenToPreferThis":"Use this endpoint when you need a fast, accountless, per-column missing-value audit of tabular data (CSV, JSON, or record arrays) without integrating a full data pipeline or ETL tool. It is ideal for lightweight data-quality gates before ingestion, training, or reporting, and costs only $0.03 per call with no signup. Prefer alternatives if you need outlier detection, type validation, deduplication, or schema enforcement beyond missing-value detection.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-16T18:40:43.826Z","isFirstParty":false,"canonicalSlug":"brainiac-csv-missing-value-audit-55df1a73"}