{"uid":"cap_fC1S4JmB7dAiVkfkTiOVJ","slug":"brainiac-csv-column-type-detector-879d3549","name":"BRAINIAC CSV Column Type Detector","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-column-type-detect?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":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}],"status":"detected","columns":[{"name":"id","type":"integer","index":1,"observed":[{"type":"integer","count":12}]},{"name":"email","type":"mixed","index":2,"observed":[{"type":"email","count":11},{"type":"string","count":1}]},"…"],"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,"dataModified":false,"columnsOmitted":0,"recordsOmitted":0,"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_dEAJOeU0S8p43WqiW81xX","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":"Analyzes CSV, JSON, or record data to detect column data types, identify inconsistencies, and report format conflicts across rows","exampleAgentPrompt":"Can you analyze this CSV and tell me what data type each column contains, and flag any rows where a value doesn't match the column's most common type?","exampleUseCases":[{"title":"Pre-import data quality check","prompt":"I have a CSV of customer records I'm about to import into our database — can you scan it and tell me what type each column is and flag any rows where a value looks wrong for that column?"},{"title":"Detecting mixed email column formats","prompt":"Something seems off with our email column — can you analyze this CSV and show me which rows have values that don't look like valid emails compared to the rest of the column?"},{"title":"Validating exported JSON records","prompt":"I exported 500 records from our system as JSON — can you check the column types across all fields and tell me if any columns have inconsistent formats or unexpected value types?"}],"resultDescription":"Returns a structured JSON object with per-column type analysis (name, detected type, index, observed type counts), a list of issues/conflicts per row (including which column, what value, what code, and a detail message), counts of blank rows, records read, omitted rows and columns, a checkedAt timestamp, and a list of limitations. The dataModified field confirms no data is altered. Status field indicates detection outcome.","failureModes":["Input exceeds 200,000 character limit for CSV/JSON strings — request rejected","File base64 exceeds 12,000,000 character limit — request rejected","More than 5,000 records supplied in records array — excess ignored or rejected","Rows past the 2,000-row limit are not analyzed — recordsOmitted indicates how many were skipped","Columns past the 40-column limit are not analyzed — columnsOmitted indicates how many were skipped","Malformed CSV or JSON input — parse error returned","Payment not completed via x402/USDC on Base — 402 response, no result returned"],"whenToPreferThis":"Choose this endpoint when you need automated column-level type inference on tabular data (CSV, JSON records, or plain text) without setting up an account or long-term subscription. It is ideal for one-off data quality checks before ETL pipelines, database imports, or data cleaning workflows. Prefer it over manual inspection or heavier data profiling tools when you need a fast, cheap, pay-per-use analysis with structured JSON output including per-row conflict reporting.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-17T00:36:25.302Z","isFirstParty":false,"canonicalSlug":"brainiac-csv-column-type-detector-879d3549"}