{"uid":"cap_pXICrxAcNYGbIPP8pdksc","slug":"travel-administration-exact-row-deduplication-keyed-dataset-comparison-e46b158f","name":"Travel Administration — Exact Row Deduplication + Keyed Dataset Comparison","description":"Travel administration — Exact row deduplication + Keyed dataset comparison: Exact row deduplication + Keyed dataset comparison 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-053?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},"other":{"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":21,"recorded_cost":2},{"date":"2026-10-03","row_id":"row-3","team_group":"group-a","trip_count":17,"recorded_cost":3},{"date":"2026-10-04","row_id":"row-4","team_group":"group-b","trip_count":33,"recorded_cost":4}],"maxItems":200,"minItems":0}}},"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_YabGoHjoHINRWx-RTZmGg","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 and compares two keyed datasets by trip_count and recorded_cost, producing two analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you deduplicate my travel administration records and compare them against a second dataset to find mismatches in trip_count and recorded_cost? I have two sets of up to 200 rows each, organized by row_id, team_group, and date.","exampleUseCases":[{"title":"Monthly travel expense reconciliation","prompt":"I have two exports of our travel expense data for October — one from the finance system and one from the travel booking tool. Can you compare them row by row using row_id as the key and flag any differences in trip_count or recorded_cost, and also deduplicate any repeated rows in each set? Each dataset has about 80 rows."},{"title":"Team travel data deduplication audit","prompt":"Our travel admin team submitted records for groups A and B across Q3, but I suspect there are duplicate entries. Can you run a deduplication check on these 150 travel records keyed by row_id, team_group, and date, and also compare them against last quarter's baseline dataset to highlight what changed in trip_count and recorded_cost?"},{"title":"Pre-reporting travel data cleanup","prompt":"Before I submit our travel report, I need to clean up my 120 travel administration rows — remove exact duplicates and then compare the cleaned set against our approved reference dataset to catch any discrepancies in trip_count or recorded_cost values by team_group and date."}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying duplicate records in the supplied dataset based on all field values, and (2) a keyed dataset comparison report matching rows by row_id across the two supplied datasets and flagging field-level differences in trip_count and recorded_cost. No external data is fetched; all analysis is performed on the supplied rows.","failureModes":["Exceeding 200 rows in either dataset returns a validation error","Missing required fields (row_id, team_group, date, trip_count, recorded_cost) cause schema rejection","Malformed date strings not matching YYYY-MM-DD pattern are rejected","Empty dataset arrays (minItems:1 violated) return an error","Numeric values outside the allowed range (±1,000,000,000,000) are rejected"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and keyed dataset comparison for travel administration records (trip_count, recorded_cost) in a single low-cost call. It is ideal for reconciling two versions of travel data, auditing records before reporting, or cleaning up duplicate entries without requiring any live lookups or external data sources. Best suited for datasets of up to 200 rows where offline, deterministic analysis is sufficient.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T06:47:20.844Z","isFirstParty":false,"canonicalSlug":"travel-administration-exact-row-deduplication-keyed-dataset-comparison-e46b158f"}