{"uid":"cap_msL_2dZ_IQjXuN4RmcBTU","slug":"schema-conformity-record-quality-audit-missing-value-fill-1168fa80","name":"Schema Conformity — Record Quality Audit + Missing-Value Fill","description":"Schema conformity — Record quality audit + Explicit missing-value fill: Record quality audit + Explicit missing-value fill for supplied schema conformity records (valid_records, checked_records). 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-02-019?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","valid_records","checked_records"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"dataset_group":{"type":"string","default":"","maxLength":80},"valid_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"checked_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","valid_records":10,"checked_records":1},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","valid_records":20,"checked_records":2},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","valid_records":15,"checked_records":3},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","valid_records":30,"checked_records":4}],"maxItems":200,"minItems":1},"field":{"enum":["valid_records","checked_records"],"type":"string","default":"valid_records"},"method":{"enum":["zero","mean","median"],"type":"string","default":"median"}}},"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_ef4vp8xgsV78-PlkkanP0","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":"Audits data quality of schema conformity records (valid_records, checked_records) and fills missing values using zero, mean, or median imputation — two independent reports for up to 200 rows.","exampleAgentPrompt":"Audit the quality of my schema conformity records and fill any missing values in the valid_records column using median imputation — I have 4 rows: row-1 for group-a on 2026-10-01 with valid_records=10, checked_records=1; row-2 for group-b on 2026-10-02 with valid_records=20, checked_records=null; row-3 for group-a on 2026-10-03 with valid_records=null, checked_records=3; row-4 for group-b on 2026-10-04 with valid_records=30, checked_records=4.","exampleUseCases":[{"title":"ETL pipeline conformity gap detection","prompt":"I just pulled my nightly ETL run results — can you audit these 50 schema conformity rows for data quality issues and fill any missing valid_records values using the mean? Here are the rows with row_id, dataset_group, date, valid_records, and checked_records."},{"title":"Median imputation for checked_records nulls","prompt":"My dataset has about 80 conformity tracking rows and several checked_records values are null. Run a quality audit and fill those gaps using median imputation so I can proceed with my analysis."},{"title":"Zero-fill missing conformity counts by group","prompt":"I have conformity records across two dataset groups spanning three months — some valid_records entries are missing. Audit the record quality and backfill all nulls with zero so my downstream reporting stays consistent."}],"resultDescription":"Returns two independent analytical reports: (1) a record quality audit identifying problematic, missing, or out-of-range values across the submitted rows, and (2) a missing-value fill report showing the original and imputed values for the chosen field (valid_records or checked_records) using the selected method (zero, mean, or median). Results are computed locally with no external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, date, dataset_group) causes row rejection","Invalid date format (not YYYY-MM-DD) triggers a pattern validation error","Values outside ±1,000,000,000,000 are rejected by schema","Invalid method enum value (not zero/mean/median) causes a bad request error","Empty rows array (minItems:1 violated) returns an error"],"whenToPreferThis":"Choose this endpoint when you need both a data quality audit and missing-value imputation for schema conformity metrics (valid_records, checked_records) in a single low-cost call. It is ideal for batch offline analysis of up to 200 rows where no live data fetching, machine learning prediction, or external enrichment is needed. Prefer it over general-purpose data tools when you specifically track schema validation pass rates and need reproducible, locally computed imputation.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T00:46:47.662Z","isFirstParty":false,"canonicalSlug":"schema-conformity-record-quality-audit-missing-value-fill-1168fa80"}