{"uid":"cap_-g9quXC8Yi5mjBYAaxtp9","slug":"partnership-pipeline-exact-row-deduplication-duplicate-key-report-51e14864","name":"Partnership Pipeline — Exact Row Deduplication + Duplicate Key Report","description":"Partnership pipeline — Exact row deduplication + Duplicate key report: Exact row deduplication + Duplicate key report for supplied partnership pipeline records (qualified_partners, active_partners). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-company-09-038?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","qualified_partners","active_partners"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"company_group":{"type":"string","default":"","maxLength":80},"active_partners":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"qualified_partners":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","active_partners":1,"qualified_partners":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","active_partners":2,"qualified_partners":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","active_partners":3,"qualified_partners":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","active_partners":4,"qualified_partners":30}],"maxItems":200,"minItems":1}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","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.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_tI-WzqJDz74AqM4PqJ59O","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Deduplicates exact rows and generates a duplicate key report for partnership pipeline records (qualified_partners, active_partners) in a single batch call.","exampleAgentPrompt":"Can you check this list of partnership pipeline records for exact duplicate rows and also flag any duplicate keys? I have up to 20 rows with fields like row_id, company_group, date, qualified_partners, and active_partners — I need both a deduplication result and a duplicate key report.","exampleUseCases":[{"title":"Pre-import partner data deduplication","prompt":"Before I load this quarter's partner pipeline data into our CRM, can you check these 80 records for exact duplicate rows and duplicate keys? Each row has a row_id, company_group, date, qualified_partners count, and active_partners count — I need both reports so I can clean the data first."},{"title":"Monthly partner data audit","prompt":"I've exported this month's partnership pipeline snapshot — about 150 rows — and I want to make sure there are no exact duplicate entries or repeated row keys before I share it with leadership. Can you run a deduplication check and a duplicate key report on it?"},{"title":"Multi-group partner record reconciliation","prompt":"We merged partner records from three company groups and now I'm seeing suspicious repeated rows. Can you analyze these 60 combined partnership pipeline records and tell me which rows are exact duplicates and which row IDs appear more than once?"}],"resultDescription":"Returns two independent reports: (1) an exact row deduplication report identifying which rows among the submitted partnership pipeline records are exact duplicates, and (2) a duplicate key report identifying which row keys (e.g., row_id or composite keys) appear more than once across the submitted records. No external lookups or predictions are performed; all analysis is done on the supplied data only.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, company_group, date, qualified_partners, active_partners) causes schema rejection","Invalid date format (not YYYY-MM-DD) triggers pattern validation failure","Numeric values outside [-1,000,000,000,000, 1,000,000,000,000] range are rejected","Empty rows array (minItems: 1 not met) returns an error","Payment of 0.01 USDC required; insufficient payment results in HTTP 402"],"whenToPreferThis":"Choose this endpoint when you need to clean or audit partnership pipeline data containing qualified_partners and active_partners metrics, and want both exact row deduplication and a duplicate key report in a single low-cost call. Ideal for pre-import validation, periodic data quality checks, or reconciliation after merging partner records from multiple sources. Best for batch sizes up to 200 rows. Not suitable if you need fuzzy matching, external enrichment, or real-time partner data lookups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:16.492Z","isFirstParty":false,"canonicalSlug":"partnership-pipeline-exact-row-deduplication-duplicate-key-report-51e14864"}