{"uid":"cap_GEiCGSS35ngbOWhM8bla_","slug":"commercial-proposal-comparisons-numeric-interval-filter-date-by-9ef9298c","name":"Commercial Proposal Comparisons — Numeric Interval Filter + Date by Category Pivot","description":"Commercial proposal comparisons — Numeric interval filter + Date by category pivot: Numeric interval filter + Date by category pivot for supplied commercial proposal comparisons records (quoted_amount, delivery_days). 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-company-24-133?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","quoted_amount","delivery_days"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"company_group":{"type":"string","default":"","maxLength":80},"delivery_days":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"quoted_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","delivery_days":1,"quoted_amount":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","delivery_days":2,"quoted_amount":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","delivery_days":3,"quoted_amount":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","delivery_days":4,"quoted_amount":30}],"maxItems":200,"minItems":1},"field":{"enum":["quoted_amount","delivery_days"],"type":"string","default":"quoted_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_hXH2XF9n8ZMtYem-5OdfG","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":"Filters commercial proposal rows by a numeric interval on quoted_amount or delivery_days, then pivots dates by company category — two analytical reports from a single uploaded dataset of up to 200 rows.","exampleAgentPrompt":"I have 120 commercial proposal records with row_id, company_group, date, quoted_amount, and delivery_days — can you filter them to only show rows where quoted_amount is between 500 and 5000, and also give me a pivot of dates broken down by company_group?","exampleUseCases":[{"title":"Vendor bid shortlisting by price range","prompt":"Here are 85 supplier proposals with quoted amounts and delivery days — filter them so I only see quotes where quoted_amount is between 1000 and 8000, and also pivot the dates by company group so I can see which vendors submitted when."},{"title":"Delivery time compliance check by supplier","prompt":"I need two reports on my 150 procurement proposal rows: first, flag only the ones where delivery_days falls between 5 and 30, and second, give me a date-by-company_group pivot so I can spot patterns across vendors."},{"title":"Monthly quote analysis per company category","prompt":"Can you run a numeric interval filter on my 60 commercial proposal records — keeping only rows where quoted_amount is between 200 and 2500 — and then pivot the submission dates by company_group so I can compare activity across categories?"}],"resultDescription":"Returns two independent analytical reports: (1) a filtered subset of the supplied rows where the chosen numeric field (quoted_amount or delivery_days) falls within the specified minimum–maximum interval, and (2) a pivot table of dates cross-tabulated by company_group category — all computed locally from the uploaded data with no external lookups.","failureModes":["Fewer than 1 row supplied — minimum item count not met","More than 200 rows supplied — exceeds maxItems limit","Missing required fields (row_id, company_group, date, quoted_amount, delivery_days) on any row","Date field does not match YYYY-MM-DD pattern — validation error","Minimum value greater than maximum value — produces empty filter result with no error","Numeric values outside ±1,000,000,000,000 range — schema rejection","Invalid field enum value (not quoted_amount or delivery_days) — request rejected"],"whenToPreferThis":"Choose this endpoint when you have up to 200 commercial proposal records that you want to analyze locally without any external data enrichment — specifically when you need both a numeric range filter on quoted amounts or delivery days AND a date-by-company-group pivot in a single low-cost call. It is ideal for procurement analysts, sourcing teams, or automated agents comparing vendor bids by price bands and time distribution. Prefer it over generic analytics tools when cost predictability ($0.01 per call for two reports) and schema-enforced input validation matter.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T12:43:03.891Z","isFirstParty":false,"canonicalSlug":"commercial-proposal-comparisons-numeric-interval-filter-date-by-9ef9298c"}