{"uid":"cap_W19qZ8kS7jze8I9x_Q8XY","slug":"travel-administration-exact-row-deduplication-numeric-interval-filter-eb6ae23b","name":"Travel Administration — Exact Row Deduplication + Numeric Interval Filter","description":"Travel administration — Exact row deduplication + Numeric interval filter: Exact row deduplication + Numeric interval filter for supplied travel administration records (trip_count, recorded_cost). 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-operations-14-043?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","team_group","date","trip_count","recorded_cost"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"team_group":{"type":"string","default":"","maxLength":80},"trip_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"recorded_cost":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","team_group":"group-a","trip_count":10,"recorded_cost":1},{"date":"2026-10-02","row_id":"row-2","team_group":"group-b","trip_count":20,"recorded_cost":2},{"date":"2026-10-03","row_id":"row-3","team_group":"group-a","trip_count":15,"recorded_cost":3},{"date":"2026-10-04","row_id":"row-4","team_group":"group-b","trip_count":30,"recorded_cost":4}],"maxItems":200,"minItems":1},"field":{"enum":["trip_count","recorded_cost"],"type":"string","default":"trip_count"},"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_Wvmt1fl-PmbSB6WA_2cdH","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":"Deduplicates travel administration records exactly and filters rows by a numeric interval on trip_count or recorded_cost, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"I have up to 200 travel administration records with trip_count and recorded_cost fields — can you deduplicate them exactly and then filter to only keep rows where trip_count is between 5 and 50, giving me both reports?","exampleUseCases":[{"title":"Clean corporate travel expense data","prompt":"I've got a dataset of corporate travel records with team groups and dates — can you remove any exact duplicate rows and then filter to only show entries where recorded_cost is between 100 and 5000? I need both the dedup report and the filtered report."},{"title":"Filter field team trips by count range","prompt":"Here are our field team's trip logs for Q4 with trip_count values — please deduplicate the records first, then filter down to rows where trip_count falls between 10 and 30, and give me both reports."},{"title":"Audit travel data before budget review","prompt":"Before our budget review I need to clean this set of travel administration rows: remove exact duplicates, then keep only the rows where recorded_cost is between 200 and 2000. Can you run both reports on up to 200 rows?"}],"resultDescription":"Returns two analytical reports: one covering exact row deduplication results (identifying and removing fully duplicate rows) and one covering numeric interval filtering results (rows where the selected field — trip_count or recorded_cost — falls within the specified minimum and maximum bounds). Both reports are derived from the supplied rows using local analytical engines with no external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, date, trip_count, recorded_cost) cause validation errors","Date strings not matching YYYY-MM-DD pattern are rejected","Minimum value greater than maximum value may produce empty filter results","Null numeric values in the selected filter field may be excluded from interval results","Invalid field enum value (not 'trip_count' or 'recorded_cost') causes schema rejection"],"whenToPreferThis":"Choose this endpoint when you have up to 200 travel administration records and need both exact row deduplication and numeric interval filtering in a single call at minimal cost ($0.01 USDC). Ideal for data cleaning workflows where you want to identify duplicate travel entries and simultaneously scope results to a meaningful numeric range on trip_count or recorded_cost, without needing live data lookups or predictive modeling.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-29T13:17:16.814Z","isFirstParty":false,"canonicalSlug":"travel-administration-exact-row-deduplication-numeric-interval-filter-eb6ae23b"}