{"uid":"cap_es4JaDZUToPCqjogUUahE","slug":"brainiac-csv-normalize-a0a1ac1d","name":"BRAINIAC CSV Normalize","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-normalize?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":[],"status":"proposed","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},"…"],"rowCount":12,"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 stat…","…"],"recordsRead":12,"changedCount":13,"dataModified":false,"columnsOmitted":0,"recordsOmitted":0,"unchangedCount":1,"recordsDiscarded":false,"outliersConfirmed":false}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.04","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.04/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.04","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.04","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_hSX6CHSwmXeTrhcfUSPM2","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.04","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Normalizes tabular data (CSV, JSON, or records) by detecting and fixing common data quality issues such as inconsistent casing, boolean token variants, and whitespace, returning a proposed set of changes.","exampleAgentPrompt":"Can you normalize this CSV data for me — standardize the email column to lowercase, convert yes/no values to true/false booleans, and trim whitespace from the amount column? Here's the CSV content: [csv string].","exampleUseCases":[{"title":"Pre-import data cleanup pipeline","prompt":"Before we load this CSV into the database, can you normalize it — lowercase all emails, convert yes/no to true/false, and strip any whitespace from numeric fields? Here's the file content."},{"title":"Audit data quality issues in spreadsheet","prompt":"I have a messy spreadsheet export as a CSV — can you scan it for data quality issues and tell me what needs to be fixed, like inconsistent casing, whitespace, or mixed boolean formats?"},{"title":"Standardize JSON records before API submission","prompt":"I have a JSON array of customer records that have inconsistent boolean values and some emails in mixed case. Can you normalize them so everything is consistent before I send them to the API?"}],"resultDescription":"A JSON object containing: a 'status' field (e.g. 'proposed'), a 'changes' array listing each proposed normalization (row index, column name, rule applied, original value, normalized value, and column index), a 'rowCount', 'blankRows', 'issues' list, 'format', and 'checkedAt' timestamp. Also includes a 'limitations' array describing what the service does and does not do. Changes are proposals only — no data is modified in any external system.","failureModes":["Input exceeds 200,000 character limit for CSV/JSON strings — request will be rejected","Record array exceeds 5,000-item limit — excess rows will be omitted","Column names exceed 80-character limit — may cause parsing errors","Unsupported media type in file upload — only text/csv, application/json, and text/plain are accepted","Malformed CSV or JSON input — may result in parsing errors or empty changes array","Payment not received or insufficient USDC — 402 response with payment instructions"],"whenToPreferThis":"Use this endpoint when you need a lightweight, accountless, pay-per-call data normalization step — particularly for cleaning CSV or JSON tabular data before import, transformation, or display. It is ideal for agents that encounter messy field values (mixed-case emails, inconsistent boolean tokens, whitespace padding) and need a proposed set of safe, rule-based fixes without touching any external system. Prefer this over manual scripting or heavier ETL platforms when you want fast, deterministic normalization with no setup.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-16T18:40:45.860Z","isFirstParty":false,"canonicalSlug":"brainiac-csv-normalize-a0a1ac1d"}