{"uid":"cap_HjW_W73FaWBQ5y3XHUGAv","slug":"duplicate-observations-record-quality-audit-exact-row-deduplication-4f2b0c27","name":"Duplicate Observations — Record Quality Audit + Exact Row Deduplication","description":"Duplicate observations — Record quality audit + Exact row deduplication: Record quality audit + Exact row deduplication 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-002?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}}},"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_CFQXAeReibx44Ma8YD8rF","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 a record quality audit and exact row deduplication analysis on supplied duplicate_rows/total_rows data, returning two independent analytical reports for up to 200 rows.","exampleAgentPrompt":"Run a duplicate observation audit and exact row deduplication report on my dataset — I have 4 rows: 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, row-3 on 2026-10-03 in group-a with 15 duplicates out of 3 total, and row-4 on 2026-10-04 in group-b with 30 duplicates out of 4 total.","exampleUseCases":[{"title":"Data pipeline quality check","prompt":"I need a duplicate record audit for my ETL pipeline output — run both a quality audit and exact row deduplication report on these 5 rows: row-1 on 2025-01-10 in group-sales with 50 duplicate rows out of 500 total, row-2 on 2025-01-11 in group-sales with 30 out of 480, row-3 on 2025-01-12 in group-ops with 10 out of 200, row-4 on 2025-01-13 in group-ops with 0 out of 150, row-5 on 2025-01-14 in group-sales with 75 out of 600."},{"title":"Multi-group dataset deduplication review","prompt":"Compare duplicate rates across my two dataset groups — generate both the record quality audit and deduplication report for these observations: row-A on 2024-06-01 in group-alpha with 100 duplicates out of 1000 total, row-B on 2024-06-01 in group-beta with 5 duplicates out of 800 total, row-C on 2024-06-02 in group-alpha with 200 duplicates out of 950 total, row-D on 2024-06-02 in group-beta with 12 out of 820 total."},{"title":"Monthly data health audit","prompt":"Run a duplicate observations quality audit and exact deduplication analysis on my monthly data — here are 3 records: row-jan on 2025-01-31 in group-reports with 22 duplicate rows out of 300 total, row-feb on 2025-02-28 in group-reports with 18 duplicates out of 310 total, row-mar on 2025-03-31 in group-reports with 40 duplicates out of 295 total."}],"resultDescription":"Returns two independent analytical reports: (1) a record quality audit summarizing duplicate rates, data integrity metrics, and per-row/group breakdowns; and (2) an exact row deduplication report identifying and quantifying exact duplicate records across the supplied dataset. Both reports are computed locally using shared analytical engines on up to 200 input rows.","failureModes":["More than 200 rows submitted — request rejected or truncated","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) — validation error","Date field not matching YYYY-MM-DD format — schema validation failure","duplicate_rows or total_rows outside allowed numeric range — rejection","Empty rows array — minimum 1 item required","Payment not completed (x402) — endpoint returns 402 status"],"whenToPreferThis":"Choose this endpoint when you need both a record quality audit and exact row deduplication analysis on structured duplicate-observation data (with duplicate_rows and total_rows fields) in a single call. It is ideal for batch data quality workflows involving up to 200 rows grouped by dataset and date. Prefer this over general-purpose analytics when the data is already structured with row_id, dataset_group, date, duplicate_rows, and total_rows — and when you want two independent reports for the price of one API call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:58:19.376Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-record-quality-audit-exact-row-deduplication-4f2b0c27"}