{"uid":"cap_xpsx4syftKiVoldmcpgOp","slug":"partnership-pipeline-string-normalisation-duplicate-key-report-8ca0ce39","name":"Partnership Pipeline — String Normalisation & Duplicate Key Report","description":"Partnership pipeline — String normalisation + Duplicate key report: String normalisation + 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-021?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_z6PurJAtBQbX8wBczYdaL","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":"Normalises strings and detects duplicate keys in partnership pipeline records (qualified_partners, active_partners) for up to 200 rows, returning two independent analytical reports.","exampleAgentPrompt":"Can you run a string normalisation and duplicate key check on my partnership pipeline data? Here are my records — rows covering company groups like 'group-a' and 'group-b' with dates from 2026-10-01 through 2026-10-04 and their qualified and active partner counts. I want both reports back.","exampleUseCases":[{"title":"Pre-import partner data cleanup","prompt":"Before I import this batch of 120 partnership pipeline records into our CRM, can you normalise all the string fields and flag any duplicate row_ids or company_group entries? I'll give you the rows with dates, company groups, and both qualified and active partner counts."},{"title":"Weekly partnership data quality audit","prompt":"Run our weekly data quality check on this week's partnership pipeline export — I need to see string normalisation fixes and a full duplicate key report across all 85 rows. The records include company_group, date, qualified_partners, and active_partners."},{"title":"Spotting repeated entries across partner groups","prompt":"I think some of our partner records got entered twice under slightly different company group names — can you normalise the strings and identify any duplicate keys across these 60 partnership pipeline rows so I can see which ones to merge?"}],"resultDescription":"Returns two independent reports: (1) a string normalisation report highlighting inconsistencies, casing issues, or whitespace problems across text fields such as company_group; and (2) a duplicate key report identifying rows that share identical or conflicting key values across the dataset of up to 200 rows. No external lookups or predictions are performed — all analysis is done locally on the supplied data.","failureModes":["Exceeding 200 rows causes a rejection or truncation error","Missing required fields (row_id, company_group, date, qualified_partners, active_partners) causes validation failure","Malformed date strings not matching YYYY-MM-DD pattern are rejected","Numeric values outside the allowed range (-1,000,000,000,000 to 1,000,000,000,000) are rejected","Empty rows array returns an error"],"whenToPreferThis":"Choose this endpoint when you need both string normalisation and duplicate key detection on partnership pipeline data in a single low-cost call. Ideal for pre-import data hygiene, periodic CRM audits, or quality gating before analytics pipelines. Best suited for datasets up to 200 rows where no external lookups, predictions, or live data enrichment are needed — purely local, deterministic analysis on supplied records.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:39:38.504Z","isFirstParty":false,"canonicalSlug":"partnership-pipeline-string-normalisation-duplicate-key-report-8ca0ce39"}