{"uid":"cap_yJiztY8K27leVj5bS8Qps","slug":"time-entries-numeric-interval-filter-2a79f636","name":"Time Entries Numeric Interval Filter","description":"Time entries - Numeric interval filter: Numeric interval filter for Time entries. Up to 200 supplied typed records. Local numeric and data-quality processing; no external enrichment or forecasting. One of 25 profiles or calculations across 20 shared operations in this sector. 0.01 USDC includes one bounded numeric interval filter deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-time-entries-range-filter?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","project","date","hours","billable_hours"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"project":{"type":"string","default":"","maxLength":80},"billable_hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","hours":10,"row_id":"row-1","project":"group-a","billable_hours":1},{"date":"2026-10-02","hours":20,"row_id":"row-2","project":"group-b","billable_hours":2},{"date":"2026-10-03","hours":15,"row_id":"row-3","project":"group-a","billable_hours":3},{"date":"2026-10-04","hours":30,"row_id":"row-4","project":"group-b","billable_hours":4}],"maxItems":200,"minItems":1},"field":{"enum":["hours","billable_hours"],"type":"string","default":"hours"},"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_ycYtuqGe22q8JP79taKBB","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 time entry records (hours or billable_hours) to only those rows whose numeric value falls within a specified minimum–maximum range.","exampleAgentPrompt":"Filter these time entries and return only the rows where 'hours' is between 8 and 40: row-1 (group-a, 2026-10-01, 10h, 1 billable), row-2 (group-b, 2026-10-02, 20h, 2 billable), row-3 (group-a, 2026-10-03, 15h, 3 billable), row-4 (group-b, 2026-10-04, 30h, 4 billable).","exampleUseCases":[{"title":"Overtime detection in timesheets","prompt":"I have a list of employee time entries for October — can you filter out only the rows where hours logged are between 40 and 80 so I can flag potential overtime?"},{"title":"Billable hours compliance check","prompt":"From this batch of project time entries, show me only the records where billable_hours are between 5 and 20 — I need to spot entries that fall within our standard billing band."},{"title":"Exclude zero and extreme outlier entries","prompt":"I want to clean up my timesheet export — filter the rows by hours, keeping only entries where hours is between 0.5 and 12 to remove blanks and obvious data errors."}],"resultDescription":"A subset of the submitted time entry rows (up to 200 input rows supported) where the specified numeric field ('hours' or 'billable_hours') falls within the given minimum and maximum bounds. Each returned row preserves all original fields: row_id, project, date, hours, and billable_hours.","failureModes":["No rows returned if none satisfy the min–max range (empty array result)","Validation error if minimum is greater than maximum","Input rejected if rows array is empty or exceeds 200 items","Invalid field enum value (must be 'hours' or 'billable_hours') causes a schema error","Malformed date strings (not YYYY-MM-DD) will fail schema validation","Null numeric values in the target field may be excluded or cause unexpected filtering behavior"],"whenToPreferThis":"Use this endpoint when you have a batch of time entry records (up to 200 rows) and need to subset them by a numeric range on hours or billable_hours fields, without any external data enrichment, forecasting, or aggregation. It is ideal for local data quality filtering, compliance checks, and pre-processing steps in a larger timesheet or billing pipeline. Prefer alternatives if you need aggregation, grouping by project, date-range filtering, or external data lookups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:39:30.822Z","isFirstParty":false,"canonicalSlug":"time-entries-numeric-interval-filter-2a79f636"}