{"uid":"cap_qaoJVa9HqxM35oeEjHr87","slug":"company-filing-inventories-numeric-interval-filter-date-by-category-9bb115b7","name":"Company Filing Inventories — Numeric Interval Filter + Date by Category Pivot","description":"Company filing inventories — Numeric interval filter + Date by category pivot: Numeric interval filter + Date by category pivot for supplied company filing inventories records (available_filings, expected_filings). 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-17-133?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","available_filings","expected_filings"],"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},"expected_filings":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"available_filings":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","expected_filings":1,"available_filings":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","expected_filings":2,"available_filings":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","expected_filings":3,"available_filings":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","expected_filings":4,"available_filings":30}],"maxItems":200,"minItems":1},"field":{"enum":["available_filings","expected_filings"],"type":"string","default":"available_filings"},"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_p895ly6AHsV-8B8rc3t6V","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 company filing inventory rows by a numeric interval on a chosen field and pivots filing dates by company category, producing two analytical reports from user-supplied data.","exampleAgentPrompt":"I have a dataset of company filing inventories with available_filings and expected_filings per group and date — can you filter it to only rows where available_filings is between 5 and 50, and also pivot the dates by company_group so I can see filing patterns by category?","exampleUseCases":[{"title":"Audit filing gaps by company group","prompt":"I have 120 rows of filing inventory records for groups A, B, and C with dates and expected_filings counts — filter to rows where expected_filings is between 1 and 25, and pivot the dates by company group so I can spot which groups are behind."},{"title":"Identify over-stocked available filings","prompt":"Here are our quarterly filing inventory records for five company groups — filter available_filings to the range 100 to 500 and show me a date-by-category pivot so I can see which groups have unusually high filing volumes on which dates."},{"title":"Compliance dashboard data prep","prompt":"I need to prepare data for our compliance dashboard — take these 80 filing records, filter to rows where available_filings falls between 0 and 30, and give me a pivot of filing dates broken out by company_group."}],"resultDescription":"Returns two analytical reports: (1) rows from the supplied dataset filtered to those where the chosen field (available_filings or expected_filings) falls within the specified numeric minimum–maximum interval; (2) a pivot table cross-tabulating filing dates against company_group categories, summarizing filing counts. Both reports are computed locally from supplied data with no external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, date, company_group, available_filings, expected_filings) cause validation errors","Invalid date format (non YYYY-MM-DD) rejected by pattern validation","Minimum value greater than maximum value may return empty filtered set","Null numeric values in filtered field may be excluded silently from interval results","Field enum value not matching 'available_filings' or 'expected_filings' causes schema error"],"whenToPreferThis":"Choose this endpoint when you have pre-loaded company filing inventory data (up to 200 rows) and need both a numeric range filter on filing counts and a date-by-category pivot in one cheap call ($0.01 USDC). Ideal for compliance analytics, filing gap audits, and dashboard data preparation where the data is already available locally and no live data fetching or prediction is required.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T12:48:34.973Z","isFirstParty":false,"canonicalSlug":"company-filing-inventories-numeric-interval-filter-date-by-category-9bb115b7"}