{"uid":"cap_-ATOvExtaziHHZA--30KZ","slug":"supplier-qualification-numeric-interval-filter-date-by-category-pivot-3b9a7411","name":"Supplier Qualification — Numeric Interval Filter + Date by Category Pivot","description":"Supplier qualification — Numeric interval filter + Date by category pivot: Numeric interval filter + Date by category pivot for supplied supplier qualification records (checked_criteria, met_criteria). 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-02-133?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","checked_criteria","met_criteria"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"met_criteria":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"company_group":{"type":"string","default":"","maxLength":80},"checked_criteria":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","met_criteria":1,"company_group":"group-a","checked_criteria":10},{"date":"2026-10-02","row_id":"row-2","met_criteria":2,"company_group":"group-b","checked_criteria":20},{"date":"2026-10-03","row_id":"row-3","met_criteria":3,"company_group":"group-a","checked_criteria":15},{"date":"2026-10-04","row_id":"row-4","met_criteria":4,"company_group":"group-b","checked_criteria":30}],"maxItems":200,"minItems":1},"field":{"enum":["checked_criteria","met_criteria"],"type":"string","default":"checked_criteria"},"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_iDW8q6NMR5603U9R9XTlG","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 supplier qualification rows by a numeric range on checked_criteria or met_criteria, then pivots the filtered data by date and company_group category — returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"Filter my supplier qualification records where checked_criteria is between 10 and 30, then pivot the results by date and company_group — I have 4 rows: row-1 (group-a, 2026-10-01, checked=10, met=1), row-2 (group-b, 2026-10-02, checked=20, met=2), row-3 (group-a, 2026-10-03, checked=15, met=3), row-4 (group-b, 2026-10-04, checked=30, met=4).","exampleUseCases":[{"title":"Qualify vendors within score threshold","prompt":"I have 50 supplier qualification records and want to see only the ones where met_criteria is between 5 and 25, then pivot those results by date and company group so I can see which groups are performing well over time."},{"title":"Audit procurement criteria compliance by period","prompt":"Can you filter our quarterly supplier qualification data — rows with checked_criteria between 0 and 100 — and then give me a date-by-category breakdown so I can report on compliance by supplier group for each week?"},{"title":"Compare qualification pass rates across supplier groups","prompt":"Take these 80 supplier rows and filter for those where checked_criteria falls between 15 and 50, using that as the field to filter on, then pivot the output by date and company_group so procurement can compare group performance."}],"resultDescription":"Two analytical reports based on the submitted supplier qualification rows: (1) a numeric interval filter report showing only the rows where the selected field (checked_criteria or met_criteria) falls within the specified minimum–maximum range, and (2) a date-by-category pivot report that cross-tabulates the filtered results by date and company_group. Both reports are computed locally with no external lookups. Up to 200 input rows are supported per call.","failureModes":["Fewer than 1 row submitted — validation error","More than 200 rows submitted — rejected with max-items error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Numeric values outside ±1,000,000,000,000 range — rejected","Missing required fields (row_id, company_group, date, checked_criteria, met_criteria) — validation error","Field enum value not 'checked_criteria' or 'met_criteria' — rejected","Minimum greater than maximum — may return empty filter result or error","Payment not included or insufficient — x402 payment required response"],"whenToPreferThis":"Choose this endpoint when you have supplier qualification records (with checked_criteria and met_criteria numeric fields) and need both a numeric range filter and a date-by-category pivot in a single low-cost call. It is purpose-built for procurement and vendor qualification analytics on user-supplied data — no external data sources, predictions, or live lookups are involved. Prefer it over generic analytics tools when your data fits the supplier qualification schema and you need exactly these two complementary report types for up to 200 rows at $0.01 USDC.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:16.493Z","isFirstParty":false,"canonicalSlug":"supplier-qualification-numeric-interval-filter-date-by-category-pivot-3b9a7411"}