# News Archive Completeness — String Normalisation + Exact Row Deduplication

> News Archive Completeness — String Normalisation + Exact Row Deduplication 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-29).

Normalises strings and deduplicates exact rows in news archive completeness records containing indexed_items and expected_items fields, producing 2 analytical reports for up to 200 rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-news-23-020?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-29
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/news-archive-completeness-string-normalisation-exact-row-deduplication-90d8e142
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_AigyQUIp2OAgyAmoLt1c4

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 news-archive-completeness-string-normalisation-exact-row-deduplication-90d8e142 -d '<json body>'
```

Example prompt: Can you clean up my news archive completeness records — normalise the channel group strings and remove any exact duplicate rows? I have up to 200 rows each with a row_id, channel_group, date, indexed_items, and expected_items fields.

## When to prefer this

Choose this endpoint when you have news archive completeness records (indexed vs expected items per channel group and date) and need both string normalisation and exact duplicate removal in a single batch call for up to 200 rows. It is purpose-built for news archive data quality workflows and provides two independent analytical reports per call at a low flat cost, with no external lookups or network calls involved.

## Known failure modes

- Exceeding 200 rows returns a validation error
- Missing required fields (row_id, date, indexed_items, expected_items) cause row-level rejection
- Malformed date strings not matching YYYY-MM-DD pattern are rejected
- Null values in indexed_items or expected_items may be excluded from numeric analysis
- Empty array input (minItems:1 violated) returns an error

## How this service works

News archive completeness — String normalisation + Exact row deduplication: String normalisation + Exact row deduplication for supplied news archive completeness records (indexed_items, expected_items). 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

Two analytical reports covering: (1) string-normalised versions of the input records with standardised channel_group and other string fields, and (2) exact row deduplication results identifying and removing fully duplicate rows from the supplied news archive completeness dataset of up to 200 rows.

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/news-archive-completeness-string-normalisation-exact-row-deduplication-90d8e142/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)