{"uid":"cap_H9lGaWDDQ-ozfzcEBjUZC","slug":"partnership-pipeline-exact-row-deduplication-numeric-distribution-963c6e42","name":"Partnership Pipeline — Exact Row Deduplication + Numeric Distribution","description":"Partnership pipeline — Exact row deduplication + Numeric distribution: Exact row deduplication + Numeric distribution 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-039?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},"field":{"enum":["qualified_partners","active_partners"],"type":"string","default":"qualified_partners"}}},"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_rzJb0kHr4onKyWUTfKSv7","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 numeric distribution analysis on partnership pipeline records (qualified_partners, active_partners) for up to 200 rows, returning two independent analytical reports.","exampleAgentPrompt":"Can you deduplicate these partnership pipeline rows and show me the numeric distribution for the qualified_partners field? I have 4 records with row IDs row-1 through row-4, spanning group-a and group-b, dated 2026-10-01 to 2026-10-04, with qualified_partners values of 10, 20, 15, 30 and active_partners of 1, 2, 3, 4.","exampleUseCases":[{"title":"Quarterly partner data deduplication audit","prompt":"I've got a list of 50 partnership pipeline rows across company groups north-region and south-region for Q3 — can you scan them for exact duplicate rows and also give me the numeric distribution of the qualified_partners field?"},{"title":"Active partner count distribution check","prompt":"Here are 120 rows of partner pipeline data tagged with row IDs and company groups. Run exact deduplication on them and show me the distribution breakdown for the active_partners numbers."},{"title":"Multi-group pipeline data quality review","prompt":"I have partnership records for groups alpha, beta, and gamma from the last two months — about 80 rows total. Can you find any exactly duplicated rows and give me a distribution report on the qualified_partners values?"}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication report identifying and flagging fully duplicate rows in the submitted dataset, and (2) a numeric distribution report for the chosen field (qualified_partners or active_partners), including statistical spread metrics such as counts, min, max, mean, and percentile breakdowns — all computed locally without any external lookups or live data.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, date, company_group) cause validation errors","Malformed date strings not matching YYYY-MM-DD pattern rejected","Numeric values outside ±1,000,000,000,000 bounds rejected","Empty rows array (minItems: 1 not met) returns error","Invalid field enum value (not 'qualified_partners' or 'active_partners') rejected"],"whenToPreferThis":"Choose this endpoint when you need fast, local, offline-style deduplication and distribution analytics on a small-to-medium batch of partnership pipeline records (up to 200 rows) and do not need live data enrichment, predictions, or external validation. Ideal for data quality checks on CRM exports, periodic pipeline audits, or pre-processing steps before loading into a dashboard. At $0.01 per call covering two reports, it is cost-effective for lightweight analytical tasks.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:17.380Z","isFirstParty":false,"canonicalSlug":"partnership-pipeline-exact-row-deduplication-numeric-distribution-963c6e42"}