# Travel Administration Date-by-Category Pivot and Keyed Dataset Comparison

> Travel Administration Date-by-Category Pivot and Keyed Dataset Comparison is a paid API for AI agents from market.datapackvibe.com, paid per call via x402, $0.01/call, status unknown (last checked 2026-10-26).

Performs a date-by-category pivot table and a keyed dataset comparison on up to 200 travel administration records (trip_count or recorded_cost), returning two analytical reports.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-operations-14-188?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-26
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/travel-administration-date-by-category-pivot-and-keyed-dataset-a9045188
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_F2ql-k7OKiNeloX79BSrW

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability travel-administration-date-by-category-pivot-and-keyed-dataset-a9045188 -d '<json body>'
```

Example prompt: Can you run a date-by-category pivot and a keyed comparison on these two sets of travel records — use trip_count as the measure — the primary dataset has rows for group-a and group-b from October 2026, and I also have a second dataset with slightly different trip counts I want to compare against?

## When to prefer this

Choose this endpoint when you need both a date-by-category pivot table and a keyed comparison between two travel datasets in a single API call at minimal cost ($0.01 USDC for both reports). It is ideal for corporate travel analytics workflows where you have pre-collected records (up to 200 rows) and need offline, deterministic analysis without any live data lookup, external enrichment, or prediction.

## Known failure modes

- Input rows array is empty or exceeds 200 items — validation error
- Missing required fields (row_id, team_group, date, trip_count, recorded_cost) on any row — schema rejection
- Invalid date format (not YYYY-MM-DD) — pattern validation failure
- Numeric values out of allowed range (±1,000,000,000,000) — validation error
- field parameter not set to 'trip_count' or 'recorded_cost' — enum validation error
- Mismatched row_ids between primary and secondary datasets may result in empty or partial comparison output

## How this service works

Travel administration — Date by category pivot + Keyed dataset comparison: Date by category pivot + 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.

## Output

Returns two reports: (1) a date-by-category pivot table showing the selected metric (trip_count or recorded_cost) broken down by date and team_group, and (2) a keyed dataset comparison highlighting row-level differences between the primary and secondary datasets, all computed locally without external lookups.

## Request schema (JSON Schema)

```json
{
 "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"
  },
  "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": 
… (truncated)
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/travel-administration-date-by-category-pivot-and-keyed-dataset-a9045188/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from market.datapackvibe.com](https://www.zero.xyz/host/market.datapackvibe.com/llms.txt)
