{"uid":"cap_9NwlXTG5HNgMd25SfjDE8","slug":"delx-commerce-csv-duplicate-key-check-8f2d8986","name":"Delx Commerce CSV Duplicate Key Check","description":"Pay-per-result APIs for agents. No signup. Exact price. Verifiable delivery. USDC on Base + Solana via x402.","url":"https://commerce.delx.ai/api/v1/x402/csv-duplicate-key-check?utm_source=zero.xyz","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_LRF3caM8_84LcVkNG1oX5","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 rows in CSV text based on one or more specified key columns, returning which rows are duplicates.","exampleAgentPrompt":"Check this CSV for duplicate rows based on the 'user_id' and 'date' columns — tell me if there are any duplicates and which row numbers they appear on.","exampleUseCases":[{"title":"Deduplicating customer import file","prompt":"I'm about to import this customer CSV into our CRM — can you check if there are any duplicate rows based on the 'email' column before I do?"},{"title":"Validating composite key uniqueness in orders","prompt":"Here's our orders export CSV. Check if any rows share the same 'order_id' and 'line_item_id' combination — I need to make sure no composite keys are repeated."},{"title":"Audit data pipeline output for duplicates","prompt":"Our data pipeline produced this CSV. Can you check if the 'transaction_id' column has any duplicates and tell me which row numbers are affected?"}],"resultDescription":"Returns a JSON object indicating whether the CSV is unique (true/false), a list of row indices that are duplicates, the operation schema identifier, a status of 'advisory', and evidence metadata including whether input was retained (always false), the SHA-256 hash of the input, and the number of external calls made (always 0).","failureModes":["CSV text exceeds 8192 character limit — request rejected","key_columns references column names not present in the CSV header — may return unexpected results or error","Malformed CSV text (missing headers, inconsistent delimiters) — parsing may fail or yield incorrect results","Empty key_columns array — behavior undefined, may treat all columns as key or return error","More than 256 key columns specified — request rejected per schema maxItems constraint"],"whenToPreferThis":"Choose this endpoint when you need a lightweight, pay-per-call, no-signup check for CSV duplicate keys without sending data to a persistent storage service. Ideal for agents that process CSV data in-flight and need a verifiable, tamper-evident deduplication check (SHA-256 evidence hash included). Prefer this over full ETL or database-based deduplication when data must not be retained and when exact per-call pricing via USDC micropayment is acceptable.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-01T00:53:49.061Z","isFirstParty":false,"canonicalSlug":"delx-commerce-csv-duplicate-key-check-8f2d8986"}