{"uid":"cap__C6ZfprfC-18oJH8jJMsy","slug":"travel-administration-duplicate-key-report-and-keyed-dataset-comparison-d882992a","name":"Travel Administration Duplicate Key Report and Keyed Dataset Comparison","description":"Travel administration — Duplicate key report + Keyed dataset comparison: Duplicate key report + 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-069?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_WLoQvsARYy89k0TBavbvi","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":"Runs two local analytical reports on travel administration records: a duplicate key detection report and a keyed comparison between two supplied datasets, covering trip_count and recorded_cost fields.","exampleAgentPrompt":"Can you check my two travel admin datasets for duplicate row IDs and also compare them side-by-side to spot any differences in trip_count or recorded_cost? Here are the rows for the primary dataset and the comparison dataset — both have row_id, team_group, date, trip_count, and recorded_cost fields.","exampleUseCases":[{"title":"Audit travel records for duplicate keys","prompt":"I have a batch of travel administration records with row IDs, team groups, dates, trip counts, and recorded costs — can you run a duplicate key check on them to find any repeated row_id values?"},{"title":"Reconcile two travel dataset snapshots","prompt":"I have two versions of our travel cost dataset from different systems — one is the source and one is what got imported. Can you compare them by row key and tell me where trip_count or recorded_cost differ?"},{"title":"Validate data before finance reporting","prompt":"Before I submit our quarterly travel report, can you check this dataset of up to 200 travel records for any duplicate keys and also compare it against last quarter's data to highlight any row-level discrepancies in costs or trip counts?"}],"resultDescription":"Two reports returned together: (1) a duplicate key report listing any row_ids that appear more than once in the primary dataset, and (2) a keyed comparison showing which rows differ between the primary and secondary datasets on trip_count and recorded_cost fields, including matched, unmatched, and changed rows.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Missing required fields (row_id, team_group, date, trip_count, recorded_cost) causes validation error","Malformed date strings not matching YYYY-MM-DD pattern rejected","Empty rows array rejected (minItems: 1)","Non-numeric values in trip_count or recorded_cost cause schema failure"],"whenToPreferThis":"Choose this endpoint when you need both duplicate key detection and a keyed row-level comparison on travel administration data in a single $0.01 call, with no need for external lookups, live data, or prediction — purely local analytical processing on up to 200 supplied rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-30T19:11:02.446Z","isFirstParty":false,"canonicalSlug":"travel-administration-duplicate-key-report-and-keyed-dataset-comparison-d882992a"}