{"uid":"cap_CydOLIYZMIv1cpVpFvnjD","slug":"partnership-pipeline-record-quality-audit-exact-row-deduplication-3cafbad4","name":"Partnership Pipeline — Record Quality Audit + Exact Row Deduplication + Numeric Interval Filter","description":"Partnership pipeline — Record quality audit + Exact row deduplication + Numeric interval filter: Record quality audit + Exact row deduplication + Numeric interval filter 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-214?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"},"maximum":{"type":"number","default":100,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":0,"maximum":1000000000000,"minimum":-1000000000000}}},"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_92lnYxJqp-daUWWew_Qoz","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 local analytical reports on partnership pipeline data: a record quality audit, exact row deduplication, and numeric interval filter for qualified_partners or active_partners fields, on up to 200 rows.","exampleAgentPrompt":"Can you audit the quality, remove exact duplicate rows, and filter for records where qualified_partners is between 5 and 50 from my partnership pipeline data? I have 4 rows: row-1 for group-a on 2026-10-01 with 10 qualified and 1 active, row-2 for group-b on 2026-10-02 with 20 qualified and 2 active, row-3 for group-a on 2026-10-03 with 15 qualified and 3 active, and row-4 for group-b on 2026-10-04 with 30 qualified and 4 active.","exampleUseCases":[{"title":"Pre-reporting partner data cleanup","prompt":"Before I generate our quarterly partner report, run a quality audit, exact deduplication, and interval filter on these 6 partnership rows — keep only records where qualified_partners is between 10 and 100. The rows span group-a and group-b from October 2026."},{"title":"Detecting duplicates in active partner exports","prompt":"I exported our active partners list and I think there are duplicate rows. Can you run exact row deduplication plus a record quality audit on this set of 50 partnership records, filtering active_partners between 0 and 500?"},{"title":"Filtering low-quality partnership leads","prompt":"I want to identify which of my 120 partnership pipeline rows have missing fields, duplicate entries, or qualified_partners values outside the range of 20 to 200 — can you run all three checks at once?"}],"resultDescription":"Returns three independent reports: (1) a record quality audit flagging malformed, missing, or invalid field values; (2) an exact row deduplication report identifying and removing identical rows; and (3) a numeric interval filter report listing rows where the selected field (qualified_partners or active_partners) falls within the specified minimum–maximum range. All analysis is performed locally on the supplied data with no external lookups.","failureModes":["Fewer than 1 or more than 200 rows submitted — request rejected","Invalid date format (not YYYY-MM-DD) causes schema validation failure","Missing required fields (row_id, company_group, date, qualified_partners, active_partners) cause row-level errors","minimum greater than maximum causes empty or erroneous interval filter results","Non-numeric values in numeric fields may be coerced or flagged as quality issues","Invalid field enum value (not 'qualified_partners' or 'active_partners') causes rejection"],"whenToPreferThis":"Choose this endpoint when you need to perform all three operations — quality audit, exact deduplication, and numeric interval filtering — on partnership pipeline data (qualified_partners, active_partners) in a single low-cost call. Ideal for pre-processing CRM or partner data exports before reporting, without requiring external lookups or live data connections. Best when your dataset is under 200 rows and you need fast, local analytical results.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:39:29.784Z","isFirstParty":false,"canonicalSlug":"partnership-pipeline-record-quality-audit-exact-row-deduplication-3cafbad4"}