{"uid":"cap_kwsBk7GrWLWxpK9lAoG-k","slug":"data-reconciliation-record-quality-audit-numeric-row-ordering-218ab886","name":"Data Reconciliation — Record Quality Audit + Numeric Row Ordering","description":"Data reconciliation — Record quality audit + Numeric row ordering: Record quality audit + Numeric row ordering 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-007?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_n4l5QscKCzp1ypexqBcCS","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 dual-report analysis on reconciliation data rows: audits record quality and orders rows numerically for up to 200 source/target total pairs.","exampleAgentPrompt":"Can you run a record quality audit and numeric row ordering on my reconciliation data? I have 12 rows across two dataset groups — 'ledger-A' and 'ledger-B' — with dates from 2026-01-01 to 2026-01-12, and I want to analyze the source_total field.","exampleUseCases":[{"title":"Monthly ledger reconciliation audit","prompt":"I have 50 reconciliation rows from our monthly ledger close — each row has a row_id, date, dataset_group, source_total, and target_total. Can you run a record quality audit and numeric ordering on the source_total field and tell me which rows have issues?"},{"title":"ETL pipeline data validation","prompt":"After our ETL run, I need to validate 120 rows of source vs target totals across three dataset groups — 'orders', 'returns', and 'adjustments' — covering dates in October 2026. Can you audit the record quality and order the rows numerically by target_total?"},{"title":"Cross-system data integrity check","prompt":"We're reconciling data between two payment systems and I have 30 rows with source_total and target_total for dataset group 'payments-2026'. Can you give me a quality audit report and numeric ordering for the source_total column so I can see where the gaps are?"}],"resultDescription":"Returns two independent analytical reports for the submitted reconciliation rows: (1) a record quality audit identifying missing, null, or malformed values across fields, and (2) a numeric row ordering report ranking rows by the selected field (source_total or target_total). Both reports are computed locally with no external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, dataset_group, date, source_total, target_total) causes schema rejection","Invalid date format (non-YYYY-MM-DD) fails pattern validation","Numeric values outside ±1,000,000,000,000 are rejected","Invalid field enum value (not source_total or target_total) causes error","Empty rows array (minItems:1 violation) returns error"],"whenToPreferThis":"Choose this endpoint when you need to locally audit data quality and produce ordered row rankings for reconciliation datasets of up to 200 rows without any external data lookup, prediction, or professional assessment. Ideal for ETL validation, financial reconciliation checks, and dataset integrity reviews where only source_total and target_total comparisons are needed and a bundled dual-report output at low cost is desirable.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:59.741Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-record-quality-audit-numeric-row-ordering-218ab886"}