{"uid":"cap_GmYbQhnkSsj-lgSVRRKj3","slug":"duplicate-observations-analytics-record-quality-audit-exact-row-c2bff935","name":"Duplicate Observations Analytics — Record Quality Audit, Exact Row Deduplication & Duplicate Key Report","description":"Duplicate observations — Record quality audit + Exact row deduplication + Duplicate key report: Record quality audit + Exact row deduplication + Duplicate key report for supplied duplicate observations records (duplicate_rows, total_rows). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-analytics-04-209?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_8TSiaRuw1-qRIz9LLGJCM","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 produce three independent reports: a record quality audit, an exact row deduplication result, and a duplicate key report — all processed locally without external lookups.","exampleAgentPrompt":"Can you run a record quality audit, exact row deduplication, and duplicate key report on these 4 observation records — row-1 for group-a on 2026-10-01 with 10 duplicate rows out of 1 total, row-2 for group-b on 2026-10-02 with 20 duplicates out of 2 total, row-3 for group-a on 2026-10-03 with 15 duplicates out of 3 total, and row-4 for group-b on 2026-10-04 with 30 duplicates out of 4 total?","exampleUseCases":[{"title":"ETL pipeline data quality check","prompt":"I have a batch of 50 observation records from my ETL pipeline for October — each has a row ID, dataset group, date, and duplicate/total row counts. Can you run all three reports: record quality audit, exact row deduplication, and duplicate key report on them so I can see where the data integrity issues are?"},{"title":"Cross-group duplicate comparison","prompt":"I've got observation data across two dataset groups — group-alpha and group-beta — spanning the last 30 days, with duplicate_rows and total_rows for each day. Can you audit the record quality, deduplicate exact rows, and give me a duplicate key report so I can compare duplication rates between the two groups?"},{"title":"Daily dataset deduplication audit","prompt":"Here are 100 daily observation records from our analytics warehouse, each tagged with a row ID, group name, date, and how many rows are duplicates out of the total. Please generate the record quality audit, exact row deduplication output, and duplicate key report for all of them."}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit flagging data integrity issues across the submitted rows, (2) an exact row deduplication result identifying and removing identical records, and (3) a duplicate key report summarizing which keys appear multiple times — all derived entirely from the supplied data, up to 200 rows per call.","failureModes":["Submitting more than 200 rows returns an error — batch must be split","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) causes validation failure","Malformed date strings not matching YYYY-MM-DD pattern are rejected","Null or out-of-range numeric values for duplicate_rows or total_rows may cause computation errors","Empty rows array (minItems: 1 not met) returns a validation error"],"whenToPreferThis":"Choose this endpoint when you have tabular observation records with explicit duplicate_rows and total_rows counts and need all three analytical outputs — quality audit, deduplication, and key report — in a single low-cost call. It is ideal for batch data quality workflows on up to 200 rows where no external data lookup, ML prediction, or live data source is required. Prefer alternatives if you need real-time deduplication against a live database, fuzzy matching, or more than 200 rows per request.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:47:02.461Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-analytics-record-quality-audit-exact-row-c2bff935"}