{"uid":"cap_ranQHvbzzJSjddtt1YWJU","slug":"duplicate-observations-exact-row-deduplication-numeric-interval-filter-d2fc7e56","name":"Duplicate Observations — Exact Row Deduplication + Numeric Interval Filter","description":"Duplicate observations — Exact row deduplication + Numeric interval filter: Exact row deduplication + Numeric interval filter for supplied duplicate observations records (duplicate_rows, total_rows). 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-analytics-04-043?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","duplicate_rows","total_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"duplicate_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_rows":1,"dataset_group":"group-a","duplicate_rows":10},{"date":"2026-10-02","row_id":"row-2","total_rows":2,"dataset_group":"group-b","duplicate_rows":20},{"date":"2026-10-03","row_id":"row-3","total_rows":3,"dataset_group":"group-a","duplicate_rows":15},{"date":"2026-10-04","row_id":"row-4","total_rows":4,"dataset_group":"group-b","duplicate_rows":30}],"maxItems":200,"minItems":1},"field":{"enum":["duplicate_rows","total_rows"],"type":"string","default":"duplicate_rows"},"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_0rtGx-xFSHL1YjVhRXHPg","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":"Analyzes supplied duplicate-observation records to perform exact row deduplication and filter rows by a numeric interval on a chosen field, returning two independent analytical reports.","exampleAgentPrompt":"I have 4 observation records for groups 'group-a' and 'group-b' with duplicate_rows and total_rows counts — can you deduplicate them exactly and also filter by duplicate_rows between 10 and 25, giving me both reports?","exampleUseCases":[{"title":"Data quality audit for ETL pipeline","prompt":"I'm auditing our ETL pipeline output. Here are 6 dataset observation records with row_id, date, dataset_group, duplicate_rows, and total_rows values — run exact deduplication on them and filter by duplicate_rows between 0 and 50 so I can see which groups have duplicates in that range."},{"title":"Monitoring duplicate spikes across groups","prompt":"We have observation records from 'sales', 'inventory', and 'returns' groups logged daily. Can you deduplicate these 12 rows and filter on total_rows between 100 and 5000 to flag the ones with meaningful volume?"},{"title":"Pre-merge dataset deduplication check","prompt":"Before merging two datasets, I want to check for exact duplicate rows. I have 20 observation records with duplicate_rows and total_rows fields — run deduplication and also filter where duplicate_rows is between 5 and 100, field set to duplicate_rows."}],"resultDescription":"Returns two independent analytical reports per call: (1) an exact row deduplication report identifying and removing duplicate records from the supplied observations, and (2) a numeric interval filter report listing rows where the chosen field (duplicate_rows or total_rows) falls within the specified minimum–maximum range. Covers up to 200 input rows.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) — validation error","Invalid date format (must match YYYY-MM-DD) — schema validation failure","Minimum value greater than maximum value — may return empty filter results","Null numeric values for duplicate_rows or total_rows — may affect interval filter output","Payment not completed (x402 protocol) — endpoint not executed"],"whenToPreferThis":"Choose this endpoint when you need to perform both exact row deduplication and numeric interval filtering on a set of up to 200 pre-supplied observation records in a single call, without requiring external data lookups or live data sources. It is ideal for data quality workflows, ETL auditing, and batch dataset analysis where the data is already in hand and two distinct analytical reports are needed cheaply ($0.01 USDC).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:58:19.677Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-exact-row-deduplication-numeric-interval-filter-d2fc7e56"}