{"uid":"cap_2jPU8FRNvglpNaE2clqm8","slug":"data-reconciliation-numeric-interval-filter-keyed-dataset-comparison-9c861fc0","name":"Data Reconciliation — Numeric Interval Filter + Keyed Dataset Comparison","description":"Data reconciliation — Numeric interval filter + Keyed dataset comparison: Numeric interval filter + Keyed dataset comparison 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-134?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"},"other":{"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":21,"target_total":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_total":17,"target_total":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_total":33,"target_total":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":0},"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_yXNTRaWSofoASjGUQ7m3w","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":"Runs two analytical reports on supplied reconciliation data: a numeric interval filter on a chosen field and a keyed comparison between two datasets, for up to 200 rows.","exampleAgentPrompt":"Can you run a numeric interval filter on the source_total field and compare these two reconciliation datasets row by row? Here are my records — rows with row_id, dataset_group, date, source_total, and target_total — up to 50 rows each in the 'rows' and 'other' arrays.","exampleUseCases":[{"title":"Finance team month-end reconciliation check","prompt":"I have two sets of accounting records for October — a source dataset and a target dataset, each with up to 80 rows keyed by transaction ID, group, and date. Can you filter the source_total values by numeric interval and compare them against the target dataset row by row to find any discrepancies?"},{"title":"ETL pipeline output validation","prompt":"After running our ETL pipeline I have the original source totals and the transformed target totals for 120 rows. Can you do a numeric interval filter on source_total and a keyed comparison between the two datasets so I can see where values diverged?"},{"title":"Sales data cross-system audit","prompt":"We pulled sales figures from two different systems for the same date range — source_total from system A and target_total from system B, grouped by region. Can you filter by numeric interval and compare the two datasets side by side to flag any rows that don't match?"}],"resultDescription":"Returns two independent analytical reports: (1) a numeric interval filter report identifying which rows from the supplied dataset fall within specified numeric ranges for the chosen field, and (2) a keyed dataset comparison report highlighting matches, mismatches, and differences between the 'rows' and 'other' datasets joined on row_id, dataset_group, and date. No external lookups or predictions are made — all analysis is performed locally on the supplied data.","failureModes":["More than 200 rows submitted — request rejected with validation error","Missing required fields (row_id, dataset_group, date, source_total, target_total) — row-level validation failure","Date strings not matching YYYY-MM-DD pattern — schema validation error","Numeric values outside the allowed range (±1,000,000,000,000) — validation error","Empty rows array — minItems violation","Payment not included or insufficient — 402 payment required response"],"whenToPreferThis":"Choose this endpoint when you need to both filter records by numeric range and compare two keyed datasets in a single API call, particularly for reconciliation workflows involving source vs. target totals. It is ideal for batch reconciliation of up to 200 rows where you need two complementary analytical views without external data access. Prefer this over single-report endpoints when your workflow requires both interval filtering and cross-dataset key matching in one operation.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:55.598Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-numeric-interval-filter-keyed-dataset-comparison-9c861fc0"}