{"uid":"cap_GYNn9c3HeS6MUTBlEjopr","slug":"data-reconciliation-numeric-interval-filter-base-100-series-c4c070b5","name":"Data Reconciliation — Numeric Interval Filter + Base-100 Series","description":"Data reconciliation — Numeric interval filter + Base-100 series: Numeric interval filter + Base-100 series 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-128?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},"base_index":{"type":"integer","default":0,"maximum":199,"minimum":0}}},"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_XY-rznzuVhwFrS3XpW74s","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 (rows within a value range) and a base-100 index series, for up to 200 rows of source/target totals.","exampleAgentPrompt":"Run two reconciliation reports on this dataset — filter rows where source_total is between 0 and 100, and also build a base-100 index series starting from row index 0; here are my rows: row-1 on 2026-10-01 with source_total 10 and target_total 1 in group-a, row-2 on 2026-10-02 with source_total 20 and target_total 2 in group-b.","exampleUseCases":[{"title":"Monthly close source-target range check","prompt":"I have 150 rows of monthly source and target totals for our finance close — can you filter down to only the rows where source_total falls between 5000 and 50000, and also give me a base-100 index series starting from the first row? The field to index is source_total."},{"title":"Budget variance base-100 trend analysis","prompt":"Here are 80 reconciliation records across two budget groups with dates and source/target amounts — index the target_total to base 100 starting at row index 0, and also show me which rows have target_total between -1000 and 1000 so I can spot near-zero variances."},{"title":"Data pipeline reconciliation audit","prompt":"We're auditing our ETL pipeline and I have 200 source vs target rows by date and dataset_group — please filter to rows where source_total is between 100 and 9999 and build a base-100 series on source_total from row index 2 so I can see relative movement."}],"resultDescription":"Returns two independent analytical reports for the supplied reconciliation rows: (1) an interval-filtered list of rows where the chosen field (source_total or target_total) falls within the specified minimum and maximum bounds, and (2) a base-100 index series for the chosen field anchored to the specified base_index row, allowing relative trend comparison. Both reports are computed locally with no external lookups.","failureModes":["Fewer than 1 row or more than 200 rows submitted — request rejected","base_index out of bounds for the provided row count — error returned","Invalid date format (not YYYY-MM-DD) — schema validation failure","source_total or target_total values outside ±1,000,000,000,000 — rejected","Missing required fields (row_id, dataset_group, date, source_total, target_total) — validation error","Payment not provided or insufficient — 402 Payment Required"],"whenToPreferThis":"Choose this endpoint when you need two simultaneous analytical passes — a numeric range filter and a base-100 normalization — on a batch of reconciliation rows (up to 200) without needing live data lookup or external validation. It is ideal for finance, accounting, or ETL audit workflows where you supply your own source/target figures and want fast, local computation of both interval membership and indexed trend series 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:47:05.708Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-numeric-interval-filter-base-100-series-c4c070b5"}