{"uid":"cap_bHL8s74Iz7CE1vP-LrEMD","slug":"travel-administration-record-quality-audit-date-by-category-pivot-64665cb2","name":"Travel Administration — Record Quality Audit + Date by Category Pivot","description":"Travel administration — Record quality audit + Date by category pivot: Record quality audit + Date by category pivot 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-017?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"}}},"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_Eg41B2J59YkYyBDoeZWqS","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":"Audits record quality and generates a date-by-category pivot report for travel administration data (trip_count, recorded_cost) across up to 200 rows.","exampleAgentPrompt":"Can you run a record quality audit and a date-by-category pivot on my travel admin data? I have up to 50 rows with trip_count and recorded_cost fields grouped by team, and I want to pivot on trip_count.","exampleUseCases":[{"title":"Corporate travel expense audit","prompt":"I have a CSV of our Q3 corporate travel records with columns for row_id, team_group, date, trip_count, and recorded_cost — can you check those 120 rows for data quality issues and also give me a pivot of recorded_cost by date and team group?"},{"title":"Monthly trip count pivot by team","prompt":"Run a date-by-category pivot on trip_count for these 80 travel records across our sales and ops teams — I need to see how trips break down by date and group, plus flag any quality problems in the data."},{"title":"Pre-reporting data validation for travel logs","prompt":"Before I submit our travel report, can you audit these 200 travel admin rows for record quality issues and generate a pivot table of trip_count broken down by date and team_group?"}],"resultDescription":"Returns two independent reports: (1) a record quality audit identifying missing, null, or out-of-range values in the supplied travel records, and (2) a date-by-category pivot aggregating the selected field (trip_count or recorded_cost) across dates and team groups — all computed locally without external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, date, team_group, trip_count, recorded_cost) cause row-level validation errors","Invalid date format (not YYYY-MM-DD) triggers schema rejection","Field selector not one of 'trip_count' or 'recorded_cost' causes enum validation failure","All-null values in selected field may produce empty pivot output"],"whenToPreferThis":"Choose this endpoint when you need both a data quality check and a date-by-category pivot on travel administration records in a single low-cost call. It is ideal for batch offline analysis of up to 200 rows of trip and cost data grouped by team, with no need for live external data, predictions, or real-time lookups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T18:51:24.014Z","isFirstParty":false,"canonicalSlug":"travel-administration-record-quality-audit-date-by-category-pivot-64665cb2"}