{"uid":"cap_WMTaTf3nEIGgizrPpAJan","slug":"data-reconciliation-exact-row-deduplication-daily-sum-series-300bdf6f","name":"Data Reconciliation — Exact Row Deduplication + Daily Sum Series","description":"Data reconciliation — Exact row deduplication + Daily sum series: Exact row deduplication + Daily sum series 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-044?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_VYtjEQfk4Ou51Mr9pbLFY","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 exact row deduplication and daily sum series analysis on up to 200 supplied data reconciliation records comparing source_total and target_total values.","exampleAgentPrompt":"Reconcile these rows for me — run exact deduplication and a daily sum series on my source_total and target_total data: I have 4 rows from 2026-10-01 to 2026-10-04 across groups group-a and group-b, and I want both reports for the source_total field.","exampleUseCases":[{"title":"ETL pipeline reconciliation check","prompt":"I've got 150 rows from my nightly ETL job with source_total and target_total values across multiple dataset groups and dates from 2026-09-01 to 2026-09-30 — can you deduplicate them exactly and give me a daily sum series for source_total so I can spot where the pipeline diverges?"},{"title":"Finance ledger duplicate audit","prompt":"Run an exact row deduplication report on my finance ledger reconciliation data — I have about 80 rows with row IDs, dates, and source vs target totals across two groups, and I also need the daily sum series for target_total to check closing balances."},{"title":"Data warehouse source-target validation","prompt":"I need to validate my data warehouse load — here are 200 reconciliation records with source_total and target_total by date and dataset group. Please deduplicate exact duplicate rows and produce a daily sum series on source_total so I can confirm the ingestion was clean."}],"resultDescription":"Returns two analytical reports computed locally: (1) an exact row deduplication report identifying and removing identical rows from the supplied dataset, and (2) a daily sum series aggregating the selected field (source_total or target_total) by date across the provided records. Both reports are based solely on the supplied input data with no external lookups.","failureModes":["Exceeding 200 rows causes a validation rejection","Missing required fields (row_id, dataset_group, date, source_total, target_total) cause schema validation errors","Malformed date strings not matching YYYY-MM-DD pattern are rejected","Numeric values outside the ±1,000,000,000,000 range cause validation errors","Empty rows array (minItems:1 violated) returns an error","Invalid field enum value (not 'source_total' or 'target_total') is rejected"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and a daily sum time series on user-supplied reconciliation data in a single low-cost call. It is ideal for ETL validation, finance reconciliation audits, and data warehouse checks where you already have the data and need offline analytics without any live lookups or external data enrichment. At $0.01 USDC for two reports on up to 200 rows, it is cost-effective for batch reconciliation tasks embedded in automated pipelines.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:53.037Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-exact-row-deduplication-daily-sum-series-300bdf6f"}