{"uid":"cap_QNtbkYCbxmlVDQ2YBWFH6","slug":"data-validation-results-exact-row-deduplication-1b10b2b4","name":"Data Validation Results – Exact Row Deduplication","description":"Data validation results - Exact row deduplication: Exact row deduplication for Data validation results. Up to 200 supplied typed records. Local descriptive analytics; no enrichment or forecast. One of 25 new profiles across 20 shared operations in this industry. 0.01 USDC includes one bounded exact row deduplication report.","url":"https://market.datapackvibe.com/x402/assistant-ar-analytics-validation-results-deduplicate?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","rule","date","checked_records","failed_records"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"rule":{"type":"string","default":"","maxLength":80},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"failed_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"checked_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","rule":"group-a","row_id":"row-1","failed_records":1,"checked_records":10},{"date":"2026-10-02","rule":"group-b","row_id":"row-2","failed_records":2,"checked_records":20},{"date":"2026-10-03","rule":"group-a","row_id":"row-3","failed_records":3,"checked_records":15},{"date":"2026-10-04","rule":"group-b","row_id":"row-4","failed_records":4,"checked_records":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_McKzNrcpOQSSAWnL5_ziQ","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":"Removes exact duplicate rows from a batch of data validation result records and returns a deduplicated report.","exampleAgentPrompt":"I have up to 200 data validation result rows — each with a row ID, rule name, date, checked record count, and failed record count — and I want you to deduplicate them so I'm only left with unique rows, removing any that are exactly the same.","exampleUseCases":[{"title":"Clean validation pipeline before reporting","prompt":"I'm about to generate a weekly data quality report but I think my pipeline logged some duplicate validation rule entries — can you deduplicate these rows for me? Each row has a rule name, a date like 2024-03-15, a row ID, and counts for checked and failed records."},{"title":"Remove repeated rows from QA audit log","prompt":"Our QA audit exported 150 validation result rows but I suspect there are exact duplicates in there. Can you run exact row deduplication on them so I only keep unique entries? Fields are row_id, rule, date, checked_records, and failed_records."},{"title":"Deduplicate before data quality dashboard load","prompt":"Before I load these validation results into our dashboard, I need to strip out any exactly repeated rows. I've got about 80 records with fields for row ID, rule, date, and checked vs failed record counts — can you deduplicate them?"}],"resultDescription":"A bounded report containing the deduplicated set of validation result rows, with exact duplicate rows removed. The response identifies unique records across the submitted batch of up to 200 typed rows (each with row_id, rule, date, checked_records, failed_records), providing local descriptive analytics with no enrichment or forecasting.","failureModes":["Fewer than 1 row submitted — validation error returned","More than 200 rows submitted — request rejected with schema violation","Invalid date format (not YYYY-MM-DD) — pattern validation failure","Missing required fields (row_id, rule, date, checked_records, failed_records) — schema error","Numeric values out of allowed range (±1,000,000,000,000) — schema rejection","Payment not included or insufficient — 402 Payment Required response"],"whenToPreferThis":"Choose this endpoint when you have a batch of up to 200 data validation result records (with rule, date, checked/failed counts) and need to remove exact duplicate rows before analysis, reporting, or dashboard ingestion. It is a lightweight, bounded, local deduplication operation with no external enrichment — ideal for quick data cleaning steps in a validation pipeline. Prefer this over general-purpose deduplication tools when your data specifically follows the data-validation-results schema.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-21T00:52:23.539Z","isFirstParty":false,"canonicalSlug":"data-validation-results-exact-row-deduplication-1b10b2b4"}