{"uid":"cap_WDCWpHT9Pyar3KXFcFVyN","slug":"data-reconciliation-analytics-record-quality-audit-exact-row-20b13019","name":"Data Reconciliation Analytics — Record Quality Audit, Exact Row Deduplication & Daily Sum Series","description":"Data reconciliation — Record quality audit + Exact row deduplication + Daily sum series: Record quality audit + Exact row deduplication + Daily sum series 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-215?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_9oKbIUx7GDz9iZLGRp2j-","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 independent analytical reports (record quality audit, exact row deduplication, and daily sum series) on supplied source/target reconciliation data for up to 200 rows.","exampleAgentPrompt":"Can you run a full data reconciliation analysis on my records — quality audit, exact duplicate detection, and daily sum series for the source_total field? Here are my rows: row-1 on 2025-01-01 in group-a with source 1000 and target 990, row-2 on 2025-01-02 in group-b with source 2000 and target 2000, row-3 on 2025-01-01 in group-a with source 1000 and target 990 (duplicate of row-1).","exampleUseCases":[{"title":"Financial pipeline daily reconciliation check","prompt":"I've got 150 rows of daily financial reconciliation data with source_total and target_total values across two groups — run the quality audit, find any exact duplicate rows, and give me the daily sum series for source_total so I can spot where the pipeline is drifting."},{"title":"ETL validation before production deploy","prompt":"Before we push this ETL run to production, can you audit the record quality, deduplicate any exact repeated rows, and show me the daily aggregated totals for target_total across these 80 reconciliation records I'm sending?"},{"title":"Monthly billing data discrepancy investigation","prompt":"We're seeing discrepancies in our monthly billing data — please run a quality audit and deduplication check on these reconciliation rows across billing groups, and also generate the daily sum series for source_total so we can trace where the numbers diverge."}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit flagging data issues in the supplied rows, (2) an exact row deduplication report identifying repeated records, and (3) a daily sum series aggregating the selected field (source_total or target_total) by date. All computed locally on the submitted data with no external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, date, dataset_group, source_total, target_total) cause schema rejection","Dates not matching YYYY-MM-DD pattern are rejected","source_total or target_total values outside ±1,000,000,000,000 are rejected","Empty rows array (minItems:1 violated) returns an error","Invalid field enum value (not source_total or target_total) causes rejection"],"whenToPreferThis":"Choose this endpoint when you need three reconciliation-focused analytical reports in a single call at minimal cost ($0.01 USDC): record quality auditing, exact duplicate detection, and daily sum aggregation. It is ideal for ETL validation, financial reconciliation pipelines, and data quality checks on datasets up to 200 rows where no external data enrichment or prediction is needed — everything is computed from your supplied rows only.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T00:54:15.468Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-analytics-record-quality-audit-exact-row-20b13019"}