{"uid":"cap_5ROflKCMNDeSSr8-Y5PEJ","slug":"record-routing-numeric-interval-filter-date-by-category-pivot-a9ba8dc6","name":"Record Routing — Numeric Interval Filter + Date by Category Pivot","description":"Record routing — Numeric interval filter + Date by category pivot: Numeric interval filter + Date by category pivot for supplied record routing records (accepted_records, rejected_records). 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-analytics-19-133?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","accepted_records","rejected_records"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"dataset_group":{"type":"string","default":"","maxLength":80},"accepted_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"rejected_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","accepted_records":10,"rejected_records":1},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","accepted_records":20,"rejected_records":2},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","accepted_records":15,"rejected_records":3},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","accepted_records":30,"rejected_records":4}],"maxItems":200,"minItems":1},"field":{"enum":["accepted_records","rejected_records"],"type":"string","default":"accepted_records"},"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_RQXV01AbuTyqF_RjjvmPz","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 record routing data (accepted/rejected records) by a numeric interval and produces a date-by-category pivot table, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"Run two reports on my record routing data: filter rows where accepted_records falls between 5 and 50, and also pivot those records by date and dataset_group — here's my dataset with rows for group-a and group-b from 2026-10-01 to 2026-10-04.","exampleUseCases":[{"title":"ETL pipeline quality gate review","prompt":"I have 150 rows of record routing data from my ETL pipeline with accepted_records and rejected_records per dataset_group and date. Can you filter to only show rows where accepted_records is between 0 and 100, and also give me a pivot of accepted_records broken down by date and group?"},{"title":"Routing anomaly band detection","prompt":"Flag any record routing entries where rejected_records falls outside the range of 1 to 20, and then pivot the full dataset by date and category so I can see the pattern — I've got about 80 rows covering three groups over the past month."},{"title":"Daily category throughput summary","prompt":"Take my record routing dataset — about 60 rows, groups alpha and beta, dates in October 2026 — and give me a date-by-category pivot of accepted_records, plus filter out any rows where accepted_records is below 10 or above 500."}],"resultDescription":"Returns two independent analytical reports: (1) a numeric interval filter report listing rows where the chosen field (accepted_records or rejected_records) falls within the specified min/max range, and (2) a date-by-category pivot table summarizing values across dataset_group and date dimensions. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["Missing required fields (row_id, date, dataset_group) cause validation errors","Date values not matching YYYY-MM-DD pattern are rejected","Submitting more than 200 rows exceeds the row limit","Minimum value greater than maximum value may produce empty filter results","Null numeric values in the target field are excluded from interval filtering","Payment failure via x402 protocol blocks the request"],"whenToPreferThis":"Choose this endpoint when you need two simultaneous analytical operations on record routing data — specifically a numeric range filter and a date-category pivot — delivered together in one $0.01 call. Ideal for ETL monitoring, data quality reviews, or pipeline audits where you want to both isolate out-of-band records and understand temporal-categorical distribution without writing custom code or spinning up a BI tool.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:39:50.844Z","isFirstParty":false,"canonicalSlug":"record-routing-numeric-interval-filter-date-by-category-pivot-a9ba8dc6"}