{"uid":"cap_Nc2QcU-w-Vlt3RX_5SjvK","slug":"brainiac-csv-json-data-quality-profiler-884c9da1","name":"BRAINIAC CSV/JSON Data Quality Profiler","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-profile?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":"profiled","columns":[{"max":"12","min":"1","name":"id","type":"integer","count":12,"index":1,"missingCount":0,"distinctCount":11},{"max":"not-an-email","min":"Ada@Example.com","name":"email","type":"mixed","count":12,"index":2,"missingCount":0,"distinctCount":11},{"max":"500","min":"10","name":"amount","type":"integer","count":12,"index":3,"missingCount":0,"distinctCount":5},{"max":"yes","min":"no","name":"status","type":"boolean","count":11,"index":4,"missingCount":1,"distinctCount":2},{"max":"2024-10-01","min":"03/11/2026","name":"joined","type":"mixed","count":12,"index":5,"missingCount":0,"distinctCount":11}],"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 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.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_E_H3M-sCBxxC39LOk7FhL","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":"Profiles and analyzes tabular data (CSV, JSON, or records) to report column types, statistics, missing values, distinct counts, and data quality issues","exampleAgentPrompt":"Can you profile this CSV data for me and tell me the type, min, max, missing count, and distinct count for each column? I want to know if there are any data quality issues like mixed types or blank rows.","exampleUseCases":[{"title":"Pre-ETL data quality check","prompt":"Before I load this CSV into the database, can you profile it and flag any columns with mixed types, missing values, or inconsistent formats? Here's the raw CSV text."},{"title":"Automated dataset health report","prompt":"I have a JSON array of customer records — can you analyze the data quality and give me a breakdown of each column's type, how many values are missing, and how many distinct values there are?"},{"title":"Spot-check uploaded file for issues","prompt":"A user just uploaded this CSV file encoded in base64 with media type text/csv — can you run a data quality profile on it and tell me if there are any blank rows, type mismatches, or outlier issues I should know about?"}],"resultDescription":"Returns a JSON object containing: overall status ('profiled'), format detected, row count, blank row count, timestamp, and an array of column profiles each with name, index, inferred type (integer/string/boolean/mixed), min, max, count, missingCount, and distinctCount. Also includes a list of data quality issues found, counts of records and columns omitted due to limits, and limitation disclosures.","failureModes":["Input exceeds 2,000-row or 40-column limits — rows/columns beyond limits are silently omitted and reported in recordsOmitted/columnsOmitted","Malformed CSV or JSON input may cause parsing errors","File base64 too large (exceeds 12MB encoded limit) — request rejected","Missing required file fields (mediaType or fileBase64) when using file upload mode","Payment not received or insufficient USDC — 402 response returned before processing"],"whenToPreferThis":"Use this endpoint when you need a fast, accountless, pay-per-call data quality profile of tabular data without setting up a full data pipeline tool. It is ideal for one-off or automated checks of CSV/JSON datasets up to 2,000 rows and 40 columns, especially when you want column-level type inference, missing value detection, and distinct counts in a single call. Prefer alternatives if you need to profile very large datasets, need business system integration, or require confirmed outlier validation rather than statistical flagging.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-17T00:37:01.249Z","isFirstParty":false,"canonicalSlug":"brainiac-csv-json-data-quality-profiler-884c9da1"}