{"uid":"cap_hewp5u6jlW0BTRfbTH4uo","slug":"duplicate-observations-exact-row-deduplication-daily-sum-series-7411285a","name":"Duplicate Observations — Exact Row Deduplication + Daily Sum Series","description":"Duplicate observations — Exact row deduplication + Daily sum series: Exact row deduplication + Daily sum series 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-044?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"}}},"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__GmJkLQ5wOsglGTH2qIEY","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":"Performs exact row deduplication analysis and computes a daily sum time series for supplied duplicate-observation records, returning two independent analytical reports in a single call.","exampleAgentPrompt":"I have a batch of observation records with fields row_id, dataset_group, date, duplicate_rows, and total_rows — can you run exact row deduplication and a daily sum series on them, focusing on the duplicate_rows field? Here's my data: row-1 on 2026-10-01 in group-a with 10 duplicates out of 1 total, row-2 on 2026-10-02 in group-b with 20 duplicates out of 2 total.","exampleUseCases":[{"title":"Data pipeline deduplication audit","prompt":"I ingested sensor readings into three dataset groups last week and want to know which rows are exact duplicates and how the duplicate count sums up day by day — can you run both reports on my duplicate_rows data across group-a and group-b for dates 2026-10-01 through 2026-10-04?"},{"title":"Daily duplicate trend monitoring","prompt":"Here are my daily observation records for October — each has a row_id, dataset_group, date, and duplicate_rows count. Can you compute a daily sum series for total_rows so I can see how the total scales each day alongside the deduplication report?"},{"title":"Multi-group data quality review","prompt":"I have 150 rows of duplicate observation records across groups alpha, beta, and gamma covering the past month. Run exact row deduplication and a daily sum series on the duplicate_rows field so I can spot which days and groups have the worst data quality issues."}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication report identifying and collapsing identical records from the supplied dataset, and (2) a daily sum time series aggregating the selected field (duplicate_rows or total_rows) by date — both computed locally from the submitted rows without any external lookup.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) — validation error","Date strings not matching YYYY-MM-DD pattern — schema validation failure","Numeric values outside the allowed range (±1,000,000,000,000) — rejection","Empty rows array — minimum items constraint violated","Payment not provided or insufficient — x402 payment required error"],"whenToPreferThis":"Choose this endpoint when you need both a deduplication report and a daily sum time series computed together in a single low-cost call (0.01 USDC for both reports), using only your supplied data with no external lookups. Ideal for data quality workflows where you want to identify exact duplicate records and simultaneously understand how duplicate or total row counts trend day-by-day across dataset groups, especially when working with up to 200 rows at a time.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:58:11.410Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-exact-row-deduplication-daily-sum-series-7411285a"}