{"uid":"cap_jCVdUTuCLDP32JNzlxLtt","slug":"data-reconciliation-daily-sum-series-adjacent-row-changes-789f0ae2","name":"Data Reconciliation: Daily Sum Series + Adjacent Row Changes","description":"Data reconciliation — Daily sum series + Adjacent row changes: Daily sum series + Adjacent row changes 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-137?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_OM98bOXx8rgEniaVEIzA3","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":"Analyzes supplied data reconciliation records to produce two local reports: a daily sum series and adjacent row change analysis, for up to 200 rows.","exampleAgentPrompt":"I have 4 rows of reconciliation data — group-a on 2026-10-01 with source 10 and target 1, group-b on 2026-10-02 with source 20 and target 2, group-a on 2026-10-03 with source 15 and target 3, group-b on 2026-10-04 with source 30 and target 4 — can you run the daily sum series and adjacent row changes reports on the source_total field?","exampleUseCases":[{"title":"ETL pipeline daily variance audit","prompt":"I have 50 rows from our ETL pipeline with dates, dataset groups, and source vs target totals for November — can you run the daily sum series and adjacent row change reports on source_total so I can spot where the pipeline is drifting?"},{"title":"Finance month-end reconciliation check","prompt":"Here are 120 rows of our month-end ledger entries with source_total and target_total per date and cost center — please compute the daily sum series and show me adjacent row changes on target_total so I can identify any reconciliation gaps."},{"title":"Data quality regression after schema change","prompt":"We just migrated our data schema last week and I have 80 before-and-after rows with source and target figures by date and group — run the daily sum series plus adjacent row changes on source_total so I can confirm nothing shifted unexpectedly."}],"resultDescription":"Two independent analytical reports: (1) a daily sum series aggregating source_total or target_total by date and dataset_group, and (2) an adjacent row changes report showing differences between consecutive rows — both computed locally from the supplied data with no external lookups.","failureModes":["More than 200 rows submitted — exceeds maxItems limit, request rejected","Missing required fields (row_id, dataset_group, date, source_total, target_total) — validation error","Invalid date format (not YYYY-MM-DD) — pattern validation failure","Numeric values outside ±1,000,000,000,000 range — schema validation error","Empty rows array — minItems:1 violation"],"whenToPreferThis":"Choose this endpoint when you need two simultaneous analytical views — daily aggregation and row-to-row delta — on reconciliation data you already have locally, without needing external data lookups, predictions, or professional assessments. Ideal for ETL validation, finance reconciliation audits, and data quality checks on datasets up to 200 rows at a very low cost per call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:27.546Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-daily-sum-series-adjacent-row-changes-789f0ae2"}