{"uid":"cap_AThbPKm2bMkRARNaOQCfs","slug":"validation-rule-results-exact-row-deduplication-numeric-row-ordering-1e7b5c85","name":"Validation Rule Results — Exact Row Deduplication + Numeric Row Ordering","description":"Validation rule results — Exact row deduplication + Numeric row ordering: Exact row deduplication + Numeric row ordering for supplied validation rule results records (passed_rules, total_rules). 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-08-042?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","passed_rules","total_rules"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_rules":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"passed_rules":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_rules":1,"passed_rules":10,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","total_rules":2,"passed_rules":20,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","total_rules":3,"passed_rules":15,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","total_rules":4,"passed_rules":30,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["passed_rules","total_rules"],"type":"string","default":"passed_rules"}}},"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_dk1NPCE7QRwqCI9YV_UC_","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":"Deduplicates exact rows and sorts by numeric value for validation rule result records (passed_rules, total_rules) across up to 200 rows, returning two analytical reports.","exampleAgentPrompt":"I have validation rule results for my datasets — can you deduplicate the exact rows and sort them numerically by passed_rules? Here are 4 records: row-1 on 2026-10-01 in group-a with passed_rules=10 and total_rules=1, row-2 on 2026-10-02 in group-b with passed_rules=20 and total_rules=2, row-3 on 2026-10-03 in group-a with passed_rules=15 and total_rules=3, and row-4 on 2026-10-04 in group-b with passed_rules=30 and total_rules=4.","exampleUseCases":[{"title":"Cleaning duplicate validation audit logs","prompt":"I've got a batch of validation rule audit records for my pipeline and I suspect there are duplicate rows — can you deduplicate them exactly and then give me a numeric ordering report on passed_rules? I have about 50 rows across two dataset groups."},{"title":"Ranking dataset groups by rule compliance","prompt":"Can you sort my validation rule results numerically by total_rules so I can see which dataset groups have the most rules being evaluated? I'll send you around 120 rows with row IDs, dates, dataset group names, and the passed and total rule counts."},{"title":"Preparing clean validation data for reporting","prompt":"Before I hand off my validation results to the reporting team, I need to strip out any exact duplicate rows and get everything ordered by passed_rules numerically — can you run both of those operations on my 80-row validation dataset?"}],"resultDescription":"Two independent analytical reports: (1) an exact row deduplication report identifying and removing identical records from the supplied validation rule results, and (2) a numeric row ordering report sorting records by the selected field (passed_rules or total_rules). Both reports are generated from the supplied data only with no external lookups.","failureModes":["Input array is empty or exceeds 200 rows — rejected with validation error","Row missing required fields (row_id, dataset_group, date, passed_rules, total_rules) — rejected","Date field does not match YYYY-MM-DD pattern — schema validation failure","passed_rules or total_rules values outside allowed numeric range — rejected","Invalid field enum value (not 'passed_rules' or 'total_rules') — rejected","Malformed JSON body — parse error returned"],"whenToPreferThis":"Choose this endpoint when you need to clean and order tabular validation rule result data (passed_rules, total_rules) with up to 200 rows, specifically requiring exact row deduplication and numeric sorting as two bundled reports. It is ideal for data quality pipelines, validation audit preparation, or pre-reporting cleanup where no external data enrichment or prediction is needed — just local analytical operations on supplied data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-11T12:48:40.388Z","isFirstParty":false,"canonicalSlug":"validation-rule-results-exact-row-deduplication-numeric-row-ordering-1e7b5c85"}