{"uid":"cap_7l8ibYm6XEWH4dZQf1_Rl","slug":"data-reconciliation-record-quality-audit-string-normalisation-5956880a","name":"Data Reconciliation — Record Quality Audit + String Normalisation + Duplicate Key Report","description":"Data reconciliation — Record quality audit + String normalisation + Duplicate key report: Record quality audit + String normalisation + Duplicate key report for supplied data reconciliation records (source_total, target_total). 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-11-192?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}}},"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_osMxGr0BGJEN3jNGwjQTb","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":"Runs three analytical reports (record quality audit, string normalisation, and duplicate key detection) on up to 200 supplied data reconciliation rows comparing source and target totals.","exampleAgentPrompt":"Can you run the three-report reconciliation check on this batch — record quality audit, string normalisation, and duplicate key detection — for these 12 rows where source_total and target_total come from our October billing pipeline (dataset_group 'billing-oct')?","exampleUseCases":[{"title":"ETL pipeline reconciliation audit","prompt":"I've got 50 reconciliation rows from our ETL run for November — each has a row_id, date, dataset_group called 'etl-nov', and source_total vs target_total. Can you run the quality audit, string normalisation, and duplicate key report on them so I can see where the data is broken?"},{"title":"Financial data duplicate detection","prompt":"We're merging two financial datasets and I need to check for duplicate row IDs and record quality issues. Here are 120 rows with source_total and target_total values under dataset_group 'fin-merge-2024' — please give me the quality audit, string normalisation, and duplicate key reports."},{"title":"Dataset group name normalisation check","prompt":"Our dataset_group labels might have inconsistent casing or spacing across these 80 reconciliation records from our warehouse sync. Can you run the string normalisation and record quality audit on them so we can standardise before loading?"}],"resultDescription":"Three independent analytical reports: (1) a record quality audit flagging missing, malformed, or out-of-range values; (2) a string normalisation report identifying and correcting inconsistencies in text fields like dataset_group; and (3) a duplicate key report listing any row_id values that appear more than once across the submitted rows.","failureModes":["More than 200 rows submitted — request rejected with validation error","Missing required fields (row_id, dataset_group, date, source_total, target_total) — row-level validation failure","Date not in YYYY-MM-DD format — schema validation error","Numeric totals outside allowed range (±1,000,000,000,000) — validation rejection","Empty rows array — schema minimum items error","Payment failure or insufficient USDC balance — 402 Payment Required"],"whenToPreferThis":"Choose this endpoint when you need three simultaneous analytical reports (quality audit, string normalisation, and duplicate key detection) on a batch of reconciliation records in a single call. It is ideal for ETL validation workflows, financial reconciliation pipelines, and data migration audits where source and target totals must be compared across up to 200 rows. It does not perform live lookups, predictions, or external actions — use it for offline, supplied-data analysis only.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:43:01.877Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-record-quality-audit-string-normalisation-5956880a"}