{"uid":"cap_PmQKlulB5WSmjPa8XVpa7","slug":"data-reconciliation-record-quality-audit-and-iqr-outlier-flags-63f98e5b","name":"Data Reconciliation Record Quality Audit and IQR Outlier Flags","description":"Data reconciliation — Record quality audit + IQR outlier flags: Record quality audit + IQR outlier flags for supplied data reconciliation records (source_total, target_total). 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-11-014?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","source_total","target_total"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_total":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"target_total":{"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","source_total":10,"target_total":1,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_total":20,"target_total":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_total":15,"target_total":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_total":30,"target_total":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["source_total","target_total"],"type":"string","default":"source_total"}}},"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_V-i3et5ixUqjs33PrvwhN","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 a record quality audit and IQR-based outlier detection on up to 200 source/target reconciliation row pairs, returning two independent analytical reports.","exampleAgentPrompt":"Can you run a record quality audit and IQR outlier check on my reconciliation data? I have rows with row_id, dataset_group, date, source_total, and target_total fields — here are my 10 rows, and I want to flag outliers on the source_total field.","exampleUseCases":[{"title":"ETL pipeline reconciliation sanity check","prompt":"I just ran my nightly ETL and have 50 reconciliation rows with source_total and target_total values by date and dataset group. Can you audit them for record quality issues and flag any IQR outliers on source_total so I know which rows to investigate before sign-off?"},{"title":"Financial close data quality review","prompt":"We're doing month-end close and I need to quality-check 120 reconciliation records across two groups — 'ledger-a' and 'ledger-b' — comparing source_total to target_total by date. Run the IQR outlier flags on target_total and give me both reports."},{"title":"Data migration validation audit","prompt":"After migrating our database, I want to verify the reconciliation records look clean. I have up to 180 rows with source and target totals per date and group. Can you do the quality audit and IQR outlier detection on source_total so I can catch any suspicious values before we go live?"}],"resultDescription":"Returns two independent analytical reports: (1) a record quality audit identifying issues such as nulls, format errors, or anomalous records across the supplied rows, and (2) IQR-based outlier flags marking which rows contain statistically unusual values in the selected field (source_total or target_total), all computed locally without external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, date, source_total, target_total, dataset_group) cause request rejection","Invalid date format (not YYYY-MM-DD) triggers a schema validation error","Values outside the allowed numeric range (±1,000,000,000,000) are rejected","Empty rows array returns an error","Invalid field enum value (not 'source_total' or 'target_total') causes rejection"],"whenToPreferThis":"Choose this endpoint when you need fast, local statistical quality assessment of reconciliation data — specifically IQR-based outlier detection combined with a record quality audit — without requiring external data lookups, ML predictions, or professional advisory output. Ideal for ETL validation, financial reconciliation checks, and data migration QA on batches up to 200 rows at very low cost ($0.01 per call for two reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:53.310Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-record-quality-audit-and-iqr-outlier-flags-63f98e5b"}