# Translation Delivery — Duplicate Key Report + Date by Category Pivot

> Translation Delivery — Duplicate Key Report + Date by Category Pivot 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 supplied translation delivery records to produce a duplicate key report and a date-by-category pivot table for translated_words or source_words, using local analytical engines with no external lookups.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-writing-04-068?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/translation-delivery-duplicate-key-report-date-by-category-pivot-7546e70f
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_Q3d1It3pjoCog2NvEH3Qs

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 translation-delivery-duplicate-key-report-date-by-category-pivot-7546e70f -d '<json body>'
```

Example prompt: Check my translation delivery records for duplicate row IDs and also give me a pivot of translated_words by date and document group — here are up to 200 rows with row_id, document_group, date, translated_words, and source_words.

## When to prefer this

Choose this endpoint when you need both a duplicate key audit and a date-by-category pivot on translation delivery data (translated_words/source_words) in a single call for up to 200 rows, without requiring any external lookup or live data. It is ideal for localization QA workflows, delivery volume reviews, and data quality checks on translation job exports where the data is already available client-side.

## Known failure modes

- More than 200 rows submitted — request rejected or truncated
- Missing required fields (row_id, document_group, date, translated_words, source_words) — validation error
- Invalid date format (not YYYY-MM-DD) — schema validation failure
- Numeric values outside allowed range — schema rejection
- Empty rows array — minimum items constraint violated
- Invalid field enum value (not translated_words or source_words) — schema error

## How this service works

Translation delivery — Duplicate key report + Date by category pivot: Duplicate key report + Date by category pivot for supplied translation delivery records (translated_words, source_words). 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 analytical reports: (1) a duplicate key report identifying any repeated row_id values across the supplied records, and (2) a date-by-category pivot table aggregating the selected metric (translated_words or source_words) broken down by date and document_group. Results are computed locally from the supplied data, covering up to 200 rows.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "rows": {
   "type": "array",
   "items": {
    "type": "object",
    "required": [
     "row_id",
     "document_group",
     "date",
     "translated_words",
     "source_words"
    ],
    "properties": {
     "date": {
      "type": "string",
      "default": "",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$",
      "maxLength": 10
     },
     "row_id": {
      "type": "string",
      "default": "",
      "maxLength": 80,
      "minLength": 1
     },
     "source_words": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "document_group": {
      "type": "string",
      "default": "",
      "maxLength": 80
     },
     "translated_words": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     }
    },
    "additionalProperties": false
   },
   "default": [
    {
     "date": "2026-10-01",
     "row_id": "row-1",
     "source_words": 1,
     "document_group": "group-a",
     "translated_words": 10
    },
    {
     "date": "2026-10-02",
     "row_id": "row-2",
     "source_words": 2,
     "document_group": "group-b",
     "translated_words": 20
    },
    {
     "date": "2026-10-03",
     "row_id": "row-3",
     "source_words": 3,
     "document_group": "group-a",
     "translated_words": 15
    },
    {
     "date": "2026-10-04",
     "row_id": "row-4",
     "source_words": 4,
     "document_group": "group-b",
     "translated_words": 30
    }
   ],
   "maxItems": 200,
   "minItems": 1
  },
  "field": {
   "enum": [
    "translated_words",
    "source_words"
   ],
   "type": "string",
   "default": "translated_words"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/translation-delivery-duplicate-key-report-date-by-category-pivot-7546e70f/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)