{"uid":"cap_8DbUhge_N-igiyMKOLMfo","slug":"partnership-pipeline-record-quality-audit-exact-row-deduplication-a6e9b1e8","name":"Partnership Pipeline — Record Quality Audit + Exact Row Deduplication + Category Frequencies","description":"Partnership pipeline — Record quality audit + Exact row deduplication + Category frequencies: Record quality audit + Exact row deduplication + Category frequencies for supplied partnership pipeline records (qualified_partners, active_partners). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-company-09-212?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_LnEeD0fLRC3uhvHJUTFQ2","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":"Runs three analytical reports on partnership pipeline data (qualified_partners, active_partners): a record quality audit, exact row deduplication, and category frequency breakdown — all locally, with no external lookups.","exampleAgentPrompt":"Can you audit these partnership pipeline records for quality issues, remove any exact duplicate rows, and give me a frequency count of each company_group? I have up to 50 rows with fields: row_id, company_group, date, qualified_partners, and active_partners.","exampleUseCases":[{"title":"Pre-import partner data validation","prompt":"Before I load this batch of 80 partnership pipeline rows into our CRM, can you run a quality audit to catch missing or malformed values, flag any exact duplicate rows, and show me how frequently each company_group appears? The rows have row_id, company_group, date, qualified_partners, and active_partners fields."},{"title":"Monthly pipeline deduplication and summary","prompt":"I've got our monthly partnership pipeline export — about 120 rows with company_group, date, qualified_partners, and active_partners — can you deduplicate it, audit the record quality, and tell me the category frequencies for company_group?"},{"title":"Spotting data issues across partner groups","prompt":"We pulled 40 rows of partner pipeline data with qualified_partners and active_partners counts across several company groups and dates — can you check for data quality problems, identify any repeated rows, and count how many records fall into each company_group category?"}],"resultDescription":"Returns three independent reports: (1) a record quality audit flagging null, missing, or out-of-range values across all fields; (2) an exact row deduplication report identifying duplicate records; and (3) a category frequency table showing how often each distinct company_group value appears across the submitted rows. All analysis is performed locally on the supplied data with no external lookups.","failureModes":["Fewer than 1 row submitted — validation error","More than 200 rows submitted — rejected, exceeds max limit","Row missing required fields (row_id, company_group, date, qualified_partners, active_partners) — schema validation error","Date field not matching YYYY-MM-DD pattern — rejected","Numeric values outside allowed range (-1T to 1T) — validation error","Malformed JSON body — parse error"],"whenToPreferThis":"Choose this endpoint when you need three simultaneous analytical reports (quality audit, deduplication, category frequencies) on partnership pipeline data in a single low-cost call. Ideal for pre-import validation, periodic data hygiene checks, or pipeline reporting workflows where you want local computation with no external data access or side effects. Best suited for batches of up to 200 rows with the standard partnership schema (qualified_partners, active_partners, company_group, date).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:42.547Z","isFirstParty":false,"canonicalSlug":"partnership-pipeline-record-quality-audit-exact-row-deduplication-a6e9b1e8"}