{"uid":"cap_rnJQOhONQFs47ZvFM-ja3","slug":"brainiac-csv-json-schema-detector-84b452fc","name":"BRAINIAC CSV/JSON Schema 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-schema-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":[],"status":"detected","columns":[{"name":"id","type":"integer","count":12,"index":1,"nullable":false,"distinctCount":11},{"name":"email","type":"mixed","count":12,"index":2,"nullable":false,"distinctCount":11},{"name":"amount","type":"integer","count":12,"index":3,"nullable":false,"distinctCount":5},{"name":"status","type":"boolean","count":11,"index":4,"nullable":true,"distinctCount":2},{"name":"joined","type":"mixed","count":12,"index":5,"nullable":false,"distinctCount":11}],"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,"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_Qo6mn20tYN1q7Q7Ik0cpe","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":"Analyzes CSV, JSON, or tabular data to detect column types, data quality issues, nullability, and row/column statistics without modifying the source data.","exampleAgentPrompt":"I have a CSV file with columns like id, email, amount, status, and joined — can you detect the schema and tell me which columns have mixed types, nulls, or data quality issues?","exampleUseCases":[{"title":"Pre-import data quality check","prompt":"Before I load this CSV into the database, can you detect all the column types and flag any nulls, mixed types, or blank rows so I know what needs cleaning first?"},{"title":"Validating exported JSON records","prompt":"I exported 500 records from our CRM as JSON — can you profile the columns, tell me the detected types, how many distinct values each has, and whether any fields are nullable?"},{"title":"Automated pipeline schema detection","prompt":"My pipeline just received a new data file — can you detect its schema, identify any columns with mixed data types, and tell me how many rows and columns were read?"}],"resultDescription":"Returns a JSON object with per-column metadata (name, detected type, count, index, nullable, distinctCount), overall row count, blank row count, columns/records omitted due to limits, data modification flag, outlier confirmation status, and a list of data quality issues and limitations. The checkedAt timestamp and format field are also included.","failureModes":["Input exceeds 200,000 character limit for CSV/JSON strings — request is rejected","More than 2,000 rows provided — rows beyond the limit are silently omitted and recordsOmitted is incremented","More than 40 columns in input — extra columns are omitted and columnsOmitted is incremented","Invalid base64 encoding in file.fileBase64 — parsing error returned","Unsupported mediaType provided — validation error","Payment of $0.03 USDC on Base not completed — 402 response with payment instructions","Empty or malformed CSV/JSON — may return zero columns or parsing error"],"whenToPreferThis":"Choose this endpoint when you need fast, accountless schema detection and data profiling on tabular data (CSV, JSON, or records) without modifying source data. Ideal for pre-import validation, pipeline ingestion checks, or any agent workflow that needs to understand data structure before processing. At $0.03 per call with no account required, it suits ephemeral agent workflows. Prefer alternatives if you need full data transformation, database writes, or analysis beyond 2,000 rows / 40 columns.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-17T00:36:49.750Z","isFirstParty":false,"canonicalSlug":"brainiac-csv-json-schema-detector-84b452fc"}