{"uid":"cap_9IoCJAH-qqMyQxB4NFvgN","slug":"validation-rule-results-numeric-row-ordering-numeric-interval-filter-63d9f1e7","name":"Validation Rule Results — Numeric Row Ordering + Numeric Interval Filter","description":"Validation rule results — Numeric row ordering + Numeric interval filter: Numeric row ordering + Numeric interval filter 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-113?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"},"maximum":{"type":"number","default":100,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":0,"maximum":1000000000000,"minimum":-1000000000000}}},"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_adJrW03v7xIDdexrdbyGT","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":"Applies numeric row ordering and numeric interval filtering to user-supplied validation rule results data (passed_rules, total_rules), returning up to 2 analytical reports for up to 200 rows.","exampleAgentPrompt":"Sort my validation rule results by passed_rules and filter to only rows where passed_rules is between 5 and 50 — here are the rows: row-1 (group-a, 2026-10-01, passed=10, total=20), row-2 (group-b, 2026-10-02, passed=45, total=60), row-3 (group-a, 2026-10-03, passed=3, total=10).","exampleUseCases":[{"title":"Identify passing dataset groups within a threshold","prompt":"Take these validation results and give me an ordered list of rows where passed_rules is between 20 and 80 — rows are: row-1 (group-alpha, 2025-01-01, passed=25, total=100), row-2 (group-beta, 2025-01-02, passed=15, total=100), row-3 (group-gamma, 2025-01-03, passed=75, total=100)."},{"title":"Rank validation batches by total rules","prompt":"Sort these validation records from highest to lowest by total_rules and show me which ones fall between 50 and 200 total rules — here's my data: row-1 (teamA, 2025-03-01, passed=30, total=120), row-2 (teamB, 2025-03-02, passed=60, total=180), row-3 (teamC, 2025-03-03, passed=10, total=40)."},{"title":"Quality gate check on rule pass rates","prompt":"I have a set of daily validation results across two dataset groups and I need them ordered by passed_rules with only the rows where passed_rules is between 100 and 500 kept — datasets: row-1 (pipeline-A, 2025-06-01, passed=120, total=300), row-2 (pipeline-B, 2025-06-02, passed=450, total=600), row-3 (pipeline-C, 2025-06-03, passed=80, total=200)."}],"resultDescription":"Returns up to 2 analytical reports: one with rows numerically ordered by the selected field (passed_rules or total_rules), and one with rows filtered to only those within the specified minimum–maximum interval. Each report covers the supplied dataset of up to 200 rows.","failureModes":["Fewer than 1 row provided — validation error","More than 200 rows submitted — request rejected","Invalid date format (not YYYY-MM-DD) — schema validation failure","minimum greater than maximum — may return empty interval filter result","Null values in passed_rules or total_rules — rows may be excluded from numeric ordering"],"whenToPreferThis":"Choose this endpoint when you have preloaded validation rule result data (passed_rules, total_rules) that you want to rank numerically or filter to a specific numeric interval, without any need for live data lookup or external integration. It is ideal for offline data quality analysis pipelines or batch reporting workflows where two analytical views (ordered + interval-filtered) are needed in a single call at minimal cost.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-12T12:51:37.105Z","isFirstParty":false,"canonicalSlug":"validation-rule-results-numeric-row-ordering-numeric-interval-filter-63d9f1e7"}