{"uid":"cap_Kjo1mLcAu8N9zbZn0YTMD","slug":"data-reconciliation-duplicate-key-report-numeric-row-ordering-af0811c6","name":"Data Reconciliation — Duplicate Key Report + Numeric Row Ordering","description":"Data reconciliation — Duplicate key report + Numeric row ordering: Duplicate key report + Numeric row ordering 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-058?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_cWSuawucIoaxofUEe0svD","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 data reconciliation rows to produce a duplicate key report and a numeric row ordering report for source_total or target_total values.","exampleAgentPrompt":"Can you run a duplicate key report and numeric row ordering on my reconciliation data? Here are the rows: row-1 on 2026-10-01 in group-a with source_total 10 and target_total 1, row-2 on 2026-10-02 in group-b with source_total 20 and target_total 2, and row-3 on 2026-10-01 in group-a with source_total 15 and target_total 3 — use source_total for the ordering.","exampleUseCases":[{"title":"Finance team reconciliation audit","prompt":"I have 50 reconciliation rows from our monthly close — can you check for any duplicate row IDs and also rank them by source_total? The dataset has groups like 'ledger-A' and 'ledger-B' with dates in October 2026."},{"title":"ETL pipeline data quality check","prompt":"After our nightly ETL run I need to verify there are no duplicate keys in the output records and see them ordered by target_total — here are the 120 rows with their row IDs, dates, dataset groups, and both source and target totals."},{"title":"Cross-system data comparison","prompt":"We pulled records from two systems into a reconciliation table — can you find any duplicate row IDs and give me a numeric ordering by source_total so I can spot where the values diverge?"}],"resultDescription":"Returns two independent analytical reports for the supplied rows: (1) a duplicate key report identifying any row_id values that appear more than once across the dataset, and (2) a numeric row ordering report ranking all rows by the chosen field (source_total or target_total). No external data is fetched; all computation is performed locally on the submitted 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","Date values not matching YYYY-MM-DD pattern are rejected","Numeric 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) returns a validation error","Payment of 0.01 USDC required; missing payment results in 402 response"],"whenToPreferThis":"Choose this endpoint when you need two lightweight analytical reports — duplicate key detection and numeric ordering — on a batch of up to 200 reconciliation rows without any external API calls, live data lookups, or ML inference. Ideal for data quality checks during ETL pipelines, financial close reconciliation, or cross-system data comparison workflows where you control the input data and want deterministic, local computation at low cost.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:47:01.473Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-duplicate-key-report-numeric-row-ordering-af0811c6"}