{"uid":"cap_qXtZh2JjEdz4JTSINbjcB","slug":"public-spending-budgets-numeric-row-ordering-numeric-interval-filter-69250b9d","name":"Public Spending Budgets — Numeric Row Ordering + Numeric Interval Filter","description":"Public spending budgets — Numeric row ordering + Numeric interval filter: Numeric row ordering + Numeric interval filter for supplied public spending budgets records (planned_amount, actual_amount). 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-economics-01-113?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","region","date","planned_amount","actual_amount"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"region":{"type":"string","default":"","maxLength":80},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"actual_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"planned_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","region":"group-a","row_id":"row-1","actual_amount":1,"planned_amount":10},{"date":"2026-10-02","region":"group-b","row_id":"row-2","actual_amount":2,"planned_amount":20},{"date":"2026-10-03","region":"group-a","row_id":"row-3","actual_amount":3,"planned_amount":15},{"date":"2026-10-04","region":"group-b","row_id":"row-4","actual_amount":4,"planned_amount":30}],"maxItems":200,"minItems":1},"field":{"enum":["planned_amount","actual_amount"],"type":"string","default":"planned_amount"},"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_KMWdteXNc7FxC895n33Kr","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":"Sorts and filters public spending budget records by planned or actual amount within a specified numeric interval, returning up to 200 ordered rows across 2 analytical reports.","exampleAgentPrompt":"Sort my public spending budget rows by planned_amount and only show me the ones where planned_amount falls between 5000 and 50000 — here are the records: [{\"row_id\":\"r1\",\"region\":\"north\",\"date\":\"2025-01-15\",\"planned_amount\":12000,\"actual_amount\":11500},{\"row_id\":\"r2\",\"region\":\"south\",\"date\":\"2025-01-15\",\"planned_amount\":3000,\"actual_amount\":2800}].","exampleUseCases":[{"title":"Regional budget overspend identification","prompt":"I have 80 budget rows across regions for Q1 2025. Can you filter and rank them by actual_amount, keeping only the rows where actual_amount is between 10000 and 500000, so I can see which regions are spending the most within that band?"},{"title":"Planned expenditure threshold audit","prompt":"Here are our department budget records for fiscal year 2024 — filter them to only show entries where planned_amount is between 0 and 75000, and order them numerically so I can audit which line items fall under our mid-tier spending threshold."},{"title":"Comparative budget ranking by field","prompt":"I need to rank these 150 public procurement budget rows by planned_amount descending, but only include rows where planned_amount is between 25000 and 200000 — can you run two reports on this dataset for me?"}],"resultDescription":"Returns up to 2 analytical reports per call covering: (1) numerically ordered budget rows ranked by the selected field (planned_amount or actual_amount), and (2) rows filtered to only those where the selected field falls within the specified minimum–maximum numeric interval. Each report covers up to 200 input rows and is computed locally without external data lookups.","failureModes":["Rows array empty or missing — API returns validation error","More than 200 rows submitted — exceeds maxItems limit","planned_amount or actual_amount outside ±1,000,000,000,000 — rejected by schema","Date field not in YYYY-MM-DD format — pattern validation failure","minimum greater than maximum — may return empty filtered result set","row_id missing or empty string — required field validation error","Payment of 0.01 USDC not completed — 402 Payment Required response"],"whenToPreferThis":"Choose this endpoint when you need to both rank and range-filter public spending budget records (planned_amount or actual_amount) in a single call, receiving two coordinated analytical reports. It is purpose-built for fiscal/budget data with region and date dimensions, is fully offline (no external lookups), and is cost-effective at $0.01 USDC for up to 200 rows and 2 reports. Prefer it over general-purpose data tools when your data conforms to the budget row schema and you need deterministic, reproducible numeric sorting and interval filtering.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-19T12:37:51.862Z","isFirstParty":false,"canonicalSlug":"public-spending-budgets-numeric-row-ordering-numeric-interval-filter-69250b9d"}