{"uid":"cap_LtALiSKaI3Pna0O6KJ5vY","slug":"partnership-pipeline-string-normalisation-and-exact-row-deduplication-ddf1e9ec","name":"Partnership Pipeline String Normalisation and Exact Row Deduplication","description":"Partnership pipeline — String normalisation + Exact row deduplication: String normalisation + Exact row deduplication 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-020?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_-rxyfd4mRasS0R4-L659o","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 removes exact duplicate rows from partnership pipeline records containing qualified_partners and active_partners fields, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you clean up this partner pipeline dataset — normalise the string fields and remove any exact duplicate rows? I have records for group-a and group-b with qualified_partners and active_partners counts across October 2026, about 50 rows total.","exampleUseCases":[{"title":"Deduplicate quarterly partner pipeline export","prompt":"I've exported our Q4 partner pipeline and I think there are duplicate rows in it — can you run string normalisation and exact deduplication on these 120 records with company_group, date, qualified_partners and active_partners columns so I get clean data back?"},{"title":"Standardise partner names before CRM import","prompt":"Before I import this batch of partner records into our CRM, can you normalise the company_group strings and flag any exact duplicate rows? I have about 80 rows with row_id, date, qualified_partners and active_partners fields."},{"title":"Audit active partner data for reporting","prompt":"We're preparing a partner performance report and need the underlying data cleaned first — please run string normalisation and exact row deduplication on these 45 partnership pipeline records covering group-a through group-d across the past two weeks."}],"resultDescription":"Two independent analytical reports: one covering string normalisation results (standardised company_group and string fields) and one covering exact row deduplication results (identifying and removing fully identical rows), applied to the supplied partnership pipeline records of up to 200 rows. No external lookups or predictions are made; all analysis is performed locally on the supplied data.","failureModes":["Exceeding 200 rows returns an error or truncation","Missing required fields (row_id, company_group, date, qualified_partners, active_partners) causes validation failure","Invalid date format (not YYYY-MM-DD) triggers schema rejection","Numeric values outside the ±1,000,000,000,000 range are rejected","Empty rows array (minItems:1 violated) returns an error","Malformed JSON body results in a 400-level error"],"whenToPreferThis":"Choose this endpoint when you have partnership pipeline data (with qualified_partners and active_partners fields) that needs both string field normalisation and exact row deduplication in a single low-cost call. Ideal for pre-processing partner data before analytics, CRM import, or reporting when your dataset is 200 rows or fewer and you need two focused quality reports without external lookups or ML predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:53:39.558Z","isFirstParty":false,"canonicalSlug":"partnership-pipeline-string-normalisation-and-exact-row-deduplication-ddf1e9ec"}