{"uid":"cap_W9RimRy8_TNL6YV4oV10d","slug":"travel-administration-data-quality-suite-record-audit-string-805ccc34","name":"Travel Administration Data Quality Suite: Record Audit, String Normalisation & Dataset Comparison","description":"Travel administration — Record quality audit + String normalisation + Keyed dataset comparison: Record quality audit + String normalisation + Keyed dataset comparison for supplied travel administration records (trip_count, recorded_cost). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-operations-14-207?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_AtWTDeYpAiFtcILQl6J7C","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 three local analytical reports on travel administration records (trip_count, recorded_cost): record quality audit, string normalisation, and keyed dataset comparison — up to 200 rows per call.","exampleAgentPrompt":"Can you run a record quality audit, string normalisation, and keyed comparison on my two sets of travel admin records? I have up to 50 rows each with row_id, team_group, date, trip_count, and recorded_cost — here's the primary dataset and the comparison dataset.","exampleUseCases":[{"title":"Pre-load travel data validation","prompt":"Before we import this month's travel logs into the warehouse, can you audit these 80 rows of trip records for quality issues, normalise the team_group strings, and compare them against last month's dataset keyed by row_id? Fields are row_id, team_group, date, trip_count, and recorded_cost."},{"title":"Expense reconciliation between two teams","prompt":"We have two exports of recorded travel costs for Q3 — one from Finance and one from Operations — each with about 120 rows including row_id, team_group, date, trip_count, and recorded_cost. Can you compare them to find discrepancies, normalise the string fields, and flag any quality problems?"},{"title":"Travel budget anomaly investigation","prompt":"Something looks off in our travel admin data. Can you run a data quality audit and string normalisation on these 40 rows of trip_count and recorded_cost entries, and also compare them to our reference dataset by row_id to see where values differ?"}],"resultDescription":"Three structured analytical reports returned together: (1) a record quality audit flagging nulls, out-of-range values, and structural issues per row; (2) a string normalisation report showing standardised versions of text fields like team_group; (3) a keyed dataset comparison report showing row-by-row differences between the primary and comparison datasets matched on row_id. No external lookups or predictions are made — all analysis is local.","failureModes":["Exceeding 200 rows in either dataset returns a validation error","Rows missing required fields (row_id, team_group, date, trip_count, recorded_cost) are rejected","Malformed date strings not matching YYYY-MM-DD pattern cause schema validation failure","Numeric fields outside the allowed range (-1e12 to 1e12) are rejected","Empty datasets (minItems:1 not met) return an error","Payment failure or insufficient USDC balance prevents processing"],"whenToPreferThis":"Choose this endpoint when you need all three of record quality auditing, string normalisation, and keyed dataset comparison performed together on travel administration data (trip_count and recorded_cost fields) in a single low-cost call. It is ideal for pre-ingestion data validation, reconciliation between two data exports, or routine data hygiene checks on travel records up to 200 rows. It is not suitable for live data lookups, predictive analytics, external enrichment, or datasets larger than 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T18:50:50.665Z","isFirstParty":false,"canonicalSlug":"travel-administration-data-quality-suite-record-audit-string-805ccc34"}