# JSON to CSV Converter

> JSON to CSV Converter is a paid API for AI agents from intel.rallylive.ca, paid per call via x402, $0.01/call, status unknown (last checked 2026-09-14).

Converts a JSON array of objects into RFC-4180 compliant CSV, flattening nested keys with dots and joining arrays, and returns the CSV text plus row/column statistics.

## Facts

- Endpoint: GET https://intel.rallylive.ca/data/json-to-csv
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-09-14
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/json-to-csv-converter-b7f3025d
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_vrrEZmH5v8V_AsilA3Ehs

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 json-to-csv-converter-b7f3025d
```

Example prompt: I have a JSON array of user records with nested fields like address.city and tags as arrays — can you convert it to a proper RFC-4180 CSV with a header row and tell me how many rows and columns came out?

## When to prefer this

Choose this endpoint when you need a quick, single-call conversion of a JSON array of objects to RFC-4180 CSV with automatic nested key flattening and array joining, especially when you also need metadata about the resulting table (row count, column count, column names). Ideal for lightweight ETL steps, spreadsheet exports, and BI tool ingestion prep without setting up a local library.

## Known failure modes

- Input is not a valid JSON array — returns an error indicating malformed input
- Input JSON contains no objects or is empty — may return a CSV with only headers or an empty result
- Extremely large JSON payloads may time out or hit size limits
- Non-serializable values (e.g. functions, undefined) in JSON may be dropped or cause errors

## How this service works

JSON to CSV: converts an array of objects (nested keys flattened with dots, arrays joined) into RFC-4180 CSV with a header row, returning the CSV text, row and column counts and the columns detected. $0.01 per call.

## Output

Returns the full RFC-4180 CSV text with a header row derived from all detected keys (nested keys flattened with dot notation, array values joined), plus the total row count, total column count, and the list of column names detected.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "$schema": "https://json-schema.org/draft/2020-12/schema",
 "required": [
  "input"
 ],
 "properties": {
  "input": {
   "type": "object",
   "required": [
    "type",
    "method"
   ],
   "properties": {
    "type": {
     "type": "string",
     "const": "http"
    },
    "method": {
     "enum": [
      "GET"
     ],
     "type": "string"
    },
    "queryParams": {
     "type": "object",
     "properties": {}
    }
   },
   "additionalProperties": false
  },
  "output": {
   "type": "object",
   "required": [
    "type"
   ],
   "properties": {
    "type": {
     "type": "string"
    },
    "example": {
     "type": "object"
    }
   }
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/json-to-csv-converter-b7f3025d/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from intel.rallylive.ca](https://www.zero.xyz/host/intel.rallylive.ca/llms.txt)