{"uid":"cap_byYGssLh0py5jGKHur7Mb","slug":"partnership-pipeline-exact-row-deduplication-keyed-dataset-comparison-255b4b4b","name":"Partnership Pipeline — Exact Row Deduplication + Keyed Dataset Comparison","description":"Partnership pipeline — Exact row deduplication + Keyed dataset comparison: Exact row deduplication + Keyed dataset comparison 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-053?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},"other":{"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":21},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","active_partners":3,"qualified_partners":17},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","active_partners":4,"qualified_partners":33}],"maxItems":200,"minItems":0}}},"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_X1IULffVf4MhUwmA5rGxN","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":"Performs exact row deduplication and keyed dataset comparison on two sets of partnership pipeline records (qualified_partners, active_partners) for up to 200 rows, returning two independent analytical reports.","exampleAgentPrompt":"I have two snapshots of our partnership pipeline — the original and an updated version, each up to 200 rows with row_id, company_group, date, qualified_partners, and active_partners. Can you run exact row deduplication on the first set and a keyed comparison between the two sets to find what changed?","exampleUseCases":[{"title":"Audit partner pipeline for duplicate entries","prompt":"We exported our qualified_partners and active_partners pipeline records for October and I think there are duplicate rows mixed in. Can you deduplicate the dataset and also compare it against last month's export to see what rows are new, removed, or changed? Here are the rows: row-1 group-a 2026-10-01, row-2 group-b 2026-10-02, row-3 group-a 2026-10-03."},{"title":"Compare two partner dataset snapshots","prompt":"I have two versions of our partnership pipeline CSV — one from our CRM and one from a manual export — both with row_id, company_group, date, qualified_partners, and active_partners fields. Can you compare them row by row to find which entries differ, and also flag any exact duplicate rows in either set?"},{"title":"Validate merged partner records before reporting","prompt":"Before I submit the quarterly partner report, I need to verify that our merged dataset from group-a and group-b has no duplicate rows, and that the numbers in qualified_partners and active_partners match our reference dataset. Can you run the deduplication and keyed comparison checks on these two sets of up to 200 rows each?"}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication report identifying duplicate rows within the supplied dataset, and (2) a keyed dataset comparison report highlighting rows that are added, removed, or changed between the two supplied datasets, keyed by row_id, company_group, and date fields — all computed locally without external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, company_group, date, qualified_partners, active_partners) — validation error","Date field does not match YYYY-MM-DD pattern — schema validation failure","row_id field is empty or exceeds 80 characters — rejected","Numeric fields out of allowed range (±1,000,000,000,000) — validation error","Empty rows array (minItems: 1 not met) — rejected"],"whenToPreferThis":"Choose this endpoint when you need local, deterministic, offline-style analysis of partnership pipeline data — specifically exact row deduplication and keyed diff between two datasets — without requiring any live lookups, ML predictions, or external data enrichment. Ideal for data quality checks on CRM exports, pipeline snapshots, or staged partner records before reporting or ingestion. At $0.01 USDC for two reports on up to 200 rows, it is cost-effective for routine data hygiene workflows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:39:07.635Z","isFirstParty":false,"canonicalSlug":"partnership-pipeline-exact-row-deduplication-keyed-dataset-comparison-255b4b4b"}