{"uid":"cap_ja_N-IfMLjjgGYX28KT2V","slug":"brainiac-csv-duplicate-row-detector-e15e8a4c","name":"BRAINIAC CSV Duplicate Row 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-duplicate-row-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","groups":[{"rows":[{"row":2,"sourceRow":3},{"row":5,"sourceRow":6}],"count":2}],"issues":[{"row":5,"code":"duplicate_row","kind":"conflict","value":"","column":"","detail":"This record matches record 2 after trimming the compared cells. No record was removed.","sourceRow":6,"columnIndex":0}],"status":"checked","blankRows":0,"checkedAt":"2026-11-03T14:00:00.000Z","groupCount":1,"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.05","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.05/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.05","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.05","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_ELPKW5kWv77aeNzkKC3iB","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.05","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Detects duplicate rows in a CSV, JSON, or records dataset by comparing cells after trimming, grouping duplicates, and reporting row-level conflicts.","exampleAgentPrompt":"Can you check this CSV for duplicate rows? I'll paste the content — flag any rows that appear more than once, grouped together, so I can review them before importing.","exampleUseCases":[{"title":"Pre-import database deduplication check","prompt":"Before I load this customer CSV into our CRM, can you scan it for any duplicate rows? Group the duplicates together so I can see which records are repeated."},{"title":"Data pipeline quality gate","prompt":"I have a JSON dataset of transactions — can you detect any duplicate records in it and tell me which row numbers are repeated, so our pipeline can reject the bad batch?"},{"title":"Spreadsheet audit before reporting","prompt":"Here's our monthly sales data as a CSV — please check if any rows are exact duplicates and give me a summary of how many groups of duplicates were found and which rows are involved."}],"resultDescription":"Returns a JSON object containing: a list of duplicate groups (each with the row numbers involved and a count), a flat issues list with row number, source row, error code, detail message, and column info, plus summary stats including recordsRead, blankRows, groupCount, columnsOmitted, recordsOmitted, and a checkedAt timestamp. No data is modified or deleted.","failureModes":["Input exceeds 2,000-row or 40-column limits — rows/columns beyond the limit are silently omitted and counts reflect what was read","CSV or JSON is malformed and cannot be parsed — likely returns a parse error","Neither csv, file, json, nor records field provided — missing input error","File base64 exceeds 12MB limit — rejected with size error","keyColumns references column names not present in the data — may produce empty or unexpected results"],"whenToPreferThis":"Use this endpoint when you need a quick, accountless, pay-per-call duplicate row detection on tabular data (CSV, JSON, or raw records) without setting up a data quality platform. Ideal for agents doing one-off data validation before ingestion, ETL pipelines, or reporting. Prefer this over manual deduplication scripts when you need structured, row-level duplicate group output with zero infrastructure.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-16T18:39:58.115Z","isFirstParty":false,"canonicalSlug":"brainiac-csv-duplicate-row-detector-e15e8a4c"}