# Foundry CSV Datetime Normalization

> Foundry CSV Datetime Normalization 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).

Normalizes date and datetime columns in a CSV to ISO 8601 UTC format, reporting issues and cell-level statistics.

## Facts

- Endpoint: POST https://foundry-par007-machine-revenue-mainnet.inference-chip-index.workers.dev/v2/data/csv-datetime-normalization
- 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-datetime-normalization-7728b2e9
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_o-QJNL2ORnnpsxN6SCOP9

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-datetime-normalization-7728b2e9 -d '<json body>'
```

Example prompt: I have a CSV with an 'order_date' column formatted as DD/MM/YYYY and a 'shipped_at' column in MM/DD/YYYY HH:mm:ss — can you normalize both to ISO 8601 UTC, assuming UTC+60 minutes offset?

## When to prefer this

Choose this endpoint when you need programmatic, pay-per-call CSV datetime normalization with explicit format declarations, ISO 8601 UTC output, per-cell issue reporting, and a SHA-256 input fingerprint for audit provenance — especially inside automated ETL or data-cleaning agent workflows where you want a deterministic, schema-validated result rather than a general-purpose LLM guess at date parsing.

## Known failure modes

- CSV exceeds 12,000 character limit — request rejected
- Column name not found in CSV headers — column skipped or error returned
- Unrecognized datetime values that don't match declared format — counted as invalid cells
- UTC offset outside -840 to +840 range — validation error
- Malformed JSON input — 400-level error
- More than 10 columns specified — schema validation failure

## 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 containing: the normalized CSV string with all target columns converted to ISO 8601 UTC format, a list of issues per problematic cell, counts of total rows, normalized cells, and invalid cells, the SHA-256 hash of the input CSV, a status string (e.g. NORMALIZED), a flag indicating whether evidence was truncated, and an observed_at timestamp.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "csv": {
   "type": "string",
   "maxLength": 12000,
   "minLength": 1
  },
  "columns": {
   "type": "array",
   "items": {
    "type": "object",
    "required": [
     "name",
     "format"
    ],
    "properties": {
     "name": {
      "type": "string",
      "maxLength": 100,
      "minLength": 1
     },
     "format": {
      "enum": [
       "YYYY-MM-DD",
       "DD/MM/YYYY",
       "MM/DD/YYYY",
       "YYYY-MM-DD HH:mm:ss",
       "DD/MM/YYYY HH:mm:ss",
       "MM/DD/YYYY HH:mm:ss"
      ],
      "type": "string"
     }
    },
    "additionalProperties": false
   },
   "maxItems": 10,
   "minItems": 1
  },
  "utc_offset_minutes": {
   "type": "integer",
   "maximum": 840,
   "minimum": -840
  }
 }
}
```

## Response schema (JSON Schema)

```json
{
 "type": "json",
 "example": {
  "route": "csv-datetime-normalization",
  "result": {
   "issues": [],
   "status": "NORMALIZED",
   "row_count": 1,
   "output_csv": "id,when\r\n1,2026-09-05T23:30:00.000Z",
   "limitations": [
    "Synthetic example hash."
   ],
   "input_sha256": "0000000000000000000000000000000000000000000000000000000000000000",
   "evidence_truncated": false,
   "invalid_cell_count": 0,
   "normalized_cell_count": 1
  },
  "observed_at": "2026-09-06T00:00:00Z"
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/foundry-csv-datetime-normalization-7728b2e9/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)