# Purchase Order Imports — Declared Column Projection

> Purchase Order Imports — Declared Column Projection 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-15).

Validates a purchase order CSV file against a declared column schema, checking structure, data types, numeric ranges, category membership, and cell length constraints for up to 1000 rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-bx-csv-purchases-projection?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-15
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/purchase-order-imports-declared-column-projection-835dde22
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_FRbf5R07wMWLG8TviilI8

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 purchase-order-imports-declared-column-projection-835dde22 -d '<json body>'
```

Example prompt: Can you validate my purchase order CSV against its declared column schema? It uses comma delimiters, columns are purchase_id, placed_on, vendor_id, ordered_units, and order_amount, allowed vendors are group-a and group-b, amounts should be between 0 and 1000000, and max cell length is 500.

## When to prefer this

Choose this endpoint when you need to validate a purchase order CSV against a declared column contract before importing it into a downstream system. It is purpose-built for purchase order data (purchase_id, placed_on, vendor_id, ordered_units, order_amount) and supports category allowlists, numeric range bounds, and cell length limits — all without sending data to external enrichment services. Prefer it over generic CSV validators when the domain is specifically procurement/purchase orders and you want a structured compliance report rather than a simple parse check.

## Known failure modes

- CSV exceeds 100,000 character limit — request rejected
- More than 1000 rows submitted — only first 1000 processed or error returned
- Invalid delimiter specified (must be comma, semicolon, or tab)
- Malformed CSV (unclosed quotes, missing headers) — parse error returned
- Numeric minimum exceeds maximum — constraint conflict error
- Empty CSV or CSV with only a header row — minimal or empty report returned
- Payment of 0.01 USDC not provided — 402 Payment Required response

## How this service works

Purchase order imports — Declared column projection: Declared column projection for Purchase order imports. Validate a declared CSV table contract, up to 1000 rows. Quoted cells supported; no external enrichment. Specialised preset in a shared 50-profile, 20-operation engine. 0.01 USDC includes one CSV declared column projection report.

## Output

A declared column projection report for the submitted purchase order CSV, covering schema conformance, column type checks, numeric range violations, disallowed category values, cell length breaches, and a per-row or summary compliance status — up to 1000 rows processed per call.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "csv": {
   "type": "string",
   "default": "purchase_id,placed_on,vendor_id,ordered_units,order_amount\nrecord-a,2026-01-01,group-a,10,2\nrecord-b,2026-01-02,group-b,20,3",
   "maxLength": 100000,
   "minLength": 1
  },
  "maximum": {
   "type": "number",
   "default": 1000000000000,
   "maximum": 1000000000000,
   "minimum": -1000000000000
  },
  "minimum": {
   "type": "number",
   "default": -1000000000000,
   "maximum": 1000000000000,
   "minimum": -1000000000000
  },
  "delimiter": {
   "enum": [
    ",",
    ";",
    "\t"
   ],
   "type": "string",
   "default": ","
  },
  "max_cell_length": {
   "type": "integer",
   "default": 1000,
   "maximum": 5000,
   "minimum": 1
  },
  "allowed_categories": {
   "type": "array",
   "items": {
    "type": "string",
    "default": "",
    "maxLength": 100,
    "minLength": 1
   },
   "default": [
    "group-a",
    "group-b"
   ],
   "maxItems": 100,
   "minItems": 0
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/purchase-order-imports-declared-column-projection-835dde22/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)