# Travel Administration Duplicate Key Report and Missing Value Fill

> Travel Administration Duplicate Key Report and Missing Value Fill 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).

Analyzes up to 200 travel administration records to detect duplicate row keys and fill missing numeric values using zero, mean, or median imputation

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-operations-14-070?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-duplicate-key-report-and-missing-value-fill-aa77c9ca
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_FZT7896ESTWBkeOy_WqTD

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-duplicate-key-report-and-missing-value-fill-aa77c9ca -d '<json body>'
```

Example prompt: Check my travel records for duplicate row IDs and fill any missing trip_count values using the median — here are the rows: row-1, group-a, 2026-10-01, 10 trips, $1; row-2, group-b, 2026-10-02, null trips, $2; row-1, group-c, 2026-10-03, 15 trips, $3.

## When to prefer this

Choose this endpoint when you need lightweight, offline data quality checks on travel administration records — specifically duplicate key detection and numeric missing-value imputation — for up to 200 rows at low cost ($0.01 USDC for both reports). Prefer this over general ETL tools when your data is already structured with the expected fields and you only need these two specific analytical outputs without live lookups or external integrations.

## Known failure modes

- Submitting more than 200 rows returns an error — batch must be split
- Invalid date format (not YYYY-MM-DD) causes row rejection
- Missing required fields (row_id, team_group, date) causes validation failure
- Unsupported imputation method enum value returns an error
- Empty rows array is rejected as minItems is 1

## How this service works

Travel administration — Duplicate key report + Explicit missing-value fill: Duplicate key report + Explicit missing-value fill 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 independent reports: (1) a duplicate key report identifying which row_ids appear more than once across the submitted records, and (2) a filled dataset where null or missing values in the specified numeric field (trip_count or recorded_cost) have been replaced using the chosen imputation method (zero, mean, or median). Both reports are computed locally without any external lookup or live data.

## 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"
  },
  "method": {
   "enum": [
    "zero",
    "mean",
    "median"
   ],
   "type": "string",
   "default": "median"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/travel-administration-duplicate-key-report-and-missing-value-fill-aa77c9ca/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)