{"uid":"cap_aIlkfTSGMpA-t7i3auC1I","slug":"validation-rule-results-analytics-record-quality-audit-string-6d974e33","name":"Validation Rule Results Analytics — Record Quality Audit, String Normalisation & Numeric Interval Filter","description":"Validation rule results — Record quality audit + String normalisation + Numeric interval filter: Record quality audit + String normalisation + Numeric interval filter for supplied validation rule results records (passed_rules, total_rules). 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-08-197?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__pkud3Ap516di9UTKphNp","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 three analytical reports on validation rule result records: record quality audit, string normalisation, and numeric interval filtering of passed_rules/total_rules fields.","exampleAgentPrompt":"Can you run a quality audit, string normalisation, and numeric interval filter on my validation rule results? I have rows with dataset_group, date, passed_rules, and total_rules fields — focus on the passed_rules field and filter for values between 0 and 100.","exampleUseCases":[{"title":"Data pipeline rule compliance audit","prompt":"I have a batch of up to 50 validation rule result records from my ETL pipeline — each with a row_id, dataset_group, date, passed_rules, and total_rules. Can you run the full quality audit, normalise the string fields, and filter passed_rules between 5 and 200 to flag anything out of range?"},{"title":"Dataset group string cleaning","prompt":"My validation logs have messy dataset_group strings mixed with passed_rules and total_rules counts. Run string normalisation and a record quality audit on these rows — focus on passed_rules and use a minimum of 0 and maximum of 500."},{"title":"Rule pass rate interval check","prompt":"I need to filter my rule result records to only those where total_rules falls between 10 and 1000 — can you also run the quality audit alongside that? I have about 80 rows with row_id, date, dataset_group, passed_rules, and total_rules."}],"resultDescription":"Returns three independent analytical reports for the supplied rows: (1) a record quality audit flagging completeness and consistency issues, (2) string normalisation output for text fields like dataset_group, and (3) a numeric interval filter report identifying rows where the selected field (passed_rules or total_rules) falls within the specified min/max range. All processing is local with no external lookups.","failureModes":["Fewer than 1 or more than 200 rows submitted — rejected with validation error","Missing required fields (row_id, dataset_group, date, passed_rules, total_rules) on any row — schema validation failure","Date field not matching YYYY-MM-DD pattern — rejected","Minimum value greater than maximum value — may produce empty interval filter results","Null numeric values for passed_rules or total_rules — may affect numeric filter and audit reports","Invalid field enum value (not passed_rules or total_rules) — schema rejection"],"whenToPreferThis":"Choose this endpoint when you need a combined record quality audit, string normalisation, and numeric interval filter on validation rule result data (passed_rules/total_rules) in a single call. It is ideal for batch data quality checks on up to 200 rows without any external API calls or live lookups. Prefer this over generic data tools when you specifically track rule compliance metrics by dataset group and need all three analytical reports at the cost of a single $0.01 USDC call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-11T12:48:41.415Z","isFirstParty":false,"canonicalSlug":"validation-rule-results-analytics-record-quality-audit-string-6d974e33"}