{"uid":"cap_7EhVGO2h_0gIG_BcN_Uol","slug":"csv-duplicate-key-check-b29a4dc2","name":"CSV Duplicate Key Check","description":"CSV Duplicate Key Check: CSV Duplicate Key Check finds duplicate composite keys in CSV rows from bounded caller-supplied values without an external provider. Call CSV Duplicate Key Check before an agent hands structured data or a batch plan to a downstream tool with a stricter contract. Returns the bounded transformation or validation finding with counts, normalized values, and a versioned result contract for CSV Duplicate Key Check as versioned deterministic JSON. Price: $0.001 USDC via x402 o…","url":"https://api.delx.ai/api/v1/x402/csv-duplicate-key-check","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"text":{"type":"string","maxLength":8192,"description":"Text supplied to CSV Duplicate Key Check; used only for this bounded calculation and processed in memory without retention."},"key_columns":{"type":"array","items":{"type":"string","maxLength":8192},"maxItems":256,"description":"Key Columns supplied to CSV Duplicate Key Check; used only for this bounded calculation and processed in memory without retention."}}},"responseSchema":{"type":"json","example":{"result":{"unique":false,"duplicate_rows":[3]},"schema":"delx/util-csv-duplicate-key-check/v1","status":"advisory","evidence":{"retained":false,"input_sha256":"9046a42812db7833761b9aee29de477ebae24f4c8ae2087d757d328905d6db58","external_calls":0},"operation":"data_batch:csv_duplicate_key_check"}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.001","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.001/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.001","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.001","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_cZEbfR9ErkACca_5mIdaF","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.001","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Detects duplicate composite keys in CSV data rows using caller-supplied column names, returning counts and normalized findings as versioned deterministic JSON.","exampleAgentPrompt":"Check my CSV data for duplicate composite keys using the columns 'order_id' and 'product_sku' — I need to catch any repeated key combinations before I send this batch to the fulfillment system.","exampleUseCases":[{"title":"Pre-import database uniqueness check","prompt":"Before I load this CSV into the database, scan it for any rows that share the same 'customer_id' and 'invoice_number' — I need to know if there are duplicate composite keys that would violate my unique constraint."},{"title":"ETL pipeline data quality gate","prompt":"Run a duplicate key check on this CSV using the columns 'date' and 'store_code' as the composite key — flag any duplicates with their counts so I know if the pipeline data is clean before the next stage."},{"title":"Batch plan validation before downstream tool","prompt":"I'm about to hand this structured CSV batch off to a payment processor. Can you check it first for any duplicate 'transaction_id' and 'account_id' key combinations and show me how many times each duplicate appears?"}],"resultDescription":"Returns versioned deterministic JSON containing duplicate composite key findings, including counts of occurrences per duplicate key combination, normalized key values, and a versioned result contract indicating whether duplicates were found and their details.","failureModes":["CSV text exceeds 8192 character limit — request rejected","key_columns references column names not present in the CSV header — returns empty or error finding","Malformed CSV (unquoted commas, inconsistent columns) may cause incorrect row parsing","Empty CSV or CSV with only a header row returns zero duplicates with no error","key_columns array is empty — behavior undefined or returns trivial result"],"whenToPreferThis":"Use this endpoint when an agent needs to validate CSV uniqueness constraints on composite keys before handing structured data to a downstream system with strict deduplication requirements. Prefer this over manual row comparison when the CSV is bounded in size (under 8192 chars), no external database or service is available, and a deterministic versioned result is needed for audit or contract purposes.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-15T01:09:44.432Z","isFirstParty":false}