# ToolSnap CSV Query XL

> ToolSnap CSV Query XL is a paid API for AI agents from mcp.toolsnap.app, paid per call via x402, $0.02/call, status unknown (last checked 2026-11-18).

Query a remote CSV file by URL with filtering, column selection, sorting, and row limiting, returning results as JSON or CSV

## Facts

- Endpoint: POST https://mcp.toolsnap.app/x402/tools/csv_query_xl?utm_source=zero.xyz
- Price: $0.02/call
- Payment: x402
- Status: unknown
- Last checked: 2026-11-18
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/toolsnap-csv-query-xl-b46d4c1f
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_z_ROGi5zhuaMSiajHgLuo

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 toolsnap-csv-query-xl-b46d4c1f -d '<json body>'
```

Example prompt: Can you pull the CSV at https://example.com/sales_data.csv, filter rows where region equals 'West', select only the columns 'date', 'region', and 'revenue', sort by revenue descending, and return the top 50 rows as JSON?

## When to prefer this

Use this endpoint when you need to query, filter, and slice a remote CSV file without downloading it fully — especially when the CSV is large and you only need a subset of rows or columns. It avoids passing raw CSV content to the LLM (significant token savings) and supports authenticated access via forwarded headers. Prefer it over in-context CSV parsing when the file is large, when filtering/sorting is needed server-side, or when you want structured JSON output directly.

## Known failure modes

- Invalid or unreachable CSV URL returns an error
- Filter expression malformed or references non-existent column
- Row limit exceeds maximum of 1000
- Auth headers insufficient to access protected CSV
- CSV file is malformed or not valid CSV
- Column names in 'select' don't exist in the file
- Sort column not found in CSV headers

## How this service works

47 server-side tools for AI agents through a single MCP connection. 36 free, no new accounts. Median 98.1% token savings on web content. Paid tools from $0.02.

## Output

A list of rows from the remote CSV matching the filter and column selection criteria, returned as JSON array of objects or as a CSV string, sorted and limited per the request parameters. Up to 1000 rows per call.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "url": {
   "type": "string",
   "description": "CSV URL."
  },
  "limit": {
   "type": "number",
   "description": "Default 100, max 1000."
  },
  "filter": {
   "type": "string",
   "description": "'col op value'."
  },
  "format": {
   "enum": [
    "json",
    "csv"
   ],
   "type": "string",
   "description": "Default json."
  },
  "select": {
   "type": "string",
   "description": "Columns, comma-separated."
  },
  "headers": {
   "type": "object",
   "description": "Headers to forward (Authorization, Cookie…)."
  },
  "sort_by": {
   "type": "string",
   "description": "Sort column."
  },
  "sort_dir": {
   "enum": [
    "asc",
    "desc"
   ],
   "type": "string",
   "description": "Default asc."
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/toolsnap-csv-query-xl-b46d4c1f/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from mcp.toolsnap.app](https://www.zero.xyz/host/mcp.toolsnap.app/llms.txt)
