{"uid":"cap_FRbf5R07wMWLG8TviilI8","slug":"purchase-order-imports-declared-column-projection-835dde22","name":"Purchase Order Imports — Declared Column Projection","description":"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.","url":"https://market.datapackvibe.com/x402/assistant-bx-csv-purchases-projection?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"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}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_JFOhYKMGm73TpZkpDbsi4","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"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.","exampleAgentPrompt":"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.","exampleUseCases":[{"title":"Pre-import purchase order validation","prompt":"Before I load this purchase order CSV into our system, can you run a declared column projection check on it? The file has columns purchase_id, placed_on, vendor_id, ordered_units, and order_amount, vendors should only be group-a or group-b, order amounts must be between 0 and 500000, and I'm using comma as the delimiter."},{"title":"Vendor category compliance check","prompt":"I need to verify that all vendor IDs in my purchase order CSV are from the approved list — only group-a, group-b, and group-c are allowed. Can you run a column projection validation on it with a comma delimiter and flag anything that doesn't match?"},{"title":"Order amount range enforcement","prompt":"Can you validate this purchase order import file and make sure the order_amount column stays between 1 and 999999? I also want to catch any cells longer than 200 characters. It's comma-delimited with the standard purchase_id, placed_on, vendor_id, ordered_units, order_amount columns."}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T18:47:58.241Z","isFirstParty":false,"canonicalSlug":"purchase-order-imports-declared-column-projection-835dde22"}