# Pipeline Durations Analytics: Exact Row Deduplication + Numeric Row Ordering

> Pipeline Durations Analytics: Exact Row Deduplication + Numeric Row Ordering 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-16).

Deduplicates pipeline duration records and applies numeric row ordering across up to 200 rows of run_seconds and processed_rows data, returning 2 analytical reports.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-05-042?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-16
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/pipeline-durations-analytics-exact-row-deduplication-numeric-row-5d6b9dff
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_RKGq3kfZcIyNKBRe3GtV1

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 pipeline-durations-analytics-exact-row-deduplication-numeric-row-5d6b9dff -d '<json body>'
```

Example prompt: I have a batch of pipeline run records with run_seconds and processed_rows fields — can you deduplicate them and return them in numeric order? Here are up to 200 rows across group-a and group-b, and I want the analysis done on run_seconds.

## When to prefer this

Choose this endpoint when you need both exact deduplication and numeric ordering applied to pipeline duration data (run_seconds or processed_rows) in a single call returning two reports. It is ideal for data engineering workflows where you want to clean pipeline execution logs offline without any external API calls, predictions, or live data lookups — all processing is local and deterministic. Best for datasets up to 200 rows.

## Known failure modes

- Input array exceeds 200 rows — request rejected
- Missing required fields (row_id, dataset_group, date, run_seconds, processed_rows) cause validation error
- Invalid date format (not YYYY-MM-DD) fails schema validation
- Numeric fields out of allowed range (-1e12 to 1e12) rejected
- Invalid field enum value (not run_seconds or processed_rows) causes error
- Empty rows array rejected (minItems: 1)

## How this service works

Pipeline durations — Exact row deduplication + Numeric row ordering: Exact row deduplication + Numeric row ordering for supplied pipeline durations records (run_seconds, processed_rows). 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 derived from the supplied pipeline duration rows: one covering exact row deduplication results (identifying and removing duplicate records) and one covering numeric row ordering (rows sorted by the selected field — either run_seconds or processed_rows). No external lookups or predictions are made; all processing is local and deterministic.

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/pipeline-durations-analytics-exact-row-deduplication-numeric-row-5d6b9dff/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)