{"uid":"cap_IbLlmSF8e2CZxX_Lxzdte","slug":"foundry-csv-deterministic-deduplication-a0370219","name":"Foundry CSV Deterministic Deduplication","description":"Pay-per-request evidence and data tools: CSV validation and reconciliation, DNS/email configuration evidence, and bounded official weather, earthquake, vehicle, company and study records. Exact USDC prices, explicit JSON contracts and source provenance. No mailbox, ownership, medical or safety guarantees.","url":"https://foundry-par007-machine-revenue-mainnet.inference-chip-index.workers.dev/v2/data/csv-deterministic-deduplication","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"csv":{"type":"string","maxLength":12000,"minLength":1},"keep":{"enum":["first","last","reject"],"type":"string"},"keys":{"type":"array","items":{"type":"string","maxLength":100,"minLength":1},"maxItems":3,"minItems":1}}},"responseSchema":{"type":"json","example":{"route":"csv-deterministic-deduplication","result":{"status":"COMPLETED","input_rows":3,"output_csv":"id,name\r\n1,Ada updated\r\n2,Lin","limitations":["Synthetic example hash."],"output_rows":2,"input_sha256":"0000000000000000000000000000000000000000000000000000000000000000","removed_rows":1,"evidence_truncated":false,"duplicate_key_groups":1,"removed_record_numbers":[2]},"observed_at":"2026-09-06T00:00:00Z"}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.005","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.005/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.005","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.005","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_ZMfeII_D8XXDaWNDhzBzJ","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.005","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Removes duplicate rows from a CSV string using specified key columns, returning a deduplicated CSV with evidence metadata including removed row numbers and a SHA-256 hash of the input.","exampleAgentPrompt":"Can you deduplicate this CSV — keep the last occurrence when there are duplicate 'id' and 'email' key columns, and drop any rows that share both keys: [paste CSV here]?","exampleUseCases":[{"title":"Clean customer list before CRM import","prompt":"I have a CSV export of our customer records with duplicate entries on the 'customer_id' column — can you deduplicate it keeping the last occurrence of each, and tell me which row numbers were removed?"},{"title":"Reject ambiguous duplicate product SKUs","prompt":"Can you run deduplication on this product catalog CSV using 'sku' as the key, but set it to reject any row where the SKU appears more than once — I want to know which SKUs are ambiguous rather than silently picking one?"},{"title":"Reconcile merged contact lists","prompt":"I merged two contact lists into one CSV and now there are duplicates on both 'email' and 'phone' columns — please deduplicate keeping the first occurrence for each pair and give me the cleaned CSV along with a hash of what I sent you."}],"resultDescription":"A JSON object containing: the deduplicated output CSV string, input and output row counts, the number of removed rows and their record numbers, a SHA-256 hash of the original input CSV, the number of distinct duplicate key groups found, a boolean indicating whether evidence was truncated, and a timestamp of when the computation was observed.","failureModes":["CSV exceeds 12,000 character limit — request rejected","Keys array contains column names not present in the CSV header — may produce unexpected results","CSV is malformed or lacks a header row — parsing may fail","More than 3 key columns specified — request rejected","'keep' enum value not one of first/last/reject — validation error","Empty CSV string provided — minLength violation"],"whenToPreferThis":"Choose this endpoint when you need deterministic, reproducible CSV deduplication with cryptographic provenance (SHA-256 input hash) and explicit evidence of which rows were removed. It is ideal for audit-trail-sensitive data pipelines, agent workflows requiring verifiable data transformations, and pay-per-call scenarios where you want per-request pricing at $0.005 USDC rather than maintaining a data processing service.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T00:49:23.604Z","isFirstParty":false}