{"uid":"cap_1yGHpMYJlQP_-5TMs8LgT","slug":"hermes-duplicate-audit-api-7a2dbf46","name":"Hermes Duplicate Audit API","description":"Agent utilities for company research, package maintenance intelligence, dependency vulnerability checks, counterparty availability, SEC company snapshots, OFAC sanctions screening, and deterministic JSON/CSV data-quality work. Company domain intelligence includes a free preview before the paid enrichment call.","url":"https://hermes-counterparty-api.onrender.com/v1/duplicate-audit","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":{"oneOf":[{"type":"object","required":["format","records"],"properties":{"format":{"type":"string","const":"json"},"records":{"type":"array","items":{"type":"object"}}}},{"type":"object","required":["format","data"],"properties":{"data":{"type":"string"},"format":{"type":"string","const":"csv"}}}]},"type":{"type":"string","const":"http"},"method":{"enum":["POST"],"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":{"record_count":2,"duplicate_rows":1,"schema_version":"1.0","duplicate_ratio":0.5,"duplicate_groups":[{"count":2,"indexes":[0,1],"first_index":0,"duplicate_count":1}],"unique_row_count":1}},"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_upN7brZlP05PimKcyHWsy","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":"Detects and reports duplicate rows in JSON or CSV datasets, returning counts, ratios, and grouped duplicate indexes.","exampleAgentPrompt":"Can you audit this JSON records array for duplicate rows and tell me how many duplicates there are, which row indexes are duplicated, and what the duplicate ratio is?","exampleUseCases":[{"title":"Pre-load database deduplication check","prompt":"Before I load this JSON dataset into my database, can you check it for duplicate rows and tell me which indexes are repeated and what percentage of the data is duplicated?"},{"title":"CSV data quality audit before reporting","prompt":"I have a CSV file I'm about to use for a report — can you scan it for any duplicate rows and give me a breakdown of how many duplicates exist and which rows match each other?"},{"title":"ETL pipeline data validation","prompt":"As part of my data pipeline, I need to validate this JSON records array for duplicates — can you identify any repeated records, group them, and tell me the duplicate ratio so I can decide whether to proceed?"}],"resultDescription":"Returns a JSON object with: total record_count, number of duplicate_rows, duplicate_ratio (fraction of records that are duplicates), unique_row_count, and a duplicate_groups array where each group lists the row indexes that match, count of occurrences, first_index, and duplicate_count. Schema version is included.","failureModes":["Missing required 'input' field returns validation error","Mismatched format field and body structure (e.g. format:'csv' with JSON records object) causes parsing error","Empty records array may return zero duplicates with no error","Malformed CSV string may cause parsing failure","Incorrect bodyType enum value causes request rejection","Payment failure (402) if USDC balance is insufficient"],"whenToPreferThis":"Choose this endpoint when you need a deterministic, structured report of duplicate rows across JSON or CSV data — especially when you need machine-readable output with exact row indexes and groupings for downstream processing. Prefer over manual deduplication scripts when operating inside an agent workflow that requires a reliable, paid-quality audit result.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-15T00:30:47.124Z","isFirstParty":false}