{"uid":"cap_0I6Uv_j4uuNOQCGdHmLHj","slug":"data-reconciliation-duplicate-key-report-adjacent-row-changes-97820ce3","name":"Data Reconciliation — Duplicate Key Report + Adjacent Row Changes","description":"Data reconciliation — Duplicate key report + Adjacent row changes: Duplicate key report + 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-062?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_9O_LiQMkSzsL2E5TqAjqJ","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 up to 200 reconciliation rows to produce two reports: a duplicate key detection report and an adjacent row change analysis for source and target totals.","exampleAgentPrompt":"Can you run a duplicate key report and adjacent row changes analysis on my reconciliation data? I have about 50 rows with row_id, date, dataset_group, source_total, and target_total — I want to check the source_total field for duplicates and sequential shifts.","exampleUseCases":[{"title":"ETL pipeline reconciliation audit","prompt":"I need to audit my ETL pipeline output — here are 120 reconciliation rows with source and target totals grouped by dataset. Can you run both a duplicate key check and an adjacent row changes report on the source_total field so I can see where data is repeating or shifting unexpectedly?"},{"title":"Financial close duplicate key check","prompt":"We're doing our monthly financial close and I need to validate these 80 reconciliation records. Can you scan them for any duplicate row IDs and also show me where consecutive rows have significant changes in target_total?"},{"title":"Data migration consistency check","prompt":"After our data migration, I have 200 rows of source vs target reconciliation data split across two dataset groups. Please run a duplicate key report and an adjacent row changes analysis on the source_total to confirm the migration didn't introduce any repeated keys or unexpected sequential jumps."}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any row_id values that appear more than once within the supplied dataset, and (2) an adjacent row changes report showing value deltas between consecutive rows for the selected field (source_total or target_total), covering up to 200 input rows.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, dataset_group, date, source_total, target_total) cause schema validation failure","Dates not matching YYYY-MM-DD pattern are rejected","row_id values longer than 80 characters are rejected","Numeric values outside ±1,000,000,000,000 are rejected","Submitting fewer than 1 row returns a validation error"],"whenToPreferThis":"Choose this endpoint when you need simultaneous duplicate key detection and row-over-row change analysis on reconciliation data in a single API call. It is ideal for ETL validation, financial close checks, or data migration audits where both data integrity (no duplicate keys) and sequential consistency (no unexpected adjacent changes) matter. It works entirely on supplied data with no external lookups, making it deterministic and privacy-preserving.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:43:37.231Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-duplicate-key-report-adjacent-row-changes-97820ce3"}