{"uid":"cap_81HO2dD1InPyfVOkpsOYV","slug":"data-reconciliation-exact-row-deduplication-numeric-interval-filter-7c85c05e","name":"Data Reconciliation — Exact Row Deduplication + Numeric Interval Filter","description":"Data reconciliation — Exact row deduplication + Numeric interval filter: Exact row deduplication + Numeric interval filter 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-043?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"},"maximum":{"type":"number","default":100,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":0,"maximum":1000000000000,"minimum":-1000000000000}}},"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_lys0Z1CrW-GSkCJPXG2mw","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 filters records by a numeric interval for source/target reconciliation datasets of up to 200 rows, returning two analytical reports.","exampleAgentPrompt":"Deduplicate my reconciliation rows exactly and filter source_total between 10 and 500 — here are my records: row-1, group-a, 2026-10-01, source 10, target 1; row-2, group-b, 2026-10-02, source 20, target 2; row-1, group-a, 2026-10-01, source 10, target 1 (duplicate). Give me both the deduplication report and the interval filter report.","exampleUseCases":[{"title":"Financial ledger source-target mismatch cleanup","prompt":"I have 150 reconciliation rows comparing source_total and target_total across two ledgers. Can you deduplicate them exactly and then show me only the rows where source_total falls between 100 and 50000? Use field source_total, minimum 100, maximum 50000."},{"title":"ETL pipeline data quality check","prompt":"After our nightly ETL run I have a dataset with potential duplicate rows and I need to see which target_total values fall in the range -500 to 500 — run exact deduplication and the interval filter on target_total for these 80 records."},{"title":"Reconciliation audit for grouped datasets","prompt":"We have reconciliation records split across group-a and group-b from October 2026. Deduplicate the rows exactly and filter to only source_total values between 0 and 30 so I can audit the low-value discrepancies. Here are up to 200 rows."}],"resultDescription":"Returns two analytical reports: (1) a deduplicated dataset with exact duplicate rows removed, and (2) a subset of rows where the chosen field (source_total or target_total) falls within the specified numeric interval [minimum, maximum]. Both reports operate on the supplied rows without any live lookups or external data.","failureModes":["More than 200 rows submitted — exceeds maxItems limit, request rejected","Invalid date format (not YYYY-MM-DD) — schema validation error","source_total or target_total outside ±1,000,000,000,000 — schema validation error","minimum greater than maximum — may produce empty interval-filter result","Missing required fields (row_id, dataset_group, date, source_total, target_total) — validation error","Payment not included or insufficient USDC — x402 payment required error"],"whenToPreferThis":"Choose this endpoint when you need two simultaneous local analytical operations on a reconciliation dataset — exact row deduplication and numeric interval filtering — without any external lookups, predictions, or professional assessments. It is ideal for data quality pipelines, ETL validation steps, and financial reconciliation audits on datasets up to 200 rows where you want both reports in a single $0.01 call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:58.246Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-exact-row-deduplication-numeric-interval-filter-7c85c05e"}