{"uid":"cap_8CEO-6UTRvpzMO7SDUYkz","slug":"venture-signal-lab-csv-deduplication-8c8ff1af","name":"Venture Signal Lab CSV Deduplication","description":"Small paid data tools for autonomous agents: live opportunity filtering and deterministic CSV deduplication, paid per call with USDC on Base.","url":"https://agency-site-watch.5-10-250-79.sslip.io/api/v1/csv/dedupe?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["input"],"properties":{"input":{"type":"object","required":["type","method","bodyType","body"],"properties":{"body":{"required":["csv_data"],"properties":{"keep":{"enum":["first","last"],"type":"string","default":"first"},"csv_data":{"type":"string","maxLength":100000,"minLength":1},"key_columns":{"type":["array","null"],"items":{"type":"string"},"maxItems":50},"case_sensitive":{"type":"boolean","default":false},"trim_whitespace":{"type":"boolean","default":true}},"additionalProperties":false},"type":{"type":"string","const":"http"},"method":{"enum":["POST","PUT","PATCH"],"type":"string"},"bodyType":{"enum":["json","form-data","text"],"type":"string"}},"additionalProperties":false},"output":{"type":"object","required":["type"],"properties":{"type":{"type":"string"},"example":{"type":"object"}}}}},"responseSchema":{"type":"json","example":{"input_rows":2,"deduped_csv":"email,name\na@example.com,Ada\n","key_columns":["email"],"output_rows":1,"duplicates_removed":1}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.02","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"registry","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"down","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.02/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.02","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.02","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_NRTZQ_EYX0O9vZaljvFzF","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.02","costPer":"request","priority":0,"asset":null,"unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Removes duplicate rows from a CSV file based on specified key columns, returning a cleaned deduplicated CSV with stats.","exampleAgentPrompt":"I have a CSV with email and name columns and there are a bunch of duplicate emails — can you deduplicate it using email as the key column and give me back the cleaned CSV?","exampleUseCases":[{"title":"Clean up duplicate leads list","prompt":"I exported our leads from the CRM and there are tons of duplicate email addresses. Can you deduplicate this CSV using email as the key and give me back a clean list?"},{"title":"Deduplicate subscriber list before sending","prompt":"Before I send out the newsletter, deduplicate this CSV of subscribers — use email as the key column so we don't mail the same person twice."},{"title":"Merge and clean two contact CSVs","prompt":"I combined two contact exports into one CSV and now there are duplicate entries. Deduplicate it using the email column as the unique key and tell me how many duplicates were removed."}],"resultDescription":"Returns a JSON object containing the deduplicated CSV as a string, the key columns used, the number of input rows, output rows after deduplication, and the count of duplicates removed.","failureModes":["Missing or malformed CSV input returns an error","Specified key columns not found in CSV headers","CSV with no duplicate rows returns unchanged data with duplicates_removed = 0","Payment failure (insufficient USDC balance on Base) blocks the call","Malformed CSV syntax causes parsing errors"],"whenToPreferThis":"Choose this endpoint when you need deterministic, programmatic CSV deduplication paid per-call with USDC on Base — ideal for autonomous agents running data pipelines where you want predictable per-use pricing without a subscription, and need a reliable duplicate-removal result with explicit stats (rows in, rows out, duplicates removed).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-31T02:27:54.131Z","isFirstParty":false,"canonicalSlug":"venture-signal-lab-csv-deduplication-8c8ff1af"}