{"uid":"cap_bCAhQ1Qwh-RzWneof5eYQ","slug":"data-reconciliation-exact-row-deduplication-adjacent-row-changes-92161650","name":"Data Reconciliation — Exact Row Deduplication + Adjacent Row Changes","description":"Data reconciliation — Exact row deduplication + Adjacent row changes: Exact row deduplication + 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-046?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_L9Y0oZgUBRsBUS71ShNJE","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 adjacent row change analysis on up to 200 data reconciliation records comparing source_total and target_total values, returning two independent analytical reports.","exampleAgentPrompt":"Can you run exact row deduplication and adjacent row change analysis on my reconciliation data? I have rows with row_id, date, dataset_group, source_total, and target_total — up to 50 rows — and I want both reports using source_total as the field.","exampleUseCases":[{"title":"Finance ETL daily reconciliation check","prompt":"I need to reconcile my daily finance pipeline — here are 80 rows with row_id, date, dataset_group, source_total, and target_total. Can you deduplicate exact rows and show me where target_total changed between adjacent rows?"},{"title":"Detecting duplicate records in a data warehouse load","prompt":"We just loaded data into our warehouse and I'm worried there are duplicate rows. Can you run exact row deduplication on these 120 reconciliation records using source_total and also flag any adjacent row changes?"},{"title":"Audit trail for source vs target discrepancies","prompt":"I have 60 rows of source and target totals across several dataset groups and dates. Please run both the deduplication report and the adjacent row changes report on them so I can see where values shifted or repeated."}],"resultDescription":"Two independent analytical reports: (1) an exact row deduplication report identifying repeated rows in the supplied dataset, and (2) an adjacent row changes report highlighting differences between consecutive rows for the selected field (source_total or target_total), covering up to 200 rows.","failureModes":["More than 200 rows submitted — exceeds maxItems limit","Missing required fields (row_id, date, dataset_group, source_total, target_total) cause validation failure","Invalid date format (must match YYYY-MM-DD pattern)","Numeric values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000) rejected","Empty rows array (minItems: 1 required)","Invalid field enum value — must be 'source_total' or 'target_total'"],"whenToPreferThis":"Choose this endpoint when you need two specific local analytical operations — exact row deduplication and adjacent row change detection — on reconciliation data (source_total vs target_total) in a single low-cost call. Ideal for ETL validation, data warehouse audits, or financial reconciliation pipelines where you want to spot duplicate records and consecutive value shifts without any external lookups or predictions. Prefer this over general-purpose analytics tools when working with structured tabular reconciliation records up to 200 rows and needing a fast, deterministic, offline computation.","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-adjacent-row-changes-92161650"}