{"uid":"cap_zpTKnZiR9NIQgIS4U6UdN","slug":"replenishment-timing-numeric-interval-filter-date-by-category-pivot-0b265a92","name":"Replenishment Timing Numeric Interval Filter + Date by Category Pivot","description":"Replenishment timing — Numeric interval filter + Date by category pivot: Numeric interval filter + Date by category pivot for supplied replenishment timing records (lead_days, received_units). 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-retail-12-133?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","store_group","date","lead_days","received_units"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"lead_days":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"store_group":{"type":"string","default":"","maxLength":80},"received_units":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","lead_days":10,"store_group":"group-a","received_units":1},{"date":"2026-10-02","row_id":"row-2","lead_days":20,"store_group":"group-b","received_units":2},{"date":"2026-10-03","row_id":"row-3","lead_days":15,"store_group":"group-a","received_units":3},{"date":"2026-10-04","row_id":"row-4","lead_days":30,"store_group":"group-b","received_units":4}],"maxItems":200,"minItems":1},"field":{"enum":["lead_days","received_units"],"type":"string","default":"lead_days"},"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_R21_PlsmSRPf5RYgmhk7P","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":"Applies a numeric interval filter and a date-by-category pivot analysis to supplied replenishment timing records (lead_days, received_units) for up to 200 rows.","exampleAgentPrompt":"I have 150 replenishment timing records with lead_days and received_units — can you filter them to only show rows where lead_days is between 5 and 30, and also give me a date-by-category pivot grouped by store_group?","exampleUseCases":[{"title":"Lead time outlier identification","prompt":"Here are 120 replenishment records across store groups A, B, and C — filter them to only keep rows where lead_days is between 0 and 14, and also pivot received_units by store_group and date so I can see which groups are getting stock fastest."},{"title":"Slow replenishment store audit","prompt":"I need to audit these 80 replenishment timing entries — filter for records where received_units is between 50 and 500, and generate a date-by-category pivot on store_group so I can spot which locations have sluggish restock patterns."},{"title":"Replenishment planning summary","prompt":"Can you run two reports on these 200 replenishment rows: first filter to lead_days between 10 and 60, and second pivot the data by store_group and date so I can plan next quarter's reorder schedule?"}],"resultDescription":"Returns two analytical reports: (1) a numeric interval filter result showing replenishment rows where the selected field (lead_days or received_units) falls within the specified minimum-maximum range, and (2) a date-by-category pivot table aggregating the replenishment data by store_group and date. Both reports are computed from the supplied rows with no external data lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Invalid date format (must be YYYY-MM-DD) causes row rejection","Minimum greater than maximum produces empty filter result","Missing required fields (row_id, store_group, date, lead_days, received_units) causes validation error","Numeric values outside ±1,000,000,000,000 bounds rejected","Empty rows array returns error"],"whenToPreferThis":"Choose this endpoint when you have up to 200 replenishment timing records and need both a numeric range filter (on lead_days or received_units) and a date-by-category pivot in a single low-cost call. Ideal for retail or supply chain workflows that need quick offline analytical summaries without external API dependencies or live data lookups. Best when you already have the data locally and need structured analytical outputs cheaply ($0.01 USDC for both reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-31T00:43:14.547Z","isFirstParty":false,"canonicalSlug":"replenishment-timing-numeric-interval-filter-date-by-category-pivot-0b265a92"}