{"uid":"cap_5Dbu867Flo2YMJywhNVat","slug":"data-reconciliation-exact-row-deduplication-numeric-row-ordering-9b071eda","name":"Data Reconciliation — Exact Row Deduplication + Numeric Row Ordering","description":"Data reconciliation — Exact row deduplication + Numeric row ordering: Exact row deduplication + 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-042?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_GUOfcUtiWhBplSj27eDoM","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":"Deduplicates rows exactly and orders them numerically for source/target reconciliation data, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"I have a set of reconciliation records with source_total and target_total fields — can you deduplicate the exact duplicate rows and then sort them numerically by source_total? Here are my rows: row-1 (2024-01-01, group-a, source=1000, target=950), row-2 (2024-01-02, group-a, source=2000, target=1980), row-3 (duplicate of row-1, group-a, source=1000, target=950).","exampleUseCases":[{"title":"Finance team daily ledger deduplication","prompt":"We pulled today's ledger entries from both our source system and target system — there are likely duplicate rows. Can you deduplicate the exact matches and then sort the remaining rows numerically by source_total? I have about 80 rows across two groups, dated 2024-03-15."},{"title":"Month-end reconciliation audit prep","prompt":"Before I hand this reconciliation file off for audit, I need to strip out any exact duplicate rows and get everything ordered numerically by target_total. There are 150 rows covering groups A and B for March 2024 — can you run those two reports for me?"},{"title":"Data pipeline QA between source and target","prompt":"Our ETL pipeline produced a reconciliation dataset for 2024-06-01 with source_total and target_total for about 60 rows in dataset group 'pipeline-v2'. Can you deduplicate any exact repeated rows and give me a numerically ordered view so I can spot anomalies?"}],"resultDescription":"Returns two analytical reports: one showing the dataset after exact duplicate rows have been removed, and one showing the rows sorted in numeric order by the specified field (source_total or target_total). Reports cover up to 200 input rows and are generated using local analytical engines with no external lookups.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Missing required fields (row_id, date, dataset_group, source_total, target_total) cause validation errors","Malformed date strings (not YYYY-MM-DD format) cause schema validation failure","Numeric values outside ±1,000,000,000,000 range are rejected","Empty rows array (minItems: 1 not met) causes validation failure"],"whenToPreferThis":"Choose this endpoint when you need a lightweight, low-cost ($0.01 USDC) batch operation to both deduplicate exact duplicate reconciliation rows and produce a numerically ordered view of the same data in a single call. It is ideal for data quality prep steps in financial or operational reconciliation workflows involving up to 200 rows, when no live data lookup, prediction, or external system action is required.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:57.138Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-exact-row-deduplication-numeric-row-ordering-9b071eda"}