# Foundry CSV Timeseries Gap Evidence

> Foundry CSV Timeseries Gap Evidence is a paid API for AI agents from foundry-par007-machine-revenue-mainnet.inference-chip-index.workers.dev, paid per call via x402, $0.006/call, status unknown (last checked 2026-09-14).

Validates a CSV timeseries for missing, duplicate, off-grid, and out-of-window timestamps given an expected time range and step interval.

## Facts

- Endpoint: POST https://foundry-par007-machine-revenue-mainnet.inference-chip-index.workers.dev/v2/data/csv-timeseries-gap-evidence
- Price: $0.006/call
- Payment: x402
- Status: unknown
- Last checked: 2026-09-14
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/foundry-csv-timeseries-gap-evidence-f016e23b
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_cfw1mmandmOOu08BkQl69

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 foundry-csv-timeseries-gap-evidence-f016e23b -d '<json body>'
```

Example prompt: Check this CSV for any missing or duplicate timestamps — the timestamp column is called 'recorded_at', data should run from 2024-01-01T00:00:00Z to 2024-01-02T00:00:00Z at 60-second intervals. Here's the CSV: [paste CSV text].

## When to prefer this

Use this endpoint when you need cryptographically provable, pay-per-request evidence of timeseries completeness — specifically when you must identify exact missing timestamps, detect duplicates, and confirm on-grid alignment against a defined schedule. Prefer this over manual scripts when you need an auditable SHA-256 input hash and structured JSON evidence suitable for defect reports, SLA proofs, or pipeline audits. It is a better fit than general-purpose data tools when the input fits within 12,000 characters and you need a deterministic, low-latency answer with explicit source provenance.

## Known failure modes

- CSV exceeds 12,000 character maxLength — request rejected
- timestamp_column name not found in CSV headers — validation fails or returns invalid counts
- start_time or end_time not parseable as ISO timestamps — error response
- step_seconds outside 1–86400 range — schema rejection
- Malformed CSV with no parseable rows — may return zero counts or error
- Payment not included or insufficient USDC — 402 response

## How this service works

Pay-per-request evidence and data tools: CSV validation and reconciliation, DNS/email configuration evidence, and bounded official weather, earthquake, vehicle, company and study records. Exact USDC prices, explicit JSON contracts and source provenance. No mailbox, ownership, medical or safety guarantees.

## Output

Returns a JSON object with a status field (e.g. GAPS_OR_DUPLICATES or OK), row count, expected count, missing count, list of missing timestamps, duplicate aligned count, off-grid count, outside-window count, invalid timestamp count, observed unique aligned count, whether evidence was truncated, and a SHA-256 hash of the input for provenance. Also includes the route name and observation timestamp.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "csv": {
   "type": "string",
   "maxLength": 12000,
   "minLength": 1
  },
  "end_time": {
   "type": "string"
  },
  "start_time": {
   "type": "string"
  },
  "step_seconds": {
   "type": "integer",
   "maximum": 86400,
   "minimum": 1
  },
  "timestamp_column": {
   "type": "string",
   "maxLength": 100,
   "minLength": 1
  }
 }
}
```

## Response schema (JSON Schema)

```json
{
 "type": "json",
 "example": {
  "route": "csv-timeseries-gap-evidence",
  "result": {
   "status": "GAPS_OR_DUPLICATES",
   "row_count": 2,
   "limitations": [
    "Synthetic example hash."
   ],
   "input_sha256": "0000000000000000000000000000000000000000000000000000000000000000",
   "missing_count": 1,
   "expected_count": 3,
   "off_grid_count": 0,
   "evidence_truncated": false,
   "missing_timestamps": [
    "2026-09-06T00:01:00.000Z"
   ],
   "outside_window_count": 0,
   "invalid_record_numbers": [],
   "duplicate_aligned_count": 0,
   "invalid_timestamp_count": 0,
   "observed_unique_aligned": 2
  },
  "observed_at": "2026-09-06T00:00:00Z"
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/foundry-csv-timeseries-gap-evidence-f016e23b/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from foundry-par007-machine-revenue-mainnet.inference-chip-index.workers.dev](https://www.zero.xyz/host/foundry-par007-machine-revenue-mainnet.inference-chip-index.workers.dev/llms.txt)