{"uid":"cap_lNzt7MIOsyJYa5FjAPS3J","slug":"customer-segment-observations-exact-row-deduplication-numeric-row-682fba16","name":"Customer Segment Observations — Exact Row Deduplication + Numeric Row Ordering","description":"Customer segment observations — Exact row deduplication + Numeric row ordering: Exact row deduplication + Numeric row ordering for supplied customer segment observations records (account_count, revenue_amount). 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-16-042?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","account_count","revenue_amount"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"account_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"company_group":{"type":"string","default":"","maxLength":80},"revenue_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","account_count":10,"company_group":"group-a","revenue_amount":1},{"date":"2026-10-02","row_id":"row-2","account_count":20,"company_group":"group-b","revenue_amount":2},{"date":"2026-10-03","row_id":"row-3","account_count":15,"company_group":"group-a","revenue_amount":3},{"date":"2026-10-04","row_id":"row-4","account_count":30,"company_group":"group-b","revenue_amount":4}],"maxItems":200,"minItems":1},"field":{"enum":["account_count","revenue_amount"],"type":"string","default":"account_count"}}},"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_WBimFRHalDj8IfUcNTuPw","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":"Deduplicates exact duplicate rows and applies numeric ordering to customer segment observation records containing account_count and revenue_amount fields, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you deduplicate my customer segment observations and return them in numeric row order? I have up to 50 rows with fields like company_group, date, account_count, and revenue_amount — please run both the deduplication and ordering reports on the account_count field.","exampleUseCases":[{"title":"Clean duplicate segment pipeline data","prompt":"I've got a batch of customer segment records with company groups and dates that might have duplicate rows — can you run exact row deduplication and numeric ordering on them using the account_count field and give me both reports?"},{"title":"Order revenue observations for reporting","prompt":"I need my customer segment observations sorted numerically by revenue_amount and any exact duplicates removed before I hand them to my finance team — can you process these rows and give me the two standard reports?"},{"title":"Audit repeated entries in group analytics","prompt":"My analytics pipeline sometimes produces repeated entries for the same company_group and date combo. Can you run exact deduplication plus numeric row ordering on these segment records and show me what got removed and how they're ordered by account_count?"}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying and removing fully duplicate rows from the submitted customer segment observations, and (2) a numeric row ordering report presenting the rows sorted by the selected numeric field (account_count or revenue_amount). Both reports are computed locally on the supplied data with no external lookups.","failureModes":["Input array is empty (minItems: 1 violation — rejected)","More than 200 rows submitted (maxItems: 200 exceeded — rejected)","Missing required fields (row_id, company_group, date, account_count, or revenue_amount) — validation error","Date field does not match YYYY-MM-DD pattern — validation error","Numeric fields outside allowed range (-1,000,000,000,000 to 1,000,000,000,000) — validation error","Invalid field enum value (must be 'account_count' or 'revenue_amount') — rejected","Payment of 0.01 USDC not provided — 402 Payment Required response"],"whenToPreferThis":"Choose this endpoint when you need both exact duplicate row removal and numeric ordering applied to customer segment data (account_count, revenue_amount) in a single $0.01 call that returns two reports. It is ideal for lightweight, offline data cleaning tasks on batches up to 200 rows where no external data enrichment, prediction, or live lookup is needed. Prefer alternatives if you need string normalization, statistical outlier detection, category frequency analysis, or other analytical operations not covered by deduplication and numeric ordering.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T00:52:26.839Z","isFirstParty":false,"canonicalSlug":"customer-segment-observations-exact-row-deduplication-numeric-row-682fba16"}